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.
>
>
Showing posts with label depending. Show all posts
Showing posts with label depending. Show all posts
Monday, March 12, 2012
Saturday, February 25, 2012
Parameters
Hello,
I have a report with 2 parameters ( 2 combo boxes ). I would like the
content of the second combox box dynamically to change depending on what I
select in the first combobox.
Is it possible to achieve this in SQL reporting services ?
Thank you
PascalYes, look at this posting
http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=51ea6a57-7bec-4787-93bc-5899a3ea9d71&mid=491a878a-2a2e-4cda-a96a-2cdc00423519
HTH
Charles Kangi, MCT, MCDBA
"Pascal Simler" wrote:
> Hello,
> I have a report with 2 parameters ( 2 combo boxes ). I would like the
> content of the second combox box dynamically to change depending on what I
> select in the first combobox.
> Is it possible to achieve this in SQL reporting services ?
> Thank you
> Pascal
>
>
I have a report with 2 parameters ( 2 combo boxes ). I would like the
content of the second combox box dynamically to change depending on what I
select in the first combobox.
Is it possible to achieve this in SQL reporting services ?
Thank you
PascalYes, look at this posting
http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=51ea6a57-7bec-4787-93bc-5899a3ea9d71&mid=491a878a-2a2e-4cda-a96a-2cdc00423519
HTH
Charles Kangi, MCT, MCDBA
"Pascal Simler" wrote:
> Hello,
> I have a report with 2 parameters ( 2 combo boxes ). I would like the
> content of the second combox box dynamically to change depending on what I
> select in the first combobox.
> Is it possible to achieve this in SQL reporting services ?
> Thank you
> Pascal
>
>
Subscribe to:
Posts (Atom)