VB.NET 2005 and Crystal Reports

[L0stAngel]

Hello, I am switching from VB 6.0 to VB.NET 2005 and have a question. .NET 2005 comes with Crystal Reports, and I am used to VB 6's Data Reports. Is there a way to do the following:

Custom Code in a crystal report (like you can set a custom query for the reports datasource in vb6.) The following is a situation I am talking about:

Once opening the report, the user is prompted for a StartDate and an EndDate. When the user enters a start and end date, the report uses the query
"SELECT * FROM tblName WHERE Date BETWEEN '" & StartDate & "'AND '" & EndDate & "'"

Also, how can I change the size of the lines in a line graph? Currently the graphing lines are very thin when printed...

 

[jebenson]

Yes, you can add parameters to a Crystal Report and it will prompt for values when run, and will apply the parameters to your query.

Try the Crystal Reports forums on this site. On the top of this page, close to the Tek-Tips logo, there is a search box. Make sure the dropdown below the search box shows 'Find A Fourum' and search for 'Crystal Reports'. You will probably get the best VB .NET/Crystal Reports info. on the Business Objects: Crystal Reports 3 Integrate forum.

Good luck.


I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

 

[L0stAngel]

Thank you very much jebenson! I just posted there.