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
Please avoid sending emails to my personal mail:
write your doubts as thread in Codeguru
Crystal Reports Forum.
This will help all people having similar matters, and will let people who know solutions on the specific topic
share their knowledge.
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...
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
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
Please avoid sending emails to my personal mail:
write your doubts as thread in Codeguru
Crystal Reports Forum.
This will help all people having similar matters, and will let people who know solutions on the specific topic
share their knowledge.
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
Please avoid sending emails to my personal mail:
write your doubts as thread in Codeguru
Crystal Reports Forum.
This will help all people having similar matters, and will let people who know solutions on the specific topic
share their knowledge.
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
--------------------------------------------------------------------------------
But the problem is that if I do so, the Name comes in a different section something like this
Name Date Sales
X1
Date1 100
Date2 200
I want X1 to be on the same line as Date1 and 100..
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
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)
PEARL Custom Reports.subPEARLSR19_1 "Legal Entity={?Legal Entity}" "Vehicle={?Vehicle}" "GLDate={?GLDate}"
This allows us to reference the OLEDB provider and pass parameters back from crystal to the OLEDB provider.
Has anyone come across this problem and/or know of how to resolve this issue.
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.
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.
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??
Thanks very much. Greatly appreciated!
Last edited by jeffvb; January 7th, 2004 at 02:58 PM.
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.
Last edited by supi_1976; January 9th, 2004 at 05:10 AM.
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?
* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.