How to pass the query to Data Environment Designer 1

[djayakum]

hello ,

iam using now datareport to create reports in vb
application .

in my application i need to show report
according to id value .

how to pass the id value to data environment
designer command.otherwise how to pass the
query.

which one is advisable to create the reports
Data Reports or Crystal Reports.

If Crystal report is good , give
me some brief idea about crystal reports.

thanks

bye

 

[BlackKnight]

Hi,

If I understand you correctly you want to know how to pass parameters into your query/stored procedure that has been added to a data environment? I assume that the query has been coded correctly to accept parameters? If so then do the following:

'Assumes query is receiving one parameter named 'Parm1'
with dataenvironment1.commands("dbo_GetRecords&quot
.parameters("Parm1&quot = "100"
set rs = .execute()
end with

Have a good one!
BK

 

[chriscorran]

Hi,

I too need to pass a param to a stored procedure inorder to get the relevant information.

The thing is though, within my data environment, the stored procedure will get information which in turn will be used by child commands.

As a child command needs to have a relation set up before hand, inorder to link it to its parent, it doesnt work as the parameterized stored procedure has not been called yet with its parameter !!!!!!!! Help !!!!!!!!!

If you have any hints on what can can be done it'd would be greatly appreciated.

Many regards,

Chris