Subreports, VS.NET, ADO.NET vs OLEDB 1

[Alcar]

I have been using crystal reports alot lately and I enjoyed the results from it. One thing I don't like (only thing maybe) is the report designer in VS.NET.
Besides these considerations I had no problems with creating reports and adding them to my applications until yesterday. I was asked to create a complicated report, that resulted in designing subreports and importing them in the final report.

Here is what I usually do when I create a report:

1) create new report.
2) select an OLEDB SQL Server DataBase and the stored procedure that will give me the fields (old technology).
3) fill the report with fields and formulas.
4) save the report.
5) create an aspx file that creates a new instance of the report.
6) access the Database through ADO.NET and create a DataSet.
7) pass the DataSet as the DataSource of the Report.
8) export the Report to pdf file.
9) view the pdf file on the browser.

Now, creating the subreports with the same OLEDB access type (old technology) and trying to view the primary report on a network that refuses OLEDB connections I have a problem.

The way to solve it is to create those subreports through ADO.NET datasets in design mode. Right. I've tried and found no way since the crystal report designer, in the field window, under Database connections and in the ".NET DataSets" folder always gives me "no items found" and no way to create a dataset through ADO.NET (at least not from there).
Is there a way I can get this monkey off my back?

Thanks in advance... Daren J. Lahey
Just another computer guy...

 

[shaikhintekhab]

Did you find any solution in this?
Where can i find code for converting all the asp
web code ( the old one) to aspx.
I mean I have RDC and ActiveX Viewer
ans asp code from samples to pass parameters to
stored procedure.
I want to change this to ASP.NET.
Can you help mne in this?
Can you send me some sample.

 

[Alcar]

I have found this useful list of VB.NET examples that are clrearing up things ALOT!!

here, take a look

http://support.crystaldecisions.com/communityCS/TechnicalPapers/apps_vbnet.pdf

hth Daren J. Lahey
Just another computer guy...

 

[shaikhintekhab]

Thanks for the link.
Looks helpful.

 

[Alcar]

Well, I got myself a few steps further (pats himself on the shoulder). Now I have a strongly typed DataSet that holds three views:

View1 (for the main report)
View2 (for the first subreport)
View3 (for the second subreport)

I am also creating the subreports inside the main report, without using rpt files, all using the DataSet as the DataSource. The only rpt file I have is the main report one. I have linked in the DataSet the three views, and I have also linked the subreports to the main report.
As I run the application I notice that it queries the DB and I get the Adobe Acrobat Reader Splash screen out. It hungs there for a while. The page isn't loading anything else, the DB is not being touched. I look on the HD for the pdf file created by the application and I find it filled with all the NON-Field related objects. (line boxes).

Any ideas?
Daren J. Lahey
Just another computer guy...