Crystal Reports
-
I need help on Crystal Reports. Can anyone tell me where I can find a manual on the net that can help me? :confused:
-
I need help on Crystal Reports. Can anyone tell me where I can find a manual on the net that can help me? :confused:
There is built in help for Crystal Reports in VS.NET. I've also found Google to be invaluable, particularly Google Groups. You might have luck at the CrystalDecisions webiste too - there's a lot of stuff there. -- Ian Darling
-
I need help on Crystal Reports. Can anyone tell me where I can find a manual on the net that can help me? :confused:
What are you trying to do exactly? You also might want to try looking in Google groups. The Crystal that comes with .NET is very buggy so if somethings not working it might not be a problem with your code.
Beware the chickens, for in their silence, they plot... Life is too short to be taken seriously. -- Oscar Wilde
-
What are you trying to do exactly? You also might want to try looking in Google groups. The Crystal that comes with .NET is very buggy so if somethings not working it might not be a problem with your code.
Beware the chickens, for in their silence, they plot... Life is too short to be taken seriously. -- Oscar Wilde
:confused:I don't have a problem with creating the report itself (it is alot the same as Microsoft Access reports). I don't know how to edit the report at runtime. When the user selects only a certain group of participants to display (for instance participants with the surname beginning with S...). How do I use that SQL query to display only the selected people?
-
:confused:I don't have a problem with creating the report itself (it is alot the same as Microsoft Access reports). I don't know how to edit the report at runtime. When the user selects only a certain group of participants to display (for instance participants with the surname beginning with S...). How do I use that SQL query to display only the selected people?
Ohhh ok so you're having a problem with you're SQL statements. The way I use crystal is that I point to a stored proc on my SQL database and pass the parameters to the stored proc. I'm guessing you're building the SQL statement in the crystal report itself. You're going to have to make a parameter and pass that to your SQL statement: e.g.
CREATE PROCEDURE spGetUsers @Letter VARCHAR(1) AS SELECT [Columns] FROM [Users] WHERE[Surname] LIKE @Letter + '%'Should work - You just have to pass that @Letter varchar to the statement. Hope this helps - if you need any more help just ask. Isn't there a lecturer at Tukkies? :)
Beware the chickens, for in their silence, they plot... Life is too short to be taken seriously. -- Oscar Wilde
-
There is built in help for Crystal Reports in VS.NET. I've also found Google to be invaluable, particularly Google Groups. You might have luck at the CrystalDecisions webiste too - there's a lot of stuff there. -- Ian Darling
Hi, I found this really helpful... http://www.crystalreportsbook.com/ Hope that helps, Martin