I am using sql server 2005. I have a report with 2 columns.one for report name and the other for status.I want that when a user clicks on a report’s status column,the corresponding report should be opened. i am using the following code in the navigation tab–>jump to report. =Iif(Fields!SUB_REPORT.Value=”GFM_FX_EXPOSURE$”,”www.google.co.in”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_EXP$”,”GFM_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_MV$”,”GFM_INST_TYPE_MV”, Iif(Fields!SUB_REPORT.Value=”GSS_FX_EXPOSURE$”,”GSS_FX_EXPOSURE”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_EXP$”,”GSS_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_MV$”,”GSS_INST_TYPE_MV”, [...]
Answer Question | February 22, 2011 8:07 AM
SQL Reports, SQL Server 2005, SQL Server reporting, Visual Studio 2005
How to include to Input parameters in the report, so as to help users identify the parameters on which the report was run.
Answer Question | October 4, 2010 12:06 PM
input parameters, Parameters, SQL Server, SQL Server reporting, SQL Server Reporting Services, SSRS, SSRS reports, SSRS Reports 2005
I have used SQL Server reports in my web application, and I can see it on the same server but we are getting a “Server Not Found” error on my user’s machine.
Answer Question | March 30, 2009 6:24 PM
SQL Server error messages, SQL Server reporting, SQL Server Reports, Web application software
Using STANDARD REPORT CREATION WIZARD, I connected to UNIVERSES Data Sources and RUN a querry in BUSINESS OBJECTS QUERY PANEL, When I pull in fields from the universe into the query panel. But, the minute they hit “OK” they get and error that says “Login Failed.” i am getting ERROR Message “Failed to Retrieve SQL”.What [...]
Answer Question | March 20, 2009 6:27 PM
Microsoft SQL Reporting Services, SQL error messages, SQL Server reporting
I have a SQL Server database of customers that called our company, and now i want to prepare a report that indicates which ones are new to our database. How would I do this?
Answer Question | March 4, 2009 7:52 PM
SQL Server database, SQL Server Report Builder, SQL Server reporting, SQL Server Reports
I am on SQL Server 2008, and we want the clients to be able to build their own reports whenever they want. Are there any tools out there that can do this?
Answer Question | January 22, 2009 5:54 PM
SQL Server 2008, SQL Server reporting, SQL Server Reports
I am trying to use Report Model in SQL Server Report Builder, but when I run the created report I am getting the following error: “Cannot create a connection to data source ‘dataSource1′. —————————- An error has occurred during report processing.” What can I do to avoid this error?
Answer Question | December 2, 2008 2:58 PM
Report Model, SQL Server errors, SQL Server Report Builder, SQL Server reporting
In my application, i have to display “No Data Available ” at the pie-chart when there is no data to show in pie-chart… I have done that by setting the NoRows property to “No Data Available” , but the graph block shrinks by 1-2 mm when there is no data..Can anyone provide me the solution [...]
Answer Question | November 18, 2008 2:11 PM
SQL Server reporting
We have SQL Server Reporting Services installed and I have created several reports. However, I cannot get the Report Manager website to work so I can deploy the reports. How would I do this?
Answer Question | October 31, 2008 6:56 PM
SQL Server, SQL Server reporting, SQL Server Reporting Services
I am trying to design a report from an Excel worksheet, and I’m not sure how to get this information into SQL. I have 180 files with multiple tabs in each that house all the data I need, but I only need one tab from each of the files. Is there an easy way to [...]
Answer Question | September 23, 2008 3:20 PM
Microsoft Excel, SQL, SQL Server reporting
Sql Server Reporting service. 1.first query I have given a task of generating reports using sql server reporting service.I need to generate a summary view as below, Fig:1 Jan-08 Feb-08 Mar-08 Bug Trend ECR 3.88 4.06 3.86 Goal 5.00 5.00 5.00 Backlog 70 75 82 Incoming67 71 55 Outgoing62 65 56 Outstanding75 82 81 But [...]
Answer Question | August 18, 2008 12:49 PM
SQL Server reporting, SQL Server Reporting Services
Hello I have a slight problem when end users are trying to export reports into Excel. When they export the report, one or two columns in the report appear to merge together once exported into Excel, thereby making it difficult for my end users to perform spreadsheet data manipulations.
Answer Question | July 12, 2011 8:33 AM
Microsoft Excel, SQL Server reporting, SQL Server Reporting Services, SSRS
I’m trying to export data from a sql table into sql reporter. The information I’m trying to retrieve is information regarding permissions (this is audit stuff). The problem is, there are spaces (and always a different amount of spaces) between the user and the permissions; for example: Type Account Permissions —– —————————- ————– Allow CREATOR [...]
Answer Question | July 8, 2008 1:10 PM
SQL Server permissions, SQL Server reporting, SQL statements
How to make the Reports layout change automatically? That it looks just like the clients webpage? Even when they change their colors, borders etc.
Answer Question | June 24, 2008 11:57 AM
SQL Server 2005, SQL Server reporting, SQL Server Reporting Services, SSRS, SSRS 2005
While I host SSRS on a Win XP Prof machine is there a limitation on the number of users who can access this site at once.
Answer Question | March 17, 2008 6:00 AM
SQL Server reporting, SQL Server Reporting Services, SSRS