You are not logged in.
Hi,
I want to embed Report Execution View again.
I created datasource parameter for report. The query for values should read column "id" from my table after filtering by other parameter given in URL.
The problem is that I need to have all data from the query as default values. How can I automatically set that all rows returned from query will be values of filter used in report?
Unfortunately, I cannot find such possibility while defining datasource parameter.
I know that I could put array of values as filter in URL but I want to avoid it because I have my values for filter in datasource. What's more there could be a lot of values in filter so I cannot control the URL length and in addition to this all identifiers will be easy to see in HTML by user (URL of the embedded report)
How can I do it?
As example (Postgresql database):
My query for report:
SELECT u.*
FROM public.user u
WHERE $X{IN, u.id, PARAM_USER_IDS}
My query for datasource parameter PARAM_USER_IDS (it depends on text parameter PARAM_GUID):
SELECT id
FROM public.user_filters
WHERE guid=$P{PARAM_GUID}
URL for embeding report:
http://127.0.0.1:81/reportserver/Report … nyGuidHere
My reportserver version: #
version=RS3.0.6-6006
schemaversion=RS3.0-12
Offline
Hi Patryx,
After this...
...
As example (Postgresql database):
My query for report:
SELECT u.*
FROM public.user u
WHERE $X{IN, u.id, PARAM_USER_IDS}
...
This configuration in defaut select all
selection mode: Multiseclect
selection style: Popup
Regards,
El Palacio
Offline
No, I tried it before and now again and it doesn't work.
"This configuration in defaut select all" - it's not true here unfortunately.
When I use URL for Report Execution View with PARAM_GUID, the right report is opened, GUID is filled but PARAM_USER_IDS is null, so I get all values in report (as without WHERE $X{IN, u.id, PARAM_USER_IDS}.
Of course I can open "Parameters" tab, double click on PARAM_USER_IDS and then I can choose all right values for that GUID but the idea is how to get all values as selected automatically (as default)...
Offline
Hi Patryx,
we are looking into this.
Regards,
Eduardo
Offline
Hi Eduardo,
Any success in resolving this issue?
Offline
Have you checked it?
I still have no data selected as default in datasource parameter defined as in my previous posts in this topic.
Last edited by Patryx (2019-05-16 10:35:17)
Offline