Pareto Charts

Hello,
Does anyone know how to do Pareto Charts in Crystal Reports? Is it possible?
Also - when I use the chart expert, in the Data tab the following are grayed out: Group, Cross Tab, Olap; any ideas why?
Thanks!I don't think you can do Pareto with standard version of Charting tool (Amigo).
We don't use the standard tool anywhere, due to its limitations.
An upgrade to CRChart, which does 2 Pareto formats, can be obtained from Dan Weingart at:

http://www.threedgraphics.com/tdg/noteworthy/crystalreports.asp

We nogeotiated and got about 50% off the standard retail price for this replacement for sscdsdk80.dll (Crystal's charting engine), and so far it has done everything we asked for.

As for groups etc, I'm not sure, but I think CrossTab needs to have a crosstab present in the report before it can summarise the crosstab data via a report.

Dave

appended a snapshot from ThreeD's doc's for you.|||Thanks! Big help!!|||Can I pick your brain again? When I go to use the Pareto Charts, do I need to set my data in a cross tab report?

Any feedback is greatly appreciated.|||I don't think you need a cross tab, but like verything with Crystal, its hard to remember the premutations.
Last time I used a Paerto was over a year ago.
You should just be able to make a data series for each one, and represent one as you aggregated trend line and one as you raw data.

Need more time to investigate than I can give, unfortunately. deadlines, deadlines.

Dave

Parent Package reports failure on errors, but no errors in log

I have a parent package that calls child packages inside a For Each container. When I debug/run the parent package (from VS), I get the following error message: Warning: The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

It appears to be failing while executing the child package. However, the logs (via the "progress" tab) for both the parent package and the child package show no errors other than the one listed above (and that shows in the parent package log). The child package appears to validate completely without error (all components are green and no error messages in the log). I turned on SSIS logging to a text file and see nothing in there either.

If I bump up the MaximumErrorCount in the parent package and in the Execute Package Task that calls the child package to 4 (to go one above the error count indicated in the message above), the whole thing executes sucessfully. I don't want to leave the Max Error Count set like this. Is there something I am missing? For example are there errors that do not get logged by default? I get some warnings, do a certain number of warnings equal an error?

Thanks,

Lee

I never figured this one out. It looks like in a parent/child package model this happens where you will get an "error" even though the child package succeeded. I've checked and there are no data errors (e.g. truncation, ...) or package logic errors. It has happened on two other package sets I've created where there is a parent package calling child packages. The work around has been to bump up the MaximumErrorCounts in the execute package task, the for each container that contains the child packages, and the parent package. Not a good solution but it works.|||

I still continue to see this behavior. I have text file logging setup to catch every event in both the child and parent packages. I have no warnings or errors and the child package runs completely and does what it is supposed to do. But in the parent package, the child "Execute Package Task" fails with a "The Execution method succeeded, but the number of errors raised..." which is the only error message I get in the logs. Again, every event type is set to log.

I can work around this problem by bumping up the MaximumErrorCount on the "Execute Package Task" but what errors is this catching?

Is this a bug? Are there any MVPs on here?

|||I encountered the same error and could not solve it, I had to use the maxerrorcount work around as well

Parent Package reports failure on errors, but no errors in log

I have a parent package that calls child packages inside a For Each container. When I debug/run the parent package (from VS), I get the following error message: Warning: The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

It appears to be failing while executing the child package. However, the logs (via the "progress" tab) for both the parent package and the child package show no errors other than the one listed above (and that shows in the parent package log). The child package appears to validate completely without error (all components are green and no error messages in the log). I turned on SSIS logging to a text file and see nothing in there either.

If I bump up the MaximumErrorCount in the parent package and in the Execute Package Task that calls the child package to 4 (to go one above the error count indicated in the message above), the whole thing executes sucessfully. I don't want to leave the Max Error Count set like this. Is there something I am missing? For example are there errors that do not get logged by default? I get some warnings, do a certain number of warnings equal an error?

Thanks,

Lee

I never figured this one out. It looks like in a parent/child package model this happens where you will get an "error" even though the child package succeeded. I've checked and there are no data errors (e.g. truncation, ...) or package logic errors. It has happened on two other package sets I've created where there is a parent package calling child packages. The work around has been to bump up the MaximumErrorCounts in the execute package task, the for each container that contains the child packages, and the parent package. Not a good solution but it works.|||

I still continue to see this behavior. I have text file logging setup to catch every event in both the child and parent packages. I have no warnings or errors and the child package runs completely and does what it is supposed to do. But in the parent package, the child "Execute Package Task" fails with a "The Execution method succeeded, but the number of errors raised..." which is the only error message I get in the logs. Again, every event type is set to log.

I can work around this problem by bumping up the MaximumErrorCount on the "Execute Package Task" but what errors is this catching?

Is this a bug? Are there any MVPs on here?

Parent Package reports failure on errors, but no errors in log

I have a parent package that calls child packages inside a For Each container. When I debug/run the parent package (from VS), I get the following error message: Warning: The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

It appears to be failing while executing the child package. However, the logs (via the "progress" tab) for both the parent package and the child package show no errors other than the one listed above (and that shows in the parent package log). The child package appears to validate completely without error (all components are green and no error messages in the log). I turned on SSIS logging to a text file and see nothing in there either.

If I bump up the MaximumErrorCount in the parent package and in the Execute Package Task that calls the child package to 4 (to go one above the error count indicated in the message above), the whole thing executes sucessfully. I don't want to leave the Max Error Count set like this. Is there something I am missing? For example are there errors that do not get logged by default? I get some warnings, do a certain number of warnings equal an error?

Thanks,

Lee

I never figured this one out. It looks like in a parent/child package model this happens where you will get an "error" even though the child package succeeded. I've checked and there are no data errors (e.g. truncation, ...) or package logic errors. It has happened on two other package sets I've created where there is a parent package calling child packages. The work around has been to bump up the MaximumErrorCounts in the execute package task, the for each container that contains the child packages, and the parent package. Not a good solution but it works.|||

I still continue to see this behavior. I have text file logging setup to catch every event in both the child and parent packages. I have no warnings or errors and the child package runs completely and does what it is supposed to do. But in the parent package, the child "Execute Package Task" fails with a "The Execution method succeeded, but the number of errors raised..." which is the only error message I get in the logs. Again, every event type is set to log.

I can work around this problem by bumping up the MaximumErrorCount on the "Execute Package Task" but what errors is this catching?

Is this a bug? Are there any MVPs on here?

Parent child reports problems

Hi,
I have a report which I have created 3 or 4 child reports from.
If I make a change to the format of an object within the parent report
(e.g. the colour of a text box) then the change appears on the child
reports as I would expect.
The problem is that if I make a change to the properties of the report
(e.g. the margins or the page size) then the change is NOT picked up
in the child reports.
Does anybody have any solution to this annoying problem.
Regards,
JamesOn Nov 6, 4:33 am, joli...@.googlemail.com wrote:
> Hi,
> I have a report which I have created 3 or 4 child reports from.
> If I make a change to the format of an object within the parent report
> (e.g. the colour of a text box) then the change appears on the child
> reports as I would expect.
> The problem is that if I make a change to the properties of the report
> (e.g. the margins or the page size) then the change is NOT picked up
> in the child reports.
> Does anybody have any solution to this annoying problem.
> Regards,
> James
This might not be exactly what you're looking for, but you could use a
comparison tool to compare the RDL files side-by-side and merge the
changes pretty quickly. There's a trial version of a tool I like to
use here: http://www.araxis.com/merge/
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

parent and child reports

Please help me, is there a way to get the field.value from another report?

example:
report1.rdl:
id: 01 < field!id.value
name | age | sex
nemo 11 m
id: 02
...
I want the field!id.value to be used by report2.rdl, so i can make a parent -child way:

id: 01 < report1.rdl
name | age | sex
nemo 11 m

friend | school | teacher <--report2.rdl,a subreport with id:01 from report1.rdl
sha ppch yanimoto

As you have already indicated, you can use a subreport and just pass the current id-value as parameter to the subreport. In the subreport make sure the report parameter value is used in the query to just retrieve the data with the according parameter value.

-- Robert

Parameters...Null as an available value?!?!?

I have a hierarchy of organizations that I need to be able to filter by
in the reports...
For example, an Agency can have many Applications associated with it.
I have three stored procedures, one that gets a list of Agencies, the
other that gets a list of Applications based on the Agency that was
selected, and the third takes a bunch of other parameters and gets all
the matching orders (or whatever) associated with the Agency and
Application (Agency and Application are both input params to the third
stored proc).
What I really want is for the user to be able to not select an Agency,
basically setting it to Null, and letting the stored procedure that
does the query for the report ignore that parameter and get results for
all agencies.
If I set the parameter in the report to null, then I can't have a drop
down list with the Agency names if the user doesn't want to set the
Agency to null. But I can't have both!!!
What is the best procedure for doing this? Returning a -1 record in
the list of Agencies and using that to indicate null within the stored
proc? Any other ideas? I can't return a null record in the stored
proc because the report throws an exception. Does this make sense?
Any help would be appreciated!!! Thanks, BrianI had a similiar problem, I solved it by using 'All' as below:
Select * from MainTable
Where (Agency_Name = @.AgencyName OR @.AgencyName = 'All') AND .....
@.AgencyName is a parameter, you can set the parameter's default value
to All( you can make one dataset for this parameter as below:
Select ID, Name from AgencyTable UNION Select 0,'All'. Then In the
Report Parameters dialogue,Choose available value from query,make All
as default value), then the first part of where clause will always
automatically satisfied unless you choose a different value.
This works great for me, Hope this helps.
Good luck.
Henry
Brian wrote:
> I have a hierarchy of organizations that I need to be able to filter
by
> in the reports...
> For example, an Agency can have many Applications associated with it.
> I have three stored procedures, one that gets a list of Agencies, the
> other that gets a list of Applications based on the Agency that was
> selected, and the third takes a bunch of other parameters and gets
all
> the matching orders (or whatever) associated with the Agency and
> Application (Agency and Application are both input params to the
third
> stored proc).
> What I really want is for the user to be able to not select an
Agency,
> basically setting it to Null, and letting the stored procedure that
> does the query for the report ignore that parameter and get results
for
> all agencies.
> If I set the parameter in the report to null, then I can't have a
drop
> down list with the Agency names if the user doesn't want to set the
> Agency to null. But I can't have both!!!
> What is the best procedure for doing this? Returning a -1 record in
> the list of Agencies and using that to indicate null within the
stored
> proc? Any other ideas? I can't return a null record in the stored
> proc because the report throws an exception. Does this make sense?
> Any help would be appreciated!!! Thanks, Brian|||That's exactly what I ended up doing this morning. Works great so far!
Thanks!
Brian
fanh@.tycoelectronics.com wrote:
> I had a similiar problem, I solved it by using 'All' as below:
> Select * from MainTable
> Where (Agency_Name = @.AgencyName OR @.AgencyName = 'All') AND .....
> @.AgencyName is a parameter, you can set the parameter's default value
> to All( you can make one dataset for this parameter as below:
> Select ID, Name from AgencyTable UNION Select 0,'All'. Then In the
> Report Parameters dialogue,Choose available value from query,make All
> as default value), then the first part of where clause will always
> automatically satisfied unless you choose a different value.
> This works great for me, Hope this helps.
> Good luck.
> Henry
>
> Brian wrote:
> > I have a hierarchy of organizations that I need to be able to
filter
> by
> > in the reports...
> >
> > For example, an Agency can have many Applications associated with
it.
> >
> > I have three stored procedures, one that gets a list of Agencies,
the
> > other that gets a list of Applications based on the Agency that was
> > selected, and the third takes a bunch of other parameters and gets
> all
> > the matching orders (or whatever) associated with the Agency and
> > Application (Agency and Application are both input params to the
> third
> > stored proc).
> >
> > What I really want is for the user to be able to not select an
> Agency,
> > basically setting it to Null, and letting the stored procedure that
> > does the query for the report ignore that parameter and get results
> for
> > all agencies.
> >
> > If I set the parameter in the report to null, then I can't have a
> drop
> > down list with the Agency names if the user doesn't want to set the
> > Agency to null. But I can't have both!!!
> >
> > What is the best procedure for doing this? Returning a -1 record
in
> > the list of Agencies and using that to indicate null within the
> stored
> > proc? Any other ideas? I can't return a null record in the stored
> > proc because the report throws an exception. Does this make sense?
> > Any help would be appreciated!!! Thanks, Brian

Parameters with Crystal Reports.

I have set up some (three to be exact) parameters in a report that I want to
be able to print. Before I set the parameters everything worked just fine. I
set the datasource and the printout worked great. Now I add parameters to the
report and it seems that no matter what I do, I get an exception indicating
that I have not set the parameters. Here is the latest try (this is Winform
code):
Dim rpt As New QuoteDetail
Dim disVal As New CrystalDecisions.Shared.ParameterDiscreteValue()
disVal.Value = "Net 30"
rpt.Parameter_Terms.CurrentValues.Add(disVal)
disVal = New CrystalDecisions.Shared.ParameterDiscreteValue()
disVal.Value = q.FileName
rpt.Parameter_QuoteFile.CurrentValues.Add(disVal)
disVal = New CrystalDecisions.Shared.ParameterDiscreteValue()
disVal.Value = "Me"
rpt.Parameter_PreparerName.CurrentValues.Add(disVal)
rpt.SetDataSource(ds)
rpt.PrintToPrinter(1, False, 0, 0)
rpt.Dispose()
One interesting thing that I learned from several sessions in the debugger.
Before the SetDataSource there are current values for each of the parameters.
After the call to SetDataSource it seems that the current values go away.
I would like to just be able to set values for these parameters and print,
like a function call. Any suggestions on what I am doing wrong?
Thank you.
KevinThis forum is for Reporting Services, the reporting product from MS that
competes with Crystal. I know Crystal is still bundled with VS. I would
suggest a Visual Studio newsgroup. Not really sure where the best place is
for you to go for an answer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kevin Burton" <KevinBurton@.discussions.microsoft.com> wrote in message
news:F3EA2C93-0DB0-4CB4-9A65-815EBAD105C4@.microsoft.com...
>I have set up some (three to be exact) parameters in a report that I want
>to
> be able to print. Before I set the parameters everything worked just fine.
> I
> set the datasource and the printout worked great. Now I add parameters to
> the
> report and it seems that no matter what I do, I get an exception
> indicating
> that I have not set the parameters. Here is the latest try (this is
> Winform
> code):
> Dim rpt As New QuoteDetail
> Dim disVal As New
> CrystalDecisions.Shared.ParameterDiscreteValue()
> disVal.Value = "Net 30"
> rpt.Parameter_Terms.CurrentValues.Add(disVal)
> disVal = New CrystalDecisions.Shared.ParameterDiscreteValue()
> disVal.Value = q.FileName
> rpt.Parameter_QuoteFile.CurrentValues.Add(disVal)
> disVal = New CrystalDecisions.Shared.ParameterDiscreteValue()
> disVal.Value = "Me"
> rpt.Parameter_PreparerName.CurrentValues.Add(disVal)
> rpt.SetDataSource(ds)
> rpt.PrintToPrinter(1, False, 0, 0)
> rpt.Dispose()
> One interesting thing that I learned from several sessions in the
> debugger.
> Before the SetDataSource there are current values for each of the
> parameters.
> After the call to SetDataSource it seems that the current values go away.
> I would like to just be able to set values for these parameters and print,
> like a function call. Any suggestions on what I am doing wrong?
> Thank you.
>
> Kevin

Parameters to run different reports?

Is it possible to have a parameter to run different reports depending on what
the user select for the parameter?
For example I want to have Employee, Customers, Inventory, etc for the
report parameter. When the user clicks on Employee it will bring the
employee report with all the parameters needed for that report. If it's
possible, what's the syntax.It sounds more like you're wanting separate actions, that is different
elements on a page that hyperlink to different reports. Check out the
Action property of text boxes, for example. You can specify the various
parameters in the action. Does that do what you want?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"chang" <chang@.discussions.microsoft.com> wrote in message
news:467B6B2C-5D16-4107-B81C-BC4AC06E5711@.microsoft.com...
> Is it possible to have a parameter to run different reports depending on
> what
> the user select for the parameter?
> For example I want to have Employee, Customers, Inventory, etc for the
> report parameter. When the user clicks on Employee it will bring the
> employee report with all the parameters needed for that report. If it's
> possible, what's the syntax.|||Jeff, thanks for replying. It's not related to the Hyperlink action I think.
From my understanding of the Hyperlink Actioin, I can have a textbox jump to
a report, but is it possible to use that as a drop down box that has the name
of each report? Probably I can play with the Hyperlink Action and see if
this will work.
Thanks for the suggestion.
"Jeff A. Stucker" wrote:
> It sounds more like you're wanting separate actions, that is different
> elements on a page that hyperlink to different reports. Check out the
> Action property of text boxes, for example. You can specify the various
> parameters in the action. Does that do what you want?
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "chang" <chang@.discussions.microsoft.com> wrote in message
> news:467B6B2C-5D16-4107-B81C-BC4AC06E5711@.microsoft.com...
> > Is it possible to have a parameter to run different reports depending on
> > what
> > the user select for the parameter?
> >
> > For example I want to have Employee, Customers, Inventory, etc for the
> > report parameter. When the user clicks on Employee it will bring the
> > employee report with all the parameters needed for that report. If it's
> > possible, what's the syntax.
>
>

Parameters to reports that only show is previous parameters filled

I don't know if I can do this with Reporting Services. I have ten parameters to a stored procedure. However, each parameter only shows when the previous one is selected. For sake of this discussion, the queries from which the parameters come are completly unrelated.
Initially, only the pull-down for parameter 1 appears. When the user selects a value for parameter 1 using the initial pull-down, the pull down for parameter 2 should appear. When the user selects a value from this pull down, a pull down from parameter 3 should appear.
At any point, the user can click View Report and pass the parameters he selected and all other parameters null.
Thanks in advance for any help.
JustinYes, RS supports sequenced parameter prompting. You build the valid values
query for a parameter using a query that includes previously selected
parameter values. I believe there is a sample called 'Product Line Sales'
that illustrates this technique.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Justin30519" <Justin30519@.discussions.microsoft.com> wrote in message
news:01FC2CE7-C435-47EC-AD00-E2762510E522@.microsoft.com...
>I don't know if I can do this with Reporting Services. I have ten
>parameters to a stored procedure. However, each parameter only shows when
>the previous one is selected. For sake of this discussion, the queries from
>which the parameters come are completly unrelated.
> Initially, only the pull-down for parameter 1 appears. When the user
> selects a value for parameter 1 using the initial pull-down, the pull down
> for parameter 2 should appear. When the user selects a value from this
> pull down, a pull down from parameter 3 should appear.
> At any point, the user can click View Report and pass the parameters he
> selected and all other parameters null.
> Thanks in advance for any help.
> Justin
>|||> Yes, RS supports sequenced parameter prompting. You build the valid values
> query for a parameter using a query that includes previously selected
> parameter values. I believe there is a sample called 'Product Line Sales'
> that illustrates this technique.
>
Thank you very much for your reply. It was helpful. I can do what my boss asked now. :)
Justin

