VB6/CR: Report with local recordset!

[jose74]

Hi,

I got a report with 2 subreports bound to sql server to get the data structure. Now I set a local recordset with the same structure but without database connection as datasource and CR always asks me for connection information :-(

Is it not possible to do something like that? The recordset is filled by a multiselection in a listview and so i can´t create a sql query.

Can anyone help, plz?

 

[vidru]

What version of Crystal? If CR 8.5 or lower, as long as the report was created using the active data driver (which I think is pdsmon.dll), and the recordset's fields match the names and datatypes of the original report, you shouldn't have any problems handing it a recordset. With CR 9 and up, if the report was originally created using OLEDB/ADO then again, it shouldn't be an issue.

Another option would be to use a ttx file that defines the layout of the data. You can find a sample here:

http://support.businessobjects.com/communityCS/TechnicalPapers/scr8_ttxado.pdf.asp

-dave

 

[jose74]

thx,
we now use CR10 and I created it with OLEDB/ADO, but the login dialog appears when I use the setdatasource method.
I even tried to set the connection properties at runtime - but no changes.