How to use the same stored procedure to display two different char

I need to display two charts on a report based on the same stored procedure
that accepts a single parameter. I do not wish to be promted for the
parameter. Instead, I would like to pass two different values to each chart
within the report.
Please advise.
Thanks,
KonstantinHow do you know what value to pass it?
Anyway, something to get you going in the right direction. First thing to
realize is that query parameters and report parameters are two different
things. RS automatically creates a report parameter for you for each stored
procedure query parameter it sees. But, you don't have to use it. You can
map it to an expression instead. Click on the ..., parameters tab. On the
right pick change it from mapping to a report parameter and map it to an
expression instead.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Konstantin Shaumyan" <KonstantinShaumyan@.discussions.microsoft.com> wrote
in message news:3A7E2C6B-FF43-4993-9B21-04EA79316410@.microsoft.com...
>I need to display two charts on a report based on the same stored procedure
> that accepts a single parameter. I do not wish to be promted for the
> parameter. Instead, I would like to pass two different values to each
> chart
> within the report.
> Please advise.
> Thanks,
> Konstantin|||Thanks for the tip.
I created two datasets based on the same stored procedure for each graph and
set my parameter for each dataset to literals.
Everything worked as expected.
Regards,
Konstantin
"Bruce L-C [MVP]" wrote:
> How do you know what value to pass it?
> Anyway, something to get you going in the right direction. First thing to
> realize is that query parameters and report parameters are two different
> things. RS automatically creates a report parameter for you for each stored
> procedure query parameter it sees. But, you don't have to use it. You can
> map it to an expression instead. Click on the ..., parameters tab. On the
> right pick change it from mapping to a report parameter and map it to an
> expression instead.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Konstantin Shaumyan" <KonstantinShaumyan@.discussions.microsoft.com> wrote
> in message news:3A7E2C6B-FF43-4993-9B21-04EA79316410@.microsoft.com...
> >I need to display two charts on a report based on the same stored procedure
> > that accepts a single parameter. I do not wish to be promted for the
> > parameter. Instead, I would like to pass two different values to each
> > chart
> > within the report.
> >
> > Please advise.
> >
> > Thanks,
> > Konstantin
>
>sql

How to use Fields or ReportItems value in charts

Hi, all. I am doing a financial report needs to show last 10 yrs history data. The end year is the last year of the current year. How can I set the minumum and maximun with Year(Now) fucntion for the x-axis, to represent the years? Is there any way to use Fields value for the chart minumum and maximun?

Yes this is possible in RS 2005 (but not in RS 2000). Axis settings such as min/max/crossat/major interval/minor interval can be expression-based. Just type in the expression as e.g. =Year(Now)

-- Robert

|||Thanks Robert. Actually I want to put the Year(Now)(2006) as maximun and Year(Now) -10(1996) as Minimun. However, the data I have are bewteen 1998 and 2002, so the chart still shows data from 1998 to 2002. Can I set exactly 10 years on the chart? Even thought there're no data at 2006 and 1996?|||

This should work fine if the x-axis is set to use "numeric / time-scale values" and the category grouping expression evaluates to either integer values or DateTime objects.

-- Robert

how to use bookmarks in a report ??

I have a report with three different charts.
I would like to provide a link to each chart at the top of the report - so
when a user clicks the link, they are taken to the relevant chart.
Can anyone tell me how to create a bookmark on a chart (or a textbox, or
anything!) - and link to it.
I've looked at Microsofts "how-to" explanation - but it is vague, and gives
no example
TIAYou can create bookmarks by setting the "Document Map Label" on the
properties tab. You can set this on textbox columns, and doesnt look like you
can set this on charts. But the work around is -
Just above the chart, create a empty textbox. Right click on the textbox, go
to properties and on the visibility tab set the visibility to hidden.
(Because you dont want to see the textbox) Next on the Navigation tab on the
document map label enter "Chart1" also fill in a BookMark ID . Lets say
"Chart1BM". Now deploy the report and see. Since you created a document map
label, you will see a document map on the left side of the report, which will
take you directly to the chart1. Also if you want to jump to the chart1 from
somewhere in the report (and not from the document map). Right click (from
that point where you want a link to Chart1), go to properties and then select
navigation, and selecte jump to bookmark, and type in the bookmarkname name
that you gave before- "Chart1BM".
Hope that helps.
The document label is to create a table of contents type of thing, and the
BookMarkID is to set BookMarks
"grasshopper" wrote:
> I have a report with three different charts.
> I would like to provide a link to each chart at the top of the report - so
> when a user clicks the link, they are taken to the relevant chart.
> Can anyone tell me how to create a bookmark on a chart (or a textbox, or
> anything!) - and link to it.
> I've looked at Microsofts "how-to" explanation - but it is vague, and gives
> no example
> TIA|||Thanks for the info Nagini - I also found that this works:
select the item to be bookmarked. In the properties window (View |
Properties Window), there is a field called 'Bookmark'. Enter any unique
string in the bookmark property e.g. "bookmark1"
select the item that will serve as a link to the bookmark. Right-Click and
select 'Properties'. In the properties dialogue box - go to "Advanced >> |
Navigation tab| jump to bookmark". Enter the unique string "bookmark1" and
hit OK.
Preview the report and click on the link to jump to the bookmark.
The above will work for charts too, as they also have a 'bookmark' property
that can be used. I have used this method to drill-down from one chart to a
second more detailed chart via 'properties | navigation | bookmark'
Regards
"Nagini Indugula" wrote:
> You can create bookmarks by setting the "Document Map Label" on the
> properties tab. You can set this on textbox columns, and doesnt look like you
> can set this on charts. But the work around is -
> Just above the chart, create a empty textbox. Right click on the textbox, go
> to properties and on the visibility tab set the visibility to hidden.
> (Because you dont want to see the textbox) Next on the Navigation tab on the
> document map label enter "Chart1" also fill in a BookMark ID . Lets say
> "Chart1BM". Now deploy the report and see. Since you created a document map
> label, you will see a document map on the left side of the report, which will
> take you directly to the chart1. Also if you want to jump to the chart1 from
> somewhere in the report (and not from the document map). Right click (from
> that point where you want a link to Chart1), go to properties and then select
> navigation, and selecte jump to bookmark, and type in the bookmarkname name
> that you gave before- "Chart1BM".
> Hope that helps.
> The document label is to create a table of contents type of thing, and the
> BookMarkID is to set BookMarks
> "grasshopper" wrote:
> > I have a report with three different charts.
> >
> > I would like to provide a link to each chart at the top of the report - so
> > when a user clicks the link, they are taken to the relevant chart.
> >
> > Can anyone tell me how to create a bookmark on a chart (or a textbox, or
> > anything!) - and link to it.
> >
> > I've looked at Microsofts "how-to" explanation - but it is vague, and gives
> > no example
> >
> > TIA