Jump to Report Parameters not passing correctly defualt values use

I have a Report with a chart on it and have a Jump to report setup on the
Action tab of the Chart control. I pass the report Parameters in the Jump to
Report. My problem is that if I have defualt values for the report
parameters, when I pass values in the Jump to report they get over written by
the defualt values. If I remove
the Defualt values my report parameters get passed correctly with the Jump
to report. Do defualt values over ride report Parameters that are passed in
the jump to report command? Can I make it so that defualt values will only
get used if I do not pass in a value to the report?
MikeIf you dont provide any value during drill-through then only it will take the
default values. If you provide some value then it will take that value. Check
if you are passing all the parameter to the Dill-Through report. If any
parameter is missing then the drill-throught report will take the default
value provided . This defult value is of the drill-through defaul value not
the parent report default value.
"Hotwheels" wrote:
> I have a Report with a chart on it and have a Jump to report setup on the
> Action tab of the Chart control. I pass the report Parameters in the Jump to
> Report. My problem is that if I have defualt values for the report
> parameters, when I pass values in the Jump to report they get over written by
> the defualt values. If I remove
> the Defualt values my report parameters get passed correctly with the Jump
> to report. Do defualt values over ride report Parameters that are passed in
> the jump to report command? Can I make it so that defualt values will only
> get used if I do not pass in a value to the report?
> Mike|||If I am passing a report parameter it does not seem to work like you say and
I have to remove the defualt value to get it to work.
If I pass the Field value of the chart it works like you say.
I tried this with a report with one Report parameter to make it easy.
Why would passing a report Parameter cause a problem?
"Bava Mani" wrote:
> If you dont provide any value during drill-through then only it will take the
> default values. If you provide some value then it will take that value. Check
> if you are passing all the parameter to the Dill-Through report. If any
> parameter is missing then the drill-throught report will take the default
> value provided . This defult value is of the drill-through defaul value not
> the parent report default value.
> "Hotwheels" wrote:
> > I have a Report with a chart on it and have a Jump to report setup on the
> > Action tab of the Chart control. I pass the report Parameters in the Jump to
> > Report. My problem is that if I have defualt values for the report
> > parameters, when I pass values in the Jump to report they get over written by
> > the defualt values. If I remove
> > the Defualt values my report parameters get passed correctly with the Jump
> > to report. Do defualt values over ride report Parameters that are passed in
> > the jump to report command? Can I make it so that defualt values will only
> > get used if I do not pass in a value to the report?
> >
> > Mike

Jump to Report Not Functioning Correctly

Hi all,
I'm having a problem with a series of reports I'm developing that allow the
user to design their own reports. They involve passing parameters (and
sometimes not passing parameters) between many different reports. The issue
I have is this:
I have an opening page with no parameters. When I jump to the next report
(using Jump to Report in Properties -> Navigation tab) it begins to load the
next report, but the parameter bar is missing (not hidden) and the report
itself doesn't load (although the report title is displayed in the top
frame).
If I use "Jump To URL", these issues appear to be less of a problem but
passing parameters is more difficult.
A couple of questions for you:
1) Has anyone else experienced this issue?
2) How can I pass parameters in a Jump to URL string, based on either report
parameters or report datasets?
I've had a look around on the forums and have found some similar problems,
which is why I ended up looking at the Jump to URL option. I haven't found
anyone with the same issue though. Can anyone help?!
Thanks in advance,
JonA little more information for you.
I've been trying to diagnose the issue, and I thought the problem was due to
passing parameters between reports but it now appears this isn't the case.
I have one report that has a subreport containing jumps to four other
reports. 3 of the reports do not work, but one does. None of the reports
require parameters to be passed, but the 3 that do not work have a parameter
that requires selection before the report will be shown.
If I place a default value in the report I'm jumping to, for the parameter
being passed (in this case, an ID for the report) it works fine. So the
issue appears to be when there is no default value for the parameter in the
report I'm jumping to. Unfortunately, I can't just set a default value in
this case.
Has anyone come across this or know a workaround other than setting a
default?
Thanks again,
Jon
"Jonathan Martin" <jonathan.martin@.pcservicecall.co.uk> wrote in message
news:%23SQ6CYsNFHA.3188@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> I'm having a problem with a series of reports I'm developing that allow
> the user to design their own reports. They involve passing parameters
> (and sometimes not passing parameters) between many different reports.
> The issue I have is this:
> I have an opening page with no parameters. When I jump to the next report
> (using Jump to Report in Properties -> Navigation tab) it begins to load
> the next report, but the parameter bar is missing (not hidden) and the
> report itself doesn't load (although the report title is displayed in the
> top frame).
> If I use "Jump To URL", these issues appear to be less of a problem but
> passing parameters is more difficult.
> A couple of questions for you:
> 1) Has anyone else experienced this issue?
> 2) How can I pass parameters in a Jump to URL string, based on either
> report parameters or report datasets?
> I've had a look around on the forums and have found some similar problems,
> which is why I ended up looking at the Jump to URL option. I haven't
> found anyone with the same issue though. Can anyone help?!
> Thanks in advance,
>
> Jon
>|||you have to set all parameters for the reports you are jumping to. This is
easier with the "Jump to Report" option - just click the Parameters button.
You can set hardcoded values are use other report items as input parameters.
For URL jumps - use "?paramenter_name=parameter_value" after the URL address
"Jonathan Martin" wrote:
> A little more information for you.
> I've been trying to diagnose the issue, and I thought the problem was due to
> passing parameters between reports but it now appears this isn't the case.
> I have one report that has a subreport containing jumps to four other
> reports. 3 of the reports do not work, but one does. None of the reports
> require parameters to be passed, but the 3 that do not work have a parameter
> that requires selection before the report will be shown.
> If I place a default value in the report I'm jumping to, for the parameter
> being passed (in this case, an ID for the report) it works fine. So the
> issue appears to be when there is no default value for the parameter in the
> report I'm jumping to. Unfortunately, I can't just set a default value in
> this case.
> Has anyone come across this or know a workaround other than setting a
> default?
> Thanks again,
>
> Jon
>
> "Jonathan Martin" <jonathan.martin@.pcservicecall.co.uk> wrote in message
> news:%23SQ6CYsNFHA.3188@.TK2MSFTNGP10.phx.gbl...
> > Hi all,
> >
> > I'm having a problem with a series of reports I'm developing that allow
> > the user to design their own reports. They involve passing parameters
> > (and sometimes not passing parameters) between many different reports.
> > The issue I have is this:
> >
> > I have an opening page with no parameters. When I jump to the next report
> > (using Jump to Report in Properties -> Navigation tab) it begins to load
> > the next report, but the parameter bar is missing (not hidden) and the
> > report itself doesn't load (although the report title is displayed in the
> > top frame).
> >
> > If I use "Jump To URL", these issues appear to be less of a problem but
> > passing parameters is more difficult.
> >
> > A couple of questions for you:
> >
> > 1) Has anyone else experienced this issue?
> > 2) How can I pass parameters in a Jump to URL string, based on either
> > report parameters or report datasets?
> >
> > I've had a look around on the forums and have found some similar problems,
> > which is why I ended up looking at the Jump to URL option. I haven't
> > found anyone with the same issue though. Can anyone help?!
> >
> > Thanks in advance,
> >
> >
> > Jon
> >
>
>|||Unfortunately it's still causing issues with passing the parameter values.
It does work fine with passing the parameter through the URL though.
No idea why, but it's working!
Thanks for the help.
"jj#10" <jj10@.discussions.microsoft.com> wrote in message
news:DDB82610-A1B2-4518-AB28-20D55D6B4BEF@.microsoft.com...
> you have to set all parameters for the reports you are jumping to. This
> is
> easier with the "Jump to Report" option - just click the Parameters
> button.
> You can set hardcoded values are use other report items as input
> parameters.
> For URL jumps - use "?paramenter_name=parameter_value" after the URL
> address
> "Jonathan Martin" wrote:
>> A little more information for you.
>> I've been trying to diagnose the issue, and I thought the problem was due
>> to
>> passing parameters between reports but it now appears this isn't the
>> case.
>> I have one report that has a subreport containing jumps to four other
>> reports. 3 of the reports do not work, but one does. None of the
>> reports
>> require parameters to be passed, but the 3 that do not work have a
>> parameter
>> that requires selection before the report will be shown.
>> If I place a default value in the report I'm jumping to, for the
>> parameter
>> being passed (in this case, an ID for the report) it works fine. So the
>> issue appears to be when there is no default value for the parameter in
>> the
>> report I'm jumping to. Unfortunately, I can't just set a default value
>> in
>> this case.
>> Has anyone come across this or know a workaround other than setting a
>> default?
>> Thanks again,
>>
>> Jon
>>
>> "Jonathan Martin" <jonathan.martin@.pcservicecall.co.uk> wrote in message
>> news:%23SQ6CYsNFHA.3188@.TK2MSFTNGP10.phx.gbl...
>> > Hi all,
>> >
>> > I'm having a problem with a series of reports I'm developing that allow
>> > the user to design their own reports. They involve passing parameters
>> > (and sometimes not passing parameters) between many different reports.
>> > The issue I have is this:
>> >
>> > I have an opening page with no parameters. When I jump to the next
>> > report
>> > (using Jump to Report in Properties -> Navigation tab) it begins to
>> > load
>> > the next report, but the parameter bar is missing (not hidden) and the
>> > report itself doesn't load (although the report title is displayed in
>> > the
>> > top frame).
>> >
>> > If I use "Jump To URL", these issues appear to be less of a problem but
>> > passing parameters is more difficult.
>> >
>> > A couple of questions for you:
>> >
>> > 1) Has anyone else experienced this issue?
>> > 2) How can I pass parameters in a Jump to URL string, based on either
>> > report parameters or report datasets?
>> >
>> > I've had a look around on the forums and have found some similar
>> > problems,
>> > which is why I ended up looking at the Jump to URL option. I haven't
>> > found anyone with the same issue though. Can anyone help?!
>> >
>> > Thanks in advance,
>> >
>> >
>> > Jon
>> >
>>|||I am having a similar problem, but I use jump to report and it works fine in
development environment (i.e. visual studio), but does not work live.
"Jonathan Martin" wrote:
> Unfortunately it's still causing issues with passing the parameter values.
> It does work fine with passing the parameter through the URL though.
> No idea why, but it's working!
> Thanks for the help.
> "jj#10" <jj10@.discussions.microsoft.com> wrote in message
> news:DDB82610-A1B2-4518-AB28-20D55D6B4BEF@.microsoft.com...
> > you have to set all parameters for the reports you are jumping to. This
> > is
> > easier with the "Jump to Report" option - just click the Parameters
> > button.
> > You can set hardcoded values are use other report items as input
> > parameters.
> >
> > For URL jumps - use "?paramenter_name=parameter_value" after the URL
> > address
> >
> > "Jonathan Martin" wrote:
> >
> >> A little more information for you.
> >>
> >> I've been trying to diagnose the issue, and I thought the problem was due
> >> to
> >> passing parameters between reports but it now appears this isn't the
> >> case.
> >>
> >> I have one report that has a subreport containing jumps to four other
> >> reports. 3 of the reports do not work, but one does. None of the
> >> reports
> >> require parameters to be passed, but the 3 that do not work have a
> >> parameter
> >> that requires selection before the report will be shown.
> >>
> >> If I place a default value in the report I'm jumping to, for the
> >> parameter
> >> being passed (in this case, an ID for the report) it works fine. So the
> >> issue appears to be when there is no default value for the parameter in
> >> the
> >> report I'm jumping to. Unfortunately, I can't just set a default value
> >> in
> >> this case.
> >>
> >> Has anyone come across this or know a workaround other than setting a
> >> default?
> >>
> >> Thanks again,
> >>
> >>
> >> Jon
> >>
> >>
> >> "Jonathan Martin" <jonathan.martin@.pcservicecall.co.uk> wrote in message
> >> news:%23SQ6CYsNFHA.3188@.TK2MSFTNGP10.phx.gbl...
> >> > Hi all,
> >> >
> >> > I'm having a problem with a series of reports I'm developing that allow
> >> > the user to design their own reports. They involve passing parameters
> >> > (and sometimes not passing parameters) between many different reports.
> >> > The issue I have is this:
> >> >
> >> > I have an opening page with no parameters. When I jump to the next
> >> > report
> >> > (using Jump to Report in Properties -> Navigation tab) it begins to
> >> > load
> >> > the next report, but the parameter bar is missing (not hidden) and the
> >> > report itself doesn't load (although the report title is displayed in
> >> > the
> >> > top frame).
> >> >
> >> > If I use "Jump To URL", these issues appear to be less of a problem but
> >> > passing parameters is more difficult.
> >> >
> >> > A couple of questions for you:
> >> >
> >> > 1) Has anyone else experienced this issue?
> >> > 2) How can I pass parameters in a Jump to URL string, based on either
> >> > report parameters or report datasets?
> >> >
> >> > I've had a look around on the forums and have found some similar
> >> > problems,
> >> > which is why I ended up looking at the Jump to URL option. I haven't
> >> > found anyone with the same issue though. Can anyone help?!
> >> >
> >> > Thanks in advance,
> >> >
> >> >
> >> > Jon
> >> >
> >>
> >>
> >>
>
>|||Is the URL mapped to the correct "live" server (i.e. Not http://localhost/...)
Message posted via http://www.sqlmonster.com|||URL is mapped correctly and remember I am using "jump to report"
"Corey Crumbaugh via SQLMonster.com" wrote:
> Is the URL mapped to the correct "live" server (i.e. Not http://localhost/...)
>
> --
> Message posted via http://www.sqlmonster.com
>|||My guess is that the report in question (that you are jumping to) has a
credential problem. Can you run the report you are trying to jump to by
itself?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"bamboo" <bamboo@.discussions.microsoft.com> wrote in message
news:A1910C53-32D2-40D2-BB75-D67AF6779793@.microsoft.com...
> URL is mapped correctly and remember I am using "jump to report"
> "Corey Crumbaugh via SQLMonster.com" wrote:
>> Is the URL mapped to the correct "live" server (i.e. Not
>> http://localhost/...)
>>
>> --
>> Message posted via http://www.sqlmonster.com|||I found that the problem is the 2nd report has to be runnable right away
(i.e. cannot prompt user to enter parameters when it is being executed from
another report). This is not a good function.
Thus, this goes back to what jonathan posed.
"Bruce L-C [MVP]" wrote:
> My guess is that the report in question (that you are jumping to) has a
> credential problem. Can you run the report you are trying to jump to by
> itself?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "bamboo" <bamboo@.discussions.microsoft.com> wrote in message
> news:A1910C53-32D2-40D2-BB75-D67AF6779793@.microsoft.com...
> > URL is mapped correctly and remember I am using "jump to report"
> >
> > "Corey Crumbaugh via SQLMonster.com" wrote:
> >
> >> Is the URL mapped to the correct "live" server (i.e. Not
> >> http://localhost/...)
> >>
> >>
> >> --
> >> Message posted via http://www.sqlmonster.com
> >>
>
>

JOIN question

Hi, I have a question concerning joining three tables together, and
getting the information to spit out correctly. Say I have three
tables:
products
ID Code Name
1 9000 Test Product
categories
ID Name
1 Test Category
2 Another Test
3 Yet another test
productcategories
ID Category Product
1 1 1
2 2 1
3 3 1
Now I want SQL to send back product ID, Code, Product Name, and all
categories it is with. So for example, one row would be:
ID Code Name Categories
1 9000 Test Product Test Category,Another Test,Yet
another test
Here is the SQL I am using. All it is doing is pulling one category
for now. I don't know how to group by and do a concatenation of all
the categories.
SELECT P.ID,Code,P.Name,C.Category FROM products P LEFT JOIN
productcategories PC ON (P.ID=PC.Product) LEFT JOIN categories C ON
(C.ID=PC.Name) GROUP BY P.ID
Any help in this would be appreciated. I am still relatively new to
the complexity of GROUP BYs in SQL.
Thanks for all the help!
JJHi,
I think pure SQL will not be sufficient in this case as far as text
(categories.names) shall be aggregated (concatenated). 'Group by'
returns just one member of the (each) group. If the select list contains
an aggregate function, 'group by' will aggregate over all group
records . So, if a aggregate function e.g. 'concatenateText' would
exist, it could be used here. As far as I know it does not exist.
Therefore a function could be used doing the concatenation.
Then the query would be like:
SELECT P.ID,Code,P.Name, getAllCategories(P.ID) AS AllCategories FROM
products p
The function 'getAllCategories(@.Pid integer)' has to get all Categories
with your query , concatenates the names and returns the concatenated
string.
Hope this helps
Olli
Jimmy Jim schrieb:

> Hi, I have a question concerning joining three tables together, and
> getting the information to spit out correctly. Say I have three
> tables:
> products
> ID Code Name
> 1 9000 Test Product
>
> categories
> ID Name
> 1 Test Category
> 2 Another Test
> 3 Yet another test
> productcategories
> ID Category Product
> 1 1 1
> 2 2 1
> 3 3 1
> Now I want SQL to send back product ID, Code, Product Name, and all
> categories it is with. So for example, one row would be:
> ID Code Name Categories
> 1 9000 Test Product Test Category,Another Test,Yet
> another test
> Here is the SQL I am using. All it is doing is pulling one category
> for now. I don't know how to group by and do a concatenation of all
> the categories.
> SELECT P.ID,Code,P.Name,C.Category FROM products P LEFT JOIN
> productcategories PC ON (P.ID=PC.Product) LEFT JOIN categories C ON
> (C.ID=PC.Name) GROUP BY P.ID
> Any help in this would be appreciated. I am still relatively new to
> the complexity of GROUP BYs in SQL.
> Thanks for all the help!
> JJ|||Thanks for teh reply. Yeah, I tought it was going to be tough with SQL,
and I am using MySQL, so I can't use subqueries like I watned to. I
ended up creating something like a view and using that in PHP/MySQL. Not
as efficient, but all I could do.
Thanks again for the response!
JJ
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

JOIN question

Hi, I have a question concerning joining three tables together, and
getting the information to spit out correctly. Say I have three
tables:
products
ID Code Name
1 9000 Test Product
categories
ID Name
1 Test Category
2 Another Test
3 Yet another test
productcategories
ID Category Product
1 1 1
2 2 1
3 3 1
Now I want SQL to send back product ID, Code, Product Name, and all
categories it is with. So for example, one row would be:
ID Code Name Categories
1 9000 Test Product Test Category,Another Test,Yet
another test
Here is the SQL I am using. All it is doing is pulling one category
for now. I don't know how to group by and do a concatenation of all
the categories.
SELECT P.ID,Code,P.Name,C.Category FROM products P LEFT JOIN
productcategories PC ON (P.ID=PC.Product) LEFT JOIN categories C ON
(C.ID=PC.Name) GROUP BY P.ID
Any help in this would be appreciated. I am still relatively new to
the complexity of GROUP BYs in SQL.
Thanks for all the help!
JJ
Hi,
I think pure SQL will not be sufficient in this case as far as text
(categories.names) shall be aggregated (concatenated). 'Group by'
returns just one member of the (each) group. If the select list contains
an aggregate function, 'group by' will aggregate over all group
records . So, if a aggregate function e.g. 'concatenateText' would
exist, it could be used here. As far as I know it does not exist.
Therefore a function could be used doing the concatenation.
Then the query would be like:
SELECT P.ID,Code,P.Name, getAllCategories(P.ID) AS AllCategories FROM
products p
The function 'getAllCategories(@.Pid integer)' has to get all Categories
with your query , concatenates the names and returns the concatenated
string.
Hope this helps
Olli
Jimmy Jim schrieb:

> Hi, I have a question concerning joining three tables together, and
> getting the information to spit out correctly. Say I have three
> tables:
> products
> ID Code Name
> 1 9000 Test Product
>
> categories
> ID Name
> 1 Test Category
> 2 Another Test
> 3 Yet another test
> productcategories
> ID Category Product
> 1 1 1
> 2 2 1
> 3 3 1
> Now I want SQL to send back product ID, Code, Product Name, and all
> categories it is with. So for example, one row would be:
> ID Code Name Categories
> 1 9000 Test Product Test Category,Another Test,Yet
> another test
> Here is the SQL I am using. All it is doing is pulling one category
> for now. I don't know how to group by and do a concatenation of all
> the categories.
> SELECT P.ID,Code,P.Name,C.Category FROM products P LEFT JOIN
> productcategories PC ON (P.ID=PC.Product) LEFT JOIN categories C ON
> (C.ID=PC.Name) GROUP BY P.ID
> Any help in this would be appreciated. I am still relatively new to
> the complexity of GROUP BYs in SQL.
> Thanks for all the help!
> JJ
|||Thanks for teh reply. Yeah, I tought it was going to be tough with SQL,
and I am using MySQL, so I can't use subqueries like I watned to. I
ended up creating something like a view and using that in PHP/MySQL. Not
as efficient, but all I could do.
Thanks again for the response!
JJ
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!