Parameters not getting refreshed?

Hi All,

I am getting some wierd problem in my reports. I have deployed several reports on the server and when I am giving some parameters for the report, it does not take it and runs the report on complete database. What can be the reason.?

Few days ago, everything was working fine.

I was using a separate datasource for each report. But then I created a shared datasource. Can that be the reason?

Please help me out !!!

TIA

I have had this happen to me before as well, generally I have found it is because within the dataset for the report, the parameters have been dropped. to check, go to the Data tab for the report in VS, edit the selected dataset by clicking the "..." button

Then go to the parameters tab, make sure your parameters are displayed in there.

|||Another alternative to determining whether or not your parameters are functioning properly is to click out of the design mode and view the MDX query. There will be a "Query Parameters" button in the toolbar directly to the left of the "Prepare Query" and "Execute Query" buttons.

Parameters in URL - Problem

Hi,

I am new to Reporting services and have managed to create some reports. I want to pass some parameters in the URL to the report. I know how to do this but some parameters are not passing to the parameter boxes. They are clearly displayed in the URL but are not populating the boxes. I have one report done before i came and this used to work but now it doesnt work.

Any ideas?

Matt

Hi Matt,

i am unable to understand ur prob completely. But still, if the parameter field is a dropdown list, then the value for that parameter passed in the URL should exists in the dropdown list or else the report will throw an error.

