Getting data from a report

[constructor]

Hello NG,

I'm wondering whether it is possible to get data back from a report.
For instance, when a large report has finished and at the end there is a
total, how can I get that value back to my app?
I tried it with input variables and SalReportGetNumberVar but I didn't find out, how I can set the value in
the report.
Maybe this isn't the right way at all.

Can anybody help me?

TIA

Uwe

[Jeff Luther]

Thanks a good question, but I didn't think there is a way, either. RB just doesn't have a way to assign an input variable. It can access one declared in the QRP, but the Get and Set have to be done from within the TD app itself.

The only way I can think of to get a value would be to generate it yourself, if you can, in SQL from within the app. Example: Maybe you want a total of an input item, etc. You have access to the INTO var you're passing to RB during SAM_ReportFetchNext. Keep a local TD var. that sums that value within each SAM_Report msg. before your code does its Return.

Anyone else have any ideas?

[Peyote]

I think Jeff's solution is the only way. Sum the value in the reportfetchnext and get the value at the end of the report.

[constructor]

Hello folks,

thanks for your responds.
I was afraid you might say that .
Well then.
So I have to dig down into yerars old foreign code and
have to implement count variables for all the queries.

This will be a really nice weekend...

Best regards
Uwe