Getting data from a report

Discussion forum about all things Report Builder (all versions).
constructor

Getting data from a report

Post by constructor » 14 Jan 2010, 10:44

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

Re: Getting data from a report

Post by Jeff Luther » 14 Jan 2010, 22:57

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

Re: Getting data from a report

Post by Peyote » 14 Jan 2010, 23:43

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

Re: Getting data from a report

Post by constructor » 16 Jan 2010, 10:22

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... :mrgreen:

Best regards
Uwe

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 0 guests