VB.NET 2005 / 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...

 

[synapsevampire]

In the preview report mode, right click the line in the chart and select Format Connector Line (at least that's CR XI).

As for passing parameters, check:

http://support.businessobjects.com/fix/samplescr.asp#02

-k

 

[L0stAngel]

The preview report mode/clicking a line does not work. When I click on anywhere in the graph...it just selects the WHOLE graph.

 

[synapsevampire]

You're correct, you should be clicking the line, not right clicking it, and it may be differnt in your version, I think that's a trimmed down version of Crystal.

What happens if you right click the graph?

-k

 

[L0stAngel]

I wasn't right clicking...but when I do it brings up the following:

Format Object
Chart Expert
Chart Options > Template > General > Titles > Grid
Cut
Copy
Paste
Delete

Its wierd how the graph is, as one line is readable (and thicker than the rest). But the rest are VERY thin.