DataReport Designer - Using Parameters 1

[GerardMcL]

Hi,
I have a DataEnvironment set up and in the SQL Builder I have
SELECT * FROM <table> WHERE ID = ?
Then in Parameters window
Param1 - set to Int
value = Enter ID
How do I take thi svalue and use it to define what records are shown in the report.

Dont think Im far off with this but cant get it working
Get message saying
Failed getting RowSet from data source

 

[cbsm]

This i show I am doing :

If DataEnvironment1.CnnReport.State <> 0 Then DataEnvironment1.CnnReport.Close
DataEnvironment1.CnnReport.ConnectionString = "Provider=MSDataShape.1;Persist Security Info=False;Data Source=" & DataBaseLocation & ";Data Provider=MICROSOFT.JET.OLEDB.4.0"

DataEnvironment1.CnnReport.Open
DataEnvironment1.cmdReport iValue
rptReport.Show vbModal
DataEnvironment1.CnnReport.Close

CnnReport is the connection in the dataenvironment (called DataEnvironment1), cmdreport is the command and rptReport the datareport.

iValue is the parameter from my query.

If you want the user to enter the value, you could use an Inputbox or someting like that.


(Provider=MSDataShape because I use also child command - depending on your case, you might have to use another connection string - tell if you need help on this also)

 

[garths2]

see thread709-88923

It's a long post so do a search for RowSet on that page. There was never a reply to the fix so I don't know if it fixed the problem but I thought I would point you to it anyway since I could not reproduce your problem in my environment.

Hope it helps.

-GS