Showing posts with label parameters. Show all posts
Showing posts with label parameters. Show all posts

Friday, March 30, 2012

pop up requirement

how do we click on anything within the reports, pass the parameters to another reports and also make the drill thru report open in a new page

See this page for information on Report Interactivity, including jumping to other Reports or Urls, http://msdn2.microsoft.com/en-us/library/ms345258(sql.90).aspx

If you need to have the report open in a new window, then you will need to use the Jump to Url method using javascript, like the following,

=void(window.open('" & Globals!ReportServerUrl & "?/ReportName&rs:Command=Render&rs:Format=Html4.0&Parameter1=" & Fields!Field1.Value & "','_blank'))"

Friday, March 9, 2012

plot data as line option

I have a bar chart that compares data across two dates. These dates are
passed in as parameters. Currently these are displayed as bars but i'd like
the first to be shown as a line. The query groups by date.I assume you have two data series in the chart. Right-click on the chart to
open the chart properties dialog. In the chart properties dialog box, click
the Data tab. In the Values list, click the one data series you want to show
as line, and then click Edit. In the Edit Chart Value dialog box, click the
Appearance tab. Click to select the "Plot data as line" check box.
You may also be interested in a related KB article:
http://support.microsoft.com/kb/842422
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Melissag" <Melissag@.discussions.microsoft.com> wrote in message
news:1DDFCCAE-3BD6-4BBA-AF10-CE2201A66BD0@.microsoft.com...
>I have a bar chart that compares data across two dates. These dates are
> passed in as parameters. Currently these are displayed as bars but i'd
> like
> the first to be shown as a line. The query groups by date.|||Hi Robert,
At the moment i have a single data series: date derived from a group by date
in the query. How would i go about created two data series one for each date?
Thanks,
Melissa.
"Robert Bruckner [MSFT]" wrote:
> I assume you have two data series in the chart. Right-click on the chart to
> open the chart properties dialog. In the chart properties dialog box, click
> the Data tab. In the Values list, click the one data series you want to show
> as line, and then click Edit. In the Edit Chart Value dialog box, click the
> Appearance tab. Click to select the "Plot data as line" check box.
> You may also be interested in a related KB article:
> http://support.microsoft.com/kb/842422
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Melissag" <Melissag@.discussions.microsoft.com> wrote in message
> news:1DDFCCAE-3BD6-4BBA-AF10-CE2201A66BD0@.microsoft.com...
> >I have a bar chart that compares data across two dates. These dates are
> > passed in as parameters. Currently these are displayed as bars but i'd
> > like
> > the first to be shown as a line. The query groups by date.
>
>

Please tell me you are joking - All member multivalue parameter

In 2005 SP1, there is no longer an automatic <Select All> option for multivalued parameters. You now need to modify the dataset providing the values for the prompt and modify the dataset containing the parameter. This makes no sense! I am so confused. It was working fine. Why did you have to go and mess with it? If you want to add value somewhere, try making the width of the drop down box for multi value parameters resize to the text in the box, or at least make the width configurable. I am not accepting any multi dimensional data source performance excuses either. Rediculous.

I agree 100%.

The worst part is that I cannot uninstall SP1 by itself.