cancel
Showing results for 
Search instead for 
Did you mean: 

How is the easiest way for using parameters

Former Member
0 Kudos

We develop a companie application in Visual Studio 2008 VB. Until now we are using a OpenSource Project for creating reports and prints. But the Reporting engine have now support, so we will change our Reporting Core and use "Crystal Reports for Visual Studio 2008 / Crystal Reports 2008"

Our application have a wrapper for the reporting part. I will descripe in short word the current way and why: The Report-Definition ist a XML-File (like RDL). Our Application will be use in a VPN so we want to collect data taht only be used to the report. Our wrapper create a second XML-File, called RDL-Extension (=RDLX).

With our wrapper we can create Fields to collect user-parameters like "Startdate", "Enddate", "Username" etc. It´s possible to design Paramters that a dynamicly, like if you select the Usergroup "Admins" then the second control have only the names of our admins to select.

If all paramters selected then the wrapper create a SQL-Statement and get the data from the database in a dataset. The dataset will be set as datasource of the report and the report will be shown.

So: it is important for us that only the data that needed will be transferd from database to report and the the user can select in a form all needed paramters bevor he can see/print the report.

Our question: Have CRVS2008 / CR2008 have the needed requirement or must we use our wrapper again? What is the correct way to design the reports to fullfill the importent points?

Accepted Solutions (1)

Accepted Solutions (1)

former_member183750
Active Contributor
0 Kudos

Not sure if I understand your query fully, but I believe you will be creating a dataset and passing that to the report(?). If my interpretation is correct see the following:

[Crystal Reports Guide To ADO.NET|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/401c4455-a31d-2b10-ae96-fa57af5aec20]

[Crystal Reports for Visual Studio .NET - Walkthrough - Reporting Off ADO.NET Datasets|http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/2091d0c3-da1d-2b10-22be-a3426b183f75]

[Troubleshooting Issues with VS .NET Datasets and Crystal Reports.|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13270] [original link is broken] [original link is broken] [original link is broken];

Also, download the developer help files from the following link:

https://boc.sdn.sap.com/developer/library

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

Answers (0)