You are not logged in.
- Topics: Active | Unanswered
Announcement
Migration of this forum
Dear users of this forum,
we are pleased to inform you that we will be updating the software behind this forum in the near future.
Existing posts, users and categories will remain untouched.
Important:
- Each user will need to reset their password.
- Please select "I forgot my password".
- Enter the email address you used to register in this forum.
- You will receive an email with a link to set a new password.
- Please choose a new (secure) password and confirm the process.
We will keep you informed in the pinned thread.
Kind regards,
Your ReportServer Team
Migration des Forums
Liebe Nutzer dieses Forums,
wir freuen uns, euch mitteilen zu können, dass wir in naher Zukunft die Software hinter diesem Forum aktualisieren werden.
Existierende Beiträge, Nutzer und Kategorien bleiben weiterhin bestehen!
Wichtig:
- Jeder Nutzer muss sein Passwort neu vergeben.
- Wählt dazu einfach "Ich habe mein Passwort vergessen".
- Gebt die E-Mail-Adresse ein, mit der ihr registriert seid.
- Ihr erhaltet eine E-Mail mit einem Link zur Passwortvergabe.
- Bitte wählt ein neues (sicheres) Passwort und bestätigt den Vorgang.
Wir halten euch im angepinnten Beitrag auf dem Laufenden!
Mit vielen Grüßen
Euer ReportServer Team
#1 2018-02-08 22:11:40
- tcarr
- Member
- Registered: 2018-02-08
Datasource Parameter No Default Value Getting Selected
Hello,
I have a data source parameter that uses a user variable to get the first option, which should be the default, so certain users don't have to manually select the variable, but at least visually it doesn't get selected. If I run the report without selecting a value for the parameter the results show that the first value was selected as the default so it's getting selected behind the scenes. Does anyone know how to fix this?
Offline
#2 2018-02-09 20:45:46
- IF_Eduardo
- Administrator
- Registered: 2016-11-01
- Website
Re: Datasource Parameter No Default Value Getting Selected
Hi tcarr,
could you please post some screenshots especially of your parameter configuration? Which reportserver version are you using?
Regards,
Eduardo
Offline
#3 2018-02-15 20:35:33
- tcarr
- Member
- Registered: 2018-02-08
Re: Datasource Parameter No Default Value Getting Selected
Hi eduardo,
I'm using version RS3.0.3-6002. Here are the screenshots:
Business Unit Selector gets the user variable, Business Unit is the parameter I'm having trouble with.
Dependency set up:
Query getting the result for the user variable first:
Executing the report:
Last edited by tcarr (2018-02-15 20:38:24)
Offline
#4 2018-02-19 10:38:44
- IF_Eduardo
- Administrator
- Registered: 2016-11-01
- Website
Re: Datasource Parameter No Default Value Getting Selected
Hi tcarr,
thanks for your screenshots. We are investigating this in the ticket RS-2877 and will update here when we have more information.
Regards,
Eduardo
Offline
#5 2018-02-19 12:33:28
- IF_Eduardo
- Administrator
- Registered: 2016-11-01
- Website
Re: Datasource Parameter No Default Value Getting Selected
Hi tcarr,
have you saved any value in the "default values" option of the datasource parameter?
Regards,
Eduardo
Offline
#6 2018-02-19 17:27:03
- tcarr
- Member
- Registered: 2018-02-08
Re: Datasource Parameter No Default Value Getting Selected
Hi Eduardo,
No value has been saved as the default since we want the default to dynamically change for each user. According to the documentation the first value returned in a datasource parameter's query is automatically selected as the default if one wasn't selected manually. My intention is to allow users to schedule and run reports with personalized default parameters.
Last edited by tcarr (2018-02-19 17:28:36)
Offline
#7 2018-02-20 11:11:59
- IF_Eduardo
- Administrator
- Registered: 2016-11-01
- Website
Re: Datasource Parameter No Default Value Getting Selected
Hi tcarr,
this is right, and this the behavior you observe in your results. It is only the visual part that doesn't show the correct entry, as you noted. This seems to be a bug and will be investigated in RS-2877.
Regards,
Eduardo
Offline
#8 2018-02-20 19:08:00
- tcarr
- Member
- Registered: 2018-02-08
Re: Datasource Parameter No Default Value Getting Selected
Hi Eduardo,
Thanks! I look forward to a fix.
Offline