Jump To Report with Multi Valued Parameter Value

I have a mutli-valued, (cascading? dependent on other parameter
values) parameter whose values are retrieved from a database query. I
want to set the default value of the parameter to be the same as the
"Select All" function. How can I acheive this?
To explain, I have two budget reports. The first is a summary, which
groups lines by expense codes and then displays a total. Each dollar
figure is set to click through to the detail report, and filter the
results based on the expense code from the line clicked on. However,
if the user clicks on the total figure (all expense codes), the
resulting detail report only shows the detail for the first object code
in the list. It should display the detail for all object codes.
Thanks -
SarahSarah,
<sarah.lambrite@.gmail.com> wrote in message
news:1158007893.402465.74110@.b28g2000cwb.googlegroups.com...
>I have a mutli-valued, (cascading? dependent on other parameter
> values) parameter whose values are retrieved from a database query. I
> want to set the default value of the parameter to be the same as the
> "Select All" function. How can I acheive this?
SELECT 0 as Value, 'Select All' as Description
UNION ALL
SELECT ID as Value, Columnname as Description FROM YourTable
When you set =0 as your default value, you should be fine.
> To explain, I have two budget reports. The first is a summary, which
> groups lines by expense codes and then displays a total. Each dollar
> figure is set to click through to the detail report, and filter the
> results based on the expense code from the line clicked on. However,
> if the user clicks on the total figure (all expense codes), the
> resulting detail report only shows the detail for the first object code
> in the list. It should display the detail for all object codes.
It looks like RS is having troubles to determine what to put in the
parameter, I think you have the parameter set up to get the contents of the
field (expense code) of the line you click on. But on the total line there
is no such field. This can be solved by altering your subreport parameters.
Set them up so that the subreport gives the details of all the expense
codes.
Perry
> Thanks -
> Sarah
>sql

Jump to Report & Multi Value vs. Single Value

I have a parameterized main report that contains a link to a sub report with parameters. Then from the sub report I have a link that takes you back to main report. If I use multi value parameters or single value parameters the links going back and forth between the two reports works just dandy, when I run it on my PC. However when I deploy the reports to the Web Server, the link going from the sub report back to the main report only works if the parameters are single select. Going from the Main to the Sub it doesn’t matter.

This is the error I get using multi select parameters going from the sub report back to the main.

The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)

Any suggestions?

By any chance, are the drillthrough links located in the page header or page footer?

-- Robert

join multi server

hi,

consider this:

i have american users in a db called "user" in a server called AMERICA

and rest of the world users in a db called "user" in a server called OTHER

how can i do a join betwhen American's users and Rest of the word's User db?

SELECT *

FROM AMERICA.user.dbo.MyTable t1

JOIN OTHER.user.dbo.MyTable t2 ON t1.id=t2.id

|||Make sure you have set uplinked server to the remote SQL|||ok many thanks, it will be very usefull for my