Hi wvmikep,
I need to do exactly what you have stated initially in the post abt creating a yahoo sort of trail.
Would like to know how u solved this problem.
I read the link provided by ColinM and I tried executing the procedure speified but I kept getting an error
abt Cursor does not exist...
You can use parameters to passon the value to the sub-report.
IF the parameters to be used for the main report and sub are similar then link them in crystal reports that way whatever value u passin the main report will be taken by the sub report as well.
To do this, u can create a DTS package which exports your data from the dbf file to the SQL Server.Once you have created a DS package save it.
Now you can write a VB application which will execute your DTS package.
The VB application can be scheduled to your time.
I have done this, if you are...
Select count(tasks) from table where status == 'Complete' for user.
Select count(tasks) from table where status == 'Tentative' for user.
Was this what you reqd.
To call a report
Creat an application object and then a report object and the call the report.
All this is given in the docmentation.
If you have parametere in your report, pass them from the page.
If you still don't understand I can post the code for you.
Your subreport that is added in your main report.Right click on it and click change sub-report links and see if the links are properly set ie values youu require are being passed properly.
I guess what you want to do is pass Parameters from your ASP page to your Crystal report which is using a stored procedure.
1)First, in your report create parameters for whatever fields you require.
2)Then in the report itself, if you want to make any selection based on these parameters, on the...
If your database is SQL server then you need to give access to your script to access the database, this can be done by:
Set DatabaseTablesCollection = Session("oRpt").Database.Tables
For Each Table in DatabaseTablesCollection
Table.SetLogonInfo "dsnName"...
Here is a break down of the Simple Preview Report example. This example contains all the basic elements that are required to bring up a report over the web through ASP.
reportname = "SimplePreviewReport.rpt"
In our samples you will see the report name set as the variable...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.