Crystal with .net and stored procedure

[devdev]

Need to create an rpt based on a DataSet.
This dataset should be filled from a Stored Procedure.

So I first create an xsd with a table with all the fields used in the stored.

Then at the rpt designer: Add Database/Project Data/ADO.Net DataSets we find the xsd but when we tried to add it to "Selected Tables" it does not allow us, and expanding the xsd we do not see any table but "... no items found"

Any idea???

 

[Guest_imported]

curious if you found a solution to this? i'm trying to do something similar with .net and crystal and am having same issue.

also :: have you done any work with saving data with report with .net? i'm trying to load an .rpt in code without having to provide login info, but used saved data and am having no luck?

thanks in advance

 

[Guest_imported]

I had the same problem. I just figured out what it was.
First, I am assuming that you added and filled a data table in your Dataset. Otherwise I think you will have other problems. So, assuming you created your dataset then added a table and filled it. The reason you don't see the tables in your dataset on the explorer is because in the Database Explorer you have turned off View Tables. To fix this:

Right Click in the Report.
Choose DataBase -> Then choose LogOn/Off Server.
In the Options Button make sure that the Tables is selected.
NOTE: If you don't see the Tables right away in your dataset, Re-Expand the DataSet in the Tree view and they should appear.