Cheers

Chakri.

|||

Try the sample reports available with your installation of SQL Server. They should show you how to do this:

http://msdn2.microsoft.com/en-us/library/ms161542.aspx

Hope that helps,

-Lukasz

|||

Hi All,

I have the similar kind of problem where i can't see the parameters and their values.

I have a simple report where i am passing employeeid as parameter. When i run it on the server it prompt me for employeeid which after giving displays the report but in the url of browser , i cannot see the parameter and it's value .

Anybody has any idea why this is happenning.

Thanks,

Nagul Shaik

|||

We do not show the parameter in the URL when you're using the report viewer. It does not matter, the report is receiving the parameter.

To see what value the report is receiving you can add a textbox to the report and set it's value to:

=ReportParameters!ParameterName.Value

Hope that helps,

-Lukasz

|||

thanks for the reply but i am not using any report viewer. I am trying access the report thru browser giving the parameters in query string instead of in the prompt.

My requirement is to create hyperlink in my aspx page for that report and when the logged in user clicks on it , i have to pass userid to that report to show the contents of the report.

My sql2005 reporting service is running on WIN2K3.

Please help me with it.

|||

This topic in books online provides you the starting point for how to construct URLs understood by the report server.

http://msdn2.microsoft.com/de-de/library/ms155362.aspx

