1 Attachment(s)
Crystal Report Parameter in ASP
Hi,
Find out the ASP Sample Code attachment, I hope this sample will solve your problem.
yours friendly,
K.Babu
Quote:
Originally posted by endrue
I've read about that sample that you gave to me, about SAmple to make report over the web, but the problem is i can't pass the parameter value.....not how to preview it....maybe u can't read the problem carefully...cause i feel my problem is weird.....and i get mad of this problem,coz ake me stuck on this too long for my project...thx anyway
supress column if duplicated
Hi
I am preparing a sales report grouped by month and year
The data is something like this
Name1 MonthYear Year Date Sales
X1 200203 2002 date1 200
X1 200203 2002 date2 300
X1 200204 2002 date 400
I have grouped by MonthYear and then Month
The report format should be like this
Name Date Sales
x1 date1 200
date2 300
200203 500
date 400
200204 400
2002 900
I have done supress column if duplicated for name1.
The problem is that the name is not supressed for outer group.
The report that I have now is something like this
Name1 Date Sales
X1 date1 200
date2 300
200203 500
x1 date 400
My issue is that I dont want X1 to be repeated for the next month year group.
Please help...
Thanx for reading through...
I am using crystal reports 9.
Rgds
Kudla guy
changing the field data in the report
hi
i am preparing a report which contains values -1 and 0
if value is -1 it is to be replaced by string pp
else it should be blank. the field name is papercode. how can i do this?
thanks
Re: changing the field data in the report
Hi,
Insert Formula field in the Crystal Report,
inside that formula validate the papercode
eg. if papercode = -1 then "pp" else ""
Yours Friendly,
K.Babu
Quote:
Originally posted by snehal G
hi
i am preparing a report which contains values -1 and 0
if value is -1 it is to be replaced by string pp
else it should be blank. the field name is papercode. how can i do this?
thanks
Re: supress column if duplicated
Hi,
Group by name1, Year, Month.
So that it will come once in the name1 group.
Yours Friendly,
K.Babu
Quote:
Originally posted by Kudlaguy
Hi
I am preparing a sales report grouped by month and year
The data is something like this
Name1 MonthYear Year Date Sales
X1 200203 2002 date1 200
X1 200203 2002 date2 300
X1 200204 2002 date 400
I have grouped by MonthYear and then Month
The report format should be like this
Name Date Sales
x1 date1 200
date2 300
200203 500
date 400
200204 400
2002 900
I have done supress column if duplicated for name1.
The problem is that the name is not supressed for outer group.
The report that I have now is something like this
Name1 Date Sales
X1 date1 200
date2 300
200203 500
x1 date 400
My issue is that I dont want X1 to be repeated for the next month year group.
Please help...
Thanx for reading through...
I am using crystal reports 9.
Rgds
Kudla guy
how to create a crystal report of a rtf file
hi,
How can I create a crystal report of a rtf file.
Any ideas or suggestions is appriciated
thanks,
bye,
Crystal Report Data Refreshing
I am using crystal 8.5 with VB front end.
i am using VB GUI for devlopment not
crystal. ADO recordsets are retriving data
for the reports. then retrived data is added
to report using following syntax
Set fld = m_Report.Section3.AddFieldObject
("{ado." & valarr(0) & "}", 400, 0)
i am using Crystal Report Viewer to
view/execute report
Now Problem is,
when report is run for first time it
produces expected results but if its re-
runned/re-executed new data overlaps older
data.
in short, i want report to refresh and
delete old data when new execution takes
place.
Any input will be deeply appreciated
-Rohan :)
Crytal Report Navigation problem
Hi Mr. K Babu
1. I'm building the reports using crystal report included in MS VS .Net (ASP.net).
2. On runtime, to display report, I am using CrystalReportViewer by passing selection formula.
4. This works fine, It can only navigate to page 2, after that, clicking on the next button return the same page (page 2) over and over again.
5. Clicking the 'last page' button will bring you to the last page of the reports.
6. In short, the report can only be viewed on page 1,2, and the last page
Please help me...
Thanks in advance.
Blob field blank after update to CR9
Hello everyone,
I'm using a blob field in a crystal report (v 8.5) to display an image stored in an access 2000 database (embedded bitmap in an ole field). This image was created by visual basic via picture box. Access shows this data as "binary-long data".
Crystal reports 8.5 shows this data correctly as an image.
But recently I had to update to crystal report 9 and now the image is blank!!
Does anybody know what the problem is?
(when I store an bitmap file via copy&paste in the access field, cr9 shows the image correct)
How can I store the bitmap via vb in the access database in a way that access shows it as "bitmap" data?