Populating a crystal report using Stored procedure
-
I'm using a stored procedure to populate a crystal report, But I get repeatative(duplicated) information on my report- something like 66 pages instead of atleast 2. I want to produce a transactions statement for a particular user, using the crystal report, with the stored procedure getting data from multiple tables, accepting as a parameter the name of a particular client(user). Am I using the crystal report for good purpose or may be the stored procedure isn't just a way of doing it?
ML Lingwati
-
I'm using a stored procedure to populate a crystal report, But I get repeatative(duplicated) information on my report- something like 66 pages instead of atleast 2. I want to produce a transactions statement for a particular user, using the crystal report, with the stored procedure getting data from multiple tables, accepting as a parameter the name of a particular client(user). Am I using the crystal report for good purpose or may be the stored procedure isn't just a way of doing it?
ML Lingwati
This is really not a ASP.NET question. But I could answer for this. Have you checked your Stored Procedure which the same parameters? If it returns correct records then there would be no problem. Seems like you must missed some JOINs in the Stored Procedure
Castle Rider
What if I freeze??? Don't forget to breath...
My: Website | Yahoo Group | Blog Spot