If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register or Login
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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

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

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...

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

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

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...

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...

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

Meditate.
Live purely. Be quiet.
Do your work with mastery.
Like the moon, come out
from behind the clouds!
Shine

Crystal and a UDL file

Hi,

I have written a series of crystal reports, connecting via a UDL file pointing at an OLEDB provider. Now the reports have passed testing, I have changed the UDL, but the reports don't seem to care... they still reference the original Data Source and Catalogue (itís as if crystal hard codes the connection parameters into the report rather than referencing the UDL each time )

I have tried to change the data source location within crystal, but when I point the report at the new connection I get the error message "Some tables could not be replaced, as no match was found in the data source. Please specify the table required for any unmodified tables"

The reason that the report canít find tables is that the connections are added as commands within the Add Command function.(example below)

I have a report in CR8.5 and a subreport that goes into the first report. Is there a way that I can access the subreport fields from within the main report to be used in calculations, using either Formula editor or directly from within VB6.

speed print

Dear Mr. Babu / friends

i want to take my reports (from crystal report with vb, Access) very speedly like Foxprow reports (Dos version). what are the precautions i have to take while designing in crystal report. i am using dot matrix printer also. what about font, size that help fast printing.

crystal report problem

Dear Mr.babu/friends

my crystal report is working 100% perfectly. But if i alter my underlying table (change the datatype or width) , the report is not working properly. so what setting i have to make while designing the report.

Hi Mr Babu or other Crystal developers,
I am prompting for a parameter from a pick list on an ASP page using Crystal 9. I create the parameter pick list in Crystal via the "Set default values" > "Import pick list" tool. In the Crystal development environment itself, my pick list contains 300+ items. In my ASP page, on the report viewer parameter entry page, the pick list only contains about 38 of the items. Any ideas??

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

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!!