to pass a particular parameter you defined in the report, you can just append <parametername>=<value> to the end of the query string.

The User!UserId global variable is not a parameter - it is determined by who is logged into the report server. You cannot control it on the URL itself.

Hope that helps,

-Lukasz

|||

http://msdn2.microsoft.com/en-us/library/ms153586(SQL.90).aspx

Parameters in URL - Problem

Hi,

I am new to Reporting services and have managed to create some reports. I want to pass some parameters in the URL to the report. I know how to do this but some parameters are not passing to the parameter boxes. They are clearly displayed in the URL but are not populating the boxes. I have one report done before i came and this used to work but now it doesnt work.

Any ideas?

Matt

Hi Matt,

i am unable to understand ur prob completely. But still, if the parameter field is a dropdown list, then the value for that parameter passed in the URL should exists in the dropdown list or else the report will throw an error.

Cheers

Chakri.

|||

Try the sample reports available with your installation of SQL Server. They should show you how to do this:

http://msdn2.microsoft.com/en-us/library/ms161542.aspx

Hope that helps,

-Lukasz

|||

Hi All,

I have the similar kind of problem where i can't see the parameters and their values.

I have a simple report where i am passing employeeid as parameter. When i run it on the server it prompt me for employeeid which after giving displays the report but in the url of browser , i cannot see the parameter and it's value .

