I know. I am just sad about it :( I agree, there is a lot to love in SSRS, but how prompts for data are handled is not one of them.
I also agree that I don't have a lot of reports that use this, but the ones that I do have are run frequently. The get me a list of machines that have "X" installed, where "X" is not exactly known and needs to be wildcarded is a very frequently run report (at least round here.) If you think inline autocomplete for prompts in SSRS would help out in your workflows for SCCM reporting, you can upvote the change on Connect here http://connect.microsoft.com/SQLServer/feedback/details/582839/ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, September 26, 2013 9:35 AM To: [email protected] Subject: [mssms] RE: Reporting SSRS problems I hear what you are saying, however, to be successful with RS you'll need to change your mindset. ASP reports are not coming back, and IMO that is a good thing. Here are a few suggestions: - use cascading parameters that takes a larger parameter result set to a more limited result set on a second parameter. - use an open text box, and in the query use a LIKE and wrap the entered text with %Text1.Value% - transfer the selected text value from the dropdown, and display in another text box. Allow that text box to be edited and used in the report query Based on my experience of creating and editing dozens, if not hundreds of reports, the scenario you describe is not that common. I'm not minimizing what you are describing, rather pointing out that this will take a different approach. Hope this helps, Steve From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Miller, Todd Sent: Wednesday, September 25, 2013 6:18 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Reporting SSRS problems Drop down lists, in my opinion are not very useful. Even when filtered into something manageable, you still cant edit the value you've selected. Let's say you want to report on something like Microsoft Word. So you have a report that runs against installed software. You want to search for Microsoft Word%, but a dropdown would only list discrete values like Microsoft Word 2010, Microsoft Word 2008, etc. No way to report on Microsoft Word%. I would need to have separate reports for discrete and for selected values. Ugh. maddening. No way to return a selected value into a text box? Has anyone implemented the ajax option? Are there, commercial or otherwise, front ends to using SSRS for reporting against the SCCM databse that have reasonable adoption? These limitations are bringing me down. ________________________________ From: [email protected]<mailto:[email protected]> [[email protected]] on behalf of [email protected]<mailto:[email protected]> [[email protected]] Sent: Wednesday, September 25, 2013 6:28 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Reporting SSRS problems There are a few techniques out there... Here is one: http://tpuch.blogspot.com/2011/02/options-for-filtering-parameter-values.html From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Miller, Todd Sent: Wednesday, September 25, 2013 1:03 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] Reporting SSRS problems I am having ASP reporting withdrawl. There are certain workflows that I rely on heavily that I can't figure out how to mimic in 2012. Is there a way in SSRS to make filtering behave more like it did in ASP reports? I mean, type in a little bit of test into a box, select a value and have that value pass back to the text box? Here is what I am talking about..... Is there a way to do something like this? www.jqueryui.com/autocomplete<http://www.jqueryui.com/autocomplete> Type the text "script" into the box - it shows all the values with script as filter text. I can select one and then edit it too. These drop down lists in the canned reports are worthless. Drop down lists of collections list every collection - hundreds or thousands of values. When I want to see what machine have a particular piece of software installed, I have to pick from a drop down, or know the name exactly. The dropdown filter is somewhat useful, but once you have selected a value in the dropdown, you cannot edit the value - that sucks. ________________________________ Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you. ________________________________ ________________________________ Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you. ________________________________ ________________________________ Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you. ________________________________
