Joined: 19 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 150
Topic: Dynamic Parameter Select All Posted: 26 Mar 2010 at 1:13am
I have a report with a dynamic parameter which allows multiple values. You can select names a few at a time, or click on the double arrow to select all names on the list. My users want the names selected to show in the title of the report. So far, so good, but when they have selected all, they want the word 'All' in the title. When we were using static parameters, it was always an option. But this list of names is very fluid, and it needs a dynamic parameter to avoid constant maintenance. I can give them the list, but is there any way to determine if they have clicked on that double arrow? TIA
Joined: 19 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 150
Posted: 26 Mar 2010 at 5:13am
That is a great idea. I've got it working for the main report just as I wanted. I still have to make it cross to the linked subreport, but I'm getting there Thank you
Joined: 19 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 150
Posted: 31 Mar 2010 at 1:14am
I was a bit too premature there. I can get All as a parameter option, but I cannot work out how to make the report use all the possible people when I do.
I did have "{PEOPLE_LOOKUP.FULLNAME_SFI} = {?Caseworker} " in the report selection, and that works well if they select any particular ones or the lot. But if {?Caseworker} = 'All' how do I get all of them in to the calculations? Maybe I have the sql command wrong, I put SELECT rc.ROLE_CODE, plk.FULLNAME_SFI FROM (ROLE_CODE rc INNER JOIN ROLE_LINK rl ON rc.ROLE_CODE=rl.ROLE_CODE) INNER JOIN PEOPLE_LOOKUP plk ON rl.PERSON_ID=plk.PERSON_ID WHERE rc.ROLE_CODE='CSSS' union select rc.ROLE_CODE, 'All' from ROLE_CODE rc WHERE rc.ROLE_CODE='CSSS'
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 01 Apr 2010 at 3:09am
The report selection is basically returning a true or a false to include or exclude the record, so you can modify the if statement to be something like:
{PEOPLE_LOOKUP.FULLNAME_SFI} = {?Caseworker} OR {PEOPLE_LOOKUP.FULLNAME_SFI} = "All"
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum