+1 800 256 3608 (toll-free in North America) or +49 7531 90 60 10| service@combit.com

Report parameters

reportserver

(Bjørn Holm) #1

Is it possible to pick up parameters from the report url and use these as report parameters?
I would like to pass e.g CustomerID as a parameter in the URL, and set this as a @CustomerID value in my report. I see no choice for this when I declare my report parameter, only available choices under “Available values” are “From Predefined Values”, “From Datasource” and “Manual input”.
A new option here called “From URL” would be nice.
Then I could have a link to the report e.g like this:

http://localhost/combitreportserver/Report/Preview/09BD81B5-9FA3-4FEE-94C6-D1D2A6E84212?exportCfg=00000000-0000-0000-0000-000000000000&CustomerID=cb23007b-6b8e-49dc-8785-a5cda7e96d29

or this:
http://localhost/combitreportserver/Report/Export/09BD81B5-9FA3-4FEE-94C6-D1D2A6E84212&CustomerID=cb23007b-6b8e-49dc-8785-a5cda7e96d29


(Bjørn Holm) #2

Was my question not clear? Or have I posted this question wrong, or in the wrong forumgroup? I see no reply from the official Combit support?
The question is how to pick up URL parameters and access these from inside the report.


(Hans Peter Reische) #3

Hi!

Well i think the report server can’t do that right now.
Only the “ODATA” data source (also REST based) can handle parameters at the moment, because there is a there is a standard way to do this.
And SQL based data sources too :slight_smile:

Hope that helps

HP


(combit Support - Christian Rauchfuß) #4

Hi Bjørn,

thank you for your post.

Yes, it is possible by using the REST-API as Mr. Reische mentioned it. The REST-API needs to be activated in the Advanced Settings of the Report Server first. A URL using report parameters could look like this :

http:///combitReportServer/api/v1/report//export?clientid=&clienttoken=&$CustomerID=

You need to create a specific Report User as “API Account with Token” to get the ClientID and the ClientToken.

Please have a look into the Report Server manual for further detailed information.

Best regards,

Christian Rauchfuß
Technical Support
combit GmbH