I have a report with 4 parameters
2 of them are dropdown menus, one contains groups that populate the other
dropdown box with computer names. The report works great but I would like to
have an ALL function in the computer name dropdown box.
From poking around here I was able to plug a UNION SELECT 'All' AS
ComputerName into the dataset that builds the computername list but I am no
sql wiz by any stretch of the imagination and it seems that is just plugging
in All to the dropdown without any meaning behind it.
Has anyone done this sort of thing before or have any examples they could
share?
Thanks!
Kevinhttp://blogs.msdn.com/chrishays/archive/2004/07/27/199157.aspx
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Kevin Serafin" <kevin.serafinISHEREATecolabDOTcom> wrote in message
news:enxx48jeEHA.2852@.tk2msftngp13.phx.gbl...
> I have a report with 4 parameters
> 2 of them are dropdown menus, one contains groups that populate the other
> dropdown box with computer names. The report works great but I would like
to
> have an ALL function in the computer name dropdown box.
> From poking around here I was able to plug a UNION SELECT 'All' AS
> ComputerName into the dataset that builds the computername list but I am
no
> sql wiz by any stretch of the imagination and it seems that is just
plugging
> in All to the dropdown without any meaning behind it.
> Has anyone done this sort of thing before or have any examples they could
> share?
> Thanks!
> Kevin
>|||Thanks Chris, works great!
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:us4dvpleEHA.140@.TK2MSFTNGP12.phx.gbl...
> http://blogs.msdn.com/chrishays/archive/2004/07/27/199157.aspx
> --
> This post is provided 'AS IS' with no warranties, and confers no rights.
All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No
user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach
of
> children under 3.
> "Kevin Serafin" <kevin.serafinISHEREATecolabDOTcom> wrote in message
> news:enxx48jeEHA.2852@.tk2msftngp13.phx.gbl...
> > I have a report with 4 parameters
> >
> > 2 of them are dropdown menus, one contains groups that populate the
other
> > dropdown box with computer names. The report works great but I would
like
> to
> > have an ALL function in the computer name dropdown box.
> >
> > From poking around here I was able to plug a UNION SELECT 'All' AS
> > ComputerName into the dataset that builds the computername list but I am
> no
> > sql wiz by any stretch of the imagination and it seems that is just
> plugging
> > in All to the dropdown without any meaning behind it.
> >
> > Has anyone done this sort of thing before or have any examples they
could
> > share?
> >
> > Thanks!
> >
> > Kevin
> >
> >
>
Showing posts with label populate. Show all posts
Showing posts with label populate. Show all posts
Thursday, March 22, 2012
Sunday, March 11, 2012
Drop Down Parameters Not Working
If you select an option from the dropdown list, the secondary dropdown list
does
not populate automatically. It appears that the focus is not being made on
the frame that allows for the user to enter parameters.
Is there a way to make the focus on a certain frame of the Report parameters
form?
I found that once the page loads, as long as I don't select anything in the
primary dropdown list, I can select the frame that the drop down is in, and
then select an option and it works correctly. If I select the option first,
then select the frame, it does not work. I'm not an expert, but to me, this
means that the focus needs to be put on the drop down list frame by Reporting
Service.I had this exact same problem, took a while to figure it out. Some IE
browsers (maybe others too) do this, not really the reporting services. I
believe if you update your browser it can solve this. Otherwise you can add
"&rc:Stylesheet=fix" to the end of you link to the report and it should work.
Hope this helps.
"A.J." wrote:
> If you select an option from the dropdown list, the secondary dropdown list
> does
> not populate automatically. It appears that the focus is not being made on
> the frame that allows for the user to enter parameters.
> Is there a way to make the focus on a certain frame of the Report parameters
> form?
> I found that once the page loads, as long as I don't select anything in the
> primary dropdown list, I can select the frame that the drop down is in, and
> then select an option and it works correctly. If I select the option first,
> then select the frame, it does not work. I'm not an expert, but to me, this
> means that the focus needs to be put on the drop down list frame by Reporting
> Service.|||I tried to update my browser and that didn't work. I already have the latest
from Microsoft. As far as the &rc goes, I didn't development the report, so
I'm not sure how to do this, but I'll pass it on to the owner.
"scraejtp" wrote:
> I had this exact same problem, took a while to figure it out. Some IE
> browsers (maybe others too) do this, not really the reporting services. I
> believe if you update your browser it can solve this. Otherwise you can add
> "&rc:Stylesheet=fix" to the end of you link to the report and it should work.
> Hope this helps.
> "A.J." wrote:
> > If you select an option from the dropdown list, the secondary dropdown list
> > does
> > not populate automatically. It appears that the focus is not being made on
> > the frame that allows for the user to enter parameters.
> >
> > Is there a way to make the focus on a certain frame of the Report parameters
> > form?
> >
> > I found that once the page loads, as long as I don't select anything in the
> > primary dropdown list, I can select the frame that the drop down is in, and
> > then select an option and it works correctly. If I select the option first,
> > then select the frame, it does not work. I'm not an expert, but to me, this
> > means that the focus needs to be put on the drop down list frame by Reporting
> > Service.|||Looks like I got it to work, but I had to revert to a previous version of
I.E. browser. I went from Update Version
"SP1;Q832894;Q867801;Q871260;Q823353;" to simply "SP1", which brings us back
to our original problem occurring after we pushed out Microsoft patch 888113.
This should be a Microsoft issue, if someone knows how to report it.
"scraejtp" wrote:
> I had this exact same problem, took a while to figure it out. Some IE
> browsers (maybe others too) do this, not really the reporting services. I
> believe if you update your browser it can solve this. Otherwise you can add
> "&rc:Stylesheet=fix" to the end of you link to the report and it should work.
> Hope this helps.
> "A.J." wrote:
> > If you select an option from the dropdown list, the secondary dropdown list
> > does
> > not populate automatically. It appears that the focus is not being made on
> > the frame that allows for the user to enter parameters.
> >
> > Is there a way to make the focus on a certain frame of the Report parameters
> > form?
> >
> > I found that once the page loads, as long as I don't select anything in the
> > primary dropdown list, I can select the frame that the drop down is in, and
> > then select an option and it works correctly. If I select the option first,
> > then select the frame, it does not work. I'm not an expert, but to me, this
> > means that the focus needs to be put on the drop down list frame by Reporting
> > Service.
does
not populate automatically. It appears that the focus is not being made on
the frame that allows for the user to enter parameters.
Is there a way to make the focus on a certain frame of the Report parameters
form?
I found that once the page loads, as long as I don't select anything in the
primary dropdown list, I can select the frame that the drop down is in, and
then select an option and it works correctly. If I select the option first,
then select the frame, it does not work. I'm not an expert, but to me, this
means that the focus needs to be put on the drop down list frame by Reporting
Service.I had this exact same problem, took a while to figure it out. Some IE
browsers (maybe others too) do this, not really the reporting services. I
believe if you update your browser it can solve this. Otherwise you can add
"&rc:Stylesheet=fix" to the end of you link to the report and it should work.
Hope this helps.
"A.J." wrote:
> If you select an option from the dropdown list, the secondary dropdown list
> does
> not populate automatically. It appears that the focus is not being made on
> the frame that allows for the user to enter parameters.
> Is there a way to make the focus on a certain frame of the Report parameters
> form?
> I found that once the page loads, as long as I don't select anything in the
> primary dropdown list, I can select the frame that the drop down is in, and
> then select an option and it works correctly. If I select the option first,
> then select the frame, it does not work. I'm not an expert, but to me, this
> means that the focus needs to be put on the drop down list frame by Reporting
> Service.|||I tried to update my browser and that didn't work. I already have the latest
from Microsoft. As far as the &rc goes, I didn't development the report, so
I'm not sure how to do this, but I'll pass it on to the owner.
"scraejtp" wrote:
> I had this exact same problem, took a while to figure it out. Some IE
> browsers (maybe others too) do this, not really the reporting services. I
> believe if you update your browser it can solve this. Otherwise you can add
> "&rc:Stylesheet=fix" to the end of you link to the report and it should work.
> Hope this helps.
> "A.J." wrote:
> > If you select an option from the dropdown list, the secondary dropdown list
> > does
> > not populate automatically. It appears that the focus is not being made on
> > the frame that allows for the user to enter parameters.
> >
> > Is there a way to make the focus on a certain frame of the Report parameters
> > form?
> >
> > I found that once the page loads, as long as I don't select anything in the
> > primary dropdown list, I can select the frame that the drop down is in, and
> > then select an option and it works correctly. If I select the option first,
> > then select the frame, it does not work. I'm not an expert, but to me, this
> > means that the focus needs to be put on the drop down list frame by Reporting
> > Service.|||Looks like I got it to work, but I had to revert to a previous version of
I.E. browser. I went from Update Version
"SP1;Q832894;Q867801;Q871260;Q823353;" to simply "SP1", which brings us back
to our original problem occurring after we pushed out Microsoft patch 888113.
This should be a Microsoft issue, if someone knows how to report it.
"scraejtp" wrote:
> I had this exact same problem, took a while to figure it out. Some IE
> browsers (maybe others too) do this, not really the reporting services. I
> believe if you update your browser it can solve this. Otherwise you can add
> "&rc:Stylesheet=fix" to the end of you link to the report and it should work.
> Hope this helps.
> "A.J." wrote:
> > If you select an option from the dropdown list, the secondary dropdown list
> > does
> > not populate automatically. It appears that the focus is not being made on
> > the frame that allows for the user to enter parameters.
> >
> > Is there a way to make the focus on a certain frame of the Report parameters
> > form?
> >
> > I found that once the page loads, as long as I don't select anything in the
> > primary dropdown list, I can select the frame that the drop down is in, and
> > then select an option and it works correctly. If I select the option first,
> > then select the frame, it does not work. I'm not an expert, but to me, this
> > means that the focus needs to be put on the drop down list frame by Reporting
> > Service.
Subscribe to:
Posts (Atom)