Anybody has any idea why this is happenning.

Thanks,

Nagul Shaik

|||

We do not show the parameter in the URL when you're using the report viewer. It does not matter, the report is receiving the parameter.

To see what value the report is receiving you can add a textbox to the report and set it's value to:

=ReportParameters!ParameterName.Value

Hope that helps,

-Lukasz

|||

thanks for the reply but i am not using any report viewer. I am trying access the report thru browser giving the parameters in query string instead of in the prompt.

My requirement is to create hyperlink in my aspx page for that report and when the logged in user clicks on it , i have to pass userid to that report to show the contents of the report.

My sql2005 reporting service is running on WIN2K3.

Please help me with it.

|||

This topic in books online provides you the starting point for how to construct URLs understood by the report server.

http://msdn2.microsoft.com/de-de/library/ms155362.aspx

to pass a particular parameter you defined in the report, you can just append <parametername>=<value> to the end of the query string.

The User!UserId global variable is not a parameter - it is determined by who is logged into the report server. You cannot control it on the URL itself.

Hope that helps,

-Lukasz

|||

http://msdn2.microsoft.com/en-us/library/ms153586(SQL.90).aspx

Parameters in Jump Reports

Good morning all:
I am having an issue when jumping from one report to the next. The issue is
that the users want the reports to run without having to enter any
additional information but may want to change some of the parameters after
the report has run. I have accomplished the first part of the requirement
but the parameters are not showing themselves for the second part of the
requirement.
When I run the reports with out jumping to it the parameters are exposed and
the user can select them but when it is called from another report they
don't show at all.
Is there some setting somewhere that will force the parameters to show even
if they don't need to be modified?
Thanks,
AlNever mind mystery solved. It turns out that the parameter area of the
report is collapsed/hidden and the user will just have to expand it.
Thanks,
Al
"Al" <no@.no.com> wrote in message
news:%234JxHTWbHHA.2088@.TK2MSFTNGP05.phx.gbl...
> Good morning all:
> I am having an issue when jumping from one report to the next. The issue
> is that the users want the reports to run without having to enter any
> additional information but may want to change some of the parameters after
> the report has run. I have accomplished the first part of the requirement
> but the parameters are not showing themselves for the second part of the
> requirement.
> When I run the reports with out jumping to it the parameters are exposed
> and the user can select them but when it is called from another report
> they don't show at all.
> Is there some setting somewhere that will force the parameters to show
> even if they don't need to be modified?
> Thanks,
> Al
>|||Also, you can use Jump to URL. When you do that you can specify that the
parameter section is not collapsed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Al" <no@.no.com> wrote in message
news:uOzaIaWbHHA.4720@.TK2MSFTNGP04.phx.gbl...
> Never mind mystery solved. It turns out that the parameter area of the
> report is collapsed/hidden and the user will just have to expand it.
> Thanks,
> Al
> "Al" <no@.no.com> wrote in message
> news:%234JxHTWbHHA.2088@.TK2MSFTNGP05.phx.gbl...
>> Good morning all:
>> I am having an issue when jumping from one report to the next. The issue
>> is that the users want the reports to run without having to enter any
>> additional information but may want to change some of the parameters
>> after the report has run. I have accomplished the first part of the
>> requirement but the parameters are not showing themselves for the second
>> part of the requirement.
>> When I run the reports with out jumping to it the parameters are exposed
>> and the user can select them but when it is called from another report
>> they don't show at all.
>> Is there some setting somewhere that will force the parameters to show
>> even if they don't need to be modified?
>> Thanks,
>> Al
>>
>|||I can see that coming up. Thanks,
Al
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eQNiHzWbHHA.4544@.TK2MSFTNGP03.phx.gbl...
> Also, you can use Jump to URL. When you do that you can specify that the
> parameter section is not collapsed.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Al" <no@.no.com> wrote in message
> news:uOzaIaWbHHA.4720@.TK2MSFTNGP04.phx.gbl...
>> Never mind mystery solved. It turns out that the parameter area of the
>> report is collapsed/hidden and the user will just have to expand it.
>> Thanks,
>> Al
>> "Al" <no@.no.com> wrote in message
>> news:%234JxHTWbHHA.2088@.TK2MSFTNGP05.phx.gbl...
>> Good morning all:
>> I am having an issue when jumping from one report to the next. The
>> issue is that the users want the reports to run without having to enter
>> any additional information but may want to change some of the parameters
>> after the report has run. I have accomplished the first part of the
>> requirement but the parameters are not showing themselves for the second
>> part of the requirement.
>> When I run the reports with out jumping to it the parameters are exposed
>> and the user can select them but when it is called from another report
>> they don't show at all.
>> Is there some setting somewhere that will force the parameters to show
>> even if they don't need to be modified?
>> Thanks,
>> Al
>>
>>
>|||Yeah, sometimes it is easy to make a change than teaching people how to
expand the section.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Al" <no@.no.com> wrote in message
news:uuG8uFYbHHA.3584@.TK2MSFTNGP02.phx.gbl...
>I can see that coming up. Thanks,
> Al
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eQNiHzWbHHA.4544@.TK2MSFTNGP03.phx.gbl...
>> Also, you can use Jump to URL. When you do that you can specify that the
>> parameter section is not collapsed.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Al" <no@.no.com> wrote in message
>> news:uOzaIaWbHHA.4720@.TK2MSFTNGP04.phx.gbl...
>> Never mind mystery solved. It turns out that the parameter area of the
>> report is collapsed/hidden and the user will just have to expand it.
>> Thanks,
>> Al
>> "Al" <no@.no.com> wrote in message
>> news:%234JxHTWbHHA.2088@.TK2MSFTNGP05.phx.gbl...
>> Good morning all:
>> I am having an issue when jumping from one report to the next. The
>> issue is that the users want the reports to run without having to enter
>> any additional information but may want to change some of the
>> parameters after the report has run. I have accomplished the first part
>> of the requirement but the parameters are not showing themselves for
>> the second part of the requirement.
>> When I run the reports with out jumping to it the parameters are
>> exposed and the user can select them but when it is called from another
>> report they don't show at all.
>> Is there some setting somewhere that will force the parameters to show
>> even if they don't need to be modified?
>> Thanks,
>> Al
>>
>>
>>
>

Parameters in Client Report Builder

Hello,

Is there a way for a regular user of the client report builder to add parameters to their reports? Right now you can only add them by creating a report from visual studio and publishing to the report server, which regular users can't do. Please let me know if I'm missing something here...

Thanks,
Edward

In the Report Builder filter dialog, click the name of the item you want the parameter on and select "Prompt". Example: if you have a condition Last Name = Smith, click on Last Name and select Prompt.
-- Robert||| I've been looking for a way to do that for ages.

Do you know if there is any way to get the prompt to be a drop down box?|||Great! Thanks! |||hey, I am also looking for drop down in report parameter. If you are having any kind of solution for displaying a dropdown list to choose a specific filter criteria on the fly will be a great help!

At present, I am using report parameter with free text which is not the exact solution need to be provided.

By selection of any list item, report will be displayed for specific list item.

e.g. Project name is my report parameter should have dropdown list with data list like "Project1", "Project2" etc. selection of "Project1" will display only Project1 related information in report.

Parameters I add to URL do not do anything

I am new to reporting services. I'm using 2005. I have some reports
deployed and working. When I go to them directly by URL with some parameters
in the URL, the parameters don't do anything. I've tried some of the built
in rc parameters and my own parameter values. Is there a setting I'm
missing or something? Thanks.My guess is you are going to Reports instead of ResportServer. Reports is
the portal that ships with RS. ReportServer is the asp.net application that
is Report Server.
Books Online has lots of good examples. Look for URL Access (if you are on
RS 2000 then look on the Books Online on the microsoft site (i.e. RS 2005
Books Online, URL integration is the same).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jlmjr" <jlmjr@.discussions.microsoft.com> wrote in message
news:74438560-1960-4900-A165-E87B1A94E1F3@.microsoft.com...
>I am new to reporting services. I'm using 2005. I have some reports
> deployed and working. When I go to them directly by URL with some
> parameters
> in the URL, the parameters don't do anything. I've tried some of the
> built
> in rc parameters and my own parameter values. Is there a setting I'm
> missing or something? Thanks.|||That's what I needed to know. Thanks!
"Bruce L-C [MVP]" wrote:
> My guess is you are going to Reports instead of ResportServer. Reports is
> the portal that ships with RS. ReportServer is the asp.net application that
> is Report Server.
> Books Online has lots of good examples. Look for URL Access (if you are on
> RS 2000 then look on the Books Online on the microsoft site (i.e. RS 2005
> Books Online, URL integration is the same).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "jlmjr" <jlmjr@.discussions.microsoft.com> wrote in message
> news:74438560-1960-4900-A165-E87B1A94E1F3@.microsoft.com...
> >I am new to reporting services. I'm using 2005. I have some reports
> > deployed and working. When I go to them directly by URL with some
> > parameters
> > in the URL, the parameters don't do anything. I've tried some of the
> > built
> > in rc parameters and my own parameter values. Is there a setting I'm
> > missing or something? Thanks.
>
>

Parameters Help!

I am passing parameters in my report. When I bring up the reports it shows
all 15 parameters. I know there is a hide parameters button but is there a
way to change the default view in Report Manager so that the parameters
aren't displayed when the report pops up?
Thanks in advance
osSure, you can also set default parameter values as well.
Log in as someone that has admin privileges on the Report Manager
(http://localhost/reports)
Go to the report in question.
Select the properties page.
Select the parameters link on the left.
Set the appropriate defaults/visibility.
"OriginalStealth" <OriginalStealth@.discussions.microsoft.com> wrote in
message news:02467DA9-8605-4E63-A21F-FFAB5912DEA5@.microsoft.com...
>I am passing parameters in my report. When I bring up the reports it shows
> all 15 parameters. I know there is a hide parameters button but is there
> a
> way to change the default view in Report Manager so that the parameters
> aren't displayed when the report pops up?
> Thanks in advance
> os|||Another alternative is to remove the "Prompt" inside the report parameter
definition
This way your parameter will be hidden
--
Best Regards
Maria Sartzetaki
"OriginalStealth" wrote:
> I am passing parameters in my report. When I bring up the reports it shows
> all 15 parameters. I know there is a hide parameters button but is there a
> way to change the default view in Report Manager so that the parameters
> aren't displayed when the report pops up?
> Thanks in advance
> os

Parameters defined in .rdl and how they are applied in Report Manager

One of my reports is defined as follows in .rdl:

<ReportParameter Name="ExplicitProject">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Agile_1029c</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>ExplicitProject</Prompt>
</ReportParameter>

In Report Manager, I have overriden this value by specifying that the default value be an empty string. The report uses the value I specified in Report Manager.

How does this work? Where does Report Server store the overriden definition? There seem to be two places where the rendering is getting its specification. Is there a hierarchy i.e. first check .rdl, then check (wherever the overrides are stored?)

Kind Regards
Jean-Pierre

The overridden parameters are stored in the report catalog. If you override the report parameters in the Report Manager and subsequently deploy the report definition with new default values, you will find that the parameter default values don't change. This is done to favor the report administrators. You can only change default values of a deployed report programatically. The other option is to delete the report and re-deploy.|||

Thank you Teo. THis has been of great help.

Parameters are disabled

I've set three parameters in the reports. However, when it is deployed, the
three parameters (textbox & dropdown list) become disabled? Is there
anything that need to set to make it enable?
Please advise.On Dec 2, 10:12 pm, YeungTakYan
<YeungTak...@.discussions.microsoft.com> wrote:
> I've set three parameters in the reports. However, when it is deployed, the
> three parameters (textbox & dropdown list) become disabled? Is there
> anything that need to set to make it enable?
> Please advise.
Are you using a different datasource for the parameters than you are
for the report itself? If so, make sure that the datasource is
available in the Report Manager on the production server. Also, by
default, the datasource for the report when it is first deployed is
not set. You normally set it by selecting the Properties tab (I
believe it is) and then select Datasources and select the datasource
from the top. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Parameters

Hi !
How come i pass olap parameter to my subreport?
I have two reports and i'd like link these reports by parameters, but when a
put parameter to link the value doen't pass to subreport.
I use SSAS 2005 and my parameters are dimension of my cube.
Help me !!!!
Thanks.
--
MattosCreate a custom member in your "parent" report. Example:
If you had the ReportDate attribute of the [Time] dimension in your report
and it needed to be passed to the sub-report, you'd create a custom member
with the definition
'[Time].[ReportDate].CurrentMember.UniqueName'
This would return something like
'[Time].[ReportDate].&[2006-05-26T00:00:00]'.
When you've added the sub-report, make sure you set up the parameters for it
too. They can be either parameters in the primary report or they can be
field values.
"André Mattos" <AndrMattos@.discussions.microsoft.com> wrote in message
news:3AD0B66F-FF85-4A76-A615-3A4B033B053C@.microsoft.com...
> Hi !
> How come i pass olap parameter to my subreport?
> I have two reports and i'd like link these reports by parameters, but when
> a
> put parameter to link the value doen't pass to subreport.
> I use SSAS 2005 and my parameters are dimension of my cube.
> Help me !!!!
> Thanks.
> --
> Mattos|||Tim,
Thanks, now work well.
André Mattos
--
Mattos
"Tim Dot NoSpam" wrote:
> Create a custom member in your "parent" report. Example:
> If you had the ReportDate attribute of the [Time] dimension in your report
> and it needed to be passed to the sub-report, you'd create a custom member
> with the definition
> '[Time].[ReportDate].CurrentMember.UniqueName'
> This would return something like
> '[Time].[ReportDate].&[2006-05-26T00:00:00]'.
> When you've added the sub-report, make sure you set up the parameters for it
> too. They can be either parameters in the primary report or they can be
> field values.
>
> "André Mattos" <AndrMattos@.discussions.microsoft.com> wrote in message
> news:3AD0B66F-FF85-4A76-A615-3A4B033B053C@.microsoft.com...
> > Hi !
> >
> > How come i pass olap parameter to my subreport?
> >
> > I have two reports and i'd like link these reports by parameters, but when
> > a
> > put parameter to link the value doen't pass to subreport.
> >
> > I use SSAS 2005 and my parameters are dimension of my cube.
> >
> > Help me !!!!
> >
> > Thanks.
> > --
> > Mattos
>
>