Running a report from URL

[Jorge]

Hi there!

Could you help me with the next please?

I'm trying to run a report from a URL with a single parameter and I have followed the steps described on Manual resulting an URL as follow:

http://localhost:8080/art/runReport?reportId=137&param1=helloworld

For some reason, the report is running but not transfering the parameter from url to the query. The query is an sp as following:

exec mysp @param1=#param1#

Surprisingly It is running well when I run the report from Art app so, the parameter is well defined on report.

I tested this with another report with 2 parameters and it is working well from URL.

Do you have a clue? By the way, I'm using ART 5.0

Thanks in advance!

[Timothy Anyona]

Hello,
Please try with p-param1 i.e. http://localhost:8080/art/runReport?reportId=137&p-param1=helloworld

[Jorge]

Hi Tim!

Grand! It was that!

Thanks a lot!

[Timothy Anyona]

Great. Glad to hear.

[Jorge]

Sorry Tim,

Is there any way to get the ART userid as SQL parameter?

Regards!

[Timothy Anyona]

Not really. But you can use it in your query using the :username: placeholder.

[Jorge]

Your're grand Tim!

Thanks!