Dual parameters for same value

Posted by n0chi on Stack Overflow See other posts from Stack Overflow or by n0chi
Published on 2010-03-25T16:00:43Z Indexed on 2010/03/25 16:03 UTC
Read the original article Hit count: 297

Filed under:

ssrs-2005

|

ssrs-reports

Is it possible to have 2 report parameters set the same actual parameter? For example, the user should either be able to type in an ID, or select it from a dropdown list - for the query to then take that id and run the proc for that id.

© Stack Overflow or respective owner

Related posts about ssrs-2005

Error in Visual Studio 2008 with SSRS 2005 report projects

as seen on Stack Overflow - Search for 'Stack Overflow'
Has anyone found a good workaound for opening or editing an SSRS 2005 report project with Visual Studio 2008 yet? Will the SQL server 2008 tools be the migration path for these report projects in the future? I really dont want to have to keep VS2005 installed forever just to update SSRS reports… >>> More
SSRS 2005 tabs/newline characters display in table

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How can i get a column in an SSRS 2005 report to render control chars like new lines and tabs? For example: SELECT VW.System_name + CHAR(13) + CHAR(9) + ' > ' + VW.PTS_NAME + CHAR(13) + CHAR(9) + CHAR(9) + ' > ' + VW.FEED_NAME as Name In SSRS (and SSMS Results to Grid Mode) table… >>> More
SSRS 2005 - Cascading parameters and default value update problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a report with cascading parameters. The first parameter is Finanical Period Type, being either Month or Week. The second parameter is a list of either financial months or weeks depending on what was selected for the first parameter. This all works well and selecting a series of different Financial… >>> More
How do I convert an INT into HH:mm:ss using SSRS 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Ok I need to display total talk time of an agent that is coming into SRSS 2005 from SQL 2005 as an INT. For the life of me I cannot figure out what combination of expression editing or format editing I need to use. For the detail portion I can use: =DATEADD("s", SUM(Fields!Talk_Time.Value), CDate("00:00")) And… >>> More
How to pass Multivalued parameters through URL in SSRS 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I have main matrix report and I want to navigate my sub report from main report by Jump To URL:(Using below JavaScript function) method. ="javascript:void(window.open('http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fKonsolidata_Data_Exporting_Project%2fEXPORT_REPORT_TEST&rs:Command=Render&RP_cntry="+Fields… >>> More

Related posts about ssrs-reports

unable to open SSRS reports from domain IP

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have developed the SSRS reports. It is running fine locally. but after deployed on the domain server it showing exception XML Parsing Error: no element found Location: http://{MyDomainIP}:{port}/Reports/Pages/Folder.aspx Line Number 1, Column 1: I have deployed these reports under the windows… >>> More
TFS webtest for SSRS reports issue

as seen on Stack Overflow - Search for 'Stack Overflow'
I am creating webtests in TFS and trying to test reports execution in SSRS. When I record the initial process, it includes Reserved.ReportViewerWebControl.axd files. These files are what is causing the problem. When I remove the files, the report does not display, however if I keep the AXD files… >>> More
Auto-Deploy SSRS reports with TFS

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, Can anyone explain how to create a custom build to deploy reporting services reports with TFS? Is it possible? If so then how... Samples or articles will be greatly appreciated. Thanks >>> More
SSRS 2005 - Cascading parameters and default value update problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a report with cascading parameters. The first parameter is Finanical Period Type, being either Month or Week. The second parameter is a list of either financial months or weeks depending on what was selected for the first parameter. This all works well and selecting a series of different Financial… >>> More
Removing blank page at end of SSRS Report

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a report that produces a blank page at the end of the report. How do I get rid of it? The report consists of text/list boxes that are embedded inside a rectangle. The rectangle has the property selected: "Add page break after". If this option is selected the report renders exactly how it should… >>> More