We currently use SQL Server 2005 Enterprise for our fairly large application, that has its roots in pre SQL Server 7.0. The tables are normalized and designed mainly for the application. The developers for the most part have the legacy SQL Server mindset. Only using the part of TSQL that existed back in 7.0, not using any of the new f...
I would like to search between to columns in a s query or a table depending on the variable on a paramenter e.g Declare @SelectAll as interger Set @SelectAll = 1 Declare @Column as interger Select mt.Column1, mtColumn2 From MyTable as mt Where Case When @SelectAll = 1 Then mt.Column1 IN(@Column) and mt.Column2 (' Selecting...
Hi, After installing and configuring Reporting Services on a virtual site with a ASP.NET MVC running on the root folder, I get this "Error" : Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file ap...
I'm trying to build a simple RDLC report that shows some data, and has a 'select' link that sends the browser off to a certain url with some data in the querystring (a key). In the vs2010 report designer, I can double-click on the column, then select action, and there are a bunch of thigns that seem like they might work. But none of th...
Hi All, I have a dataset which I want to use as a parameter for my chart in SSRS. The puzzle that I am trying to solve is as below. My DataSet has 4 columns and in the Dropdown parameter I can only specify label and value. I am not able to specify two columns as Label and two columns as value. Does anyone know how to concat the values...
Hi, We are using the ReportViewer control to display SSRS reports in our ASP.NET application. On pages where we use the ReportViewer control the session does not time out. The reason for this is the ReportViewer control emits a "setTimeOut" javascript function which reads the Session timeout value from the web.config and pings the serve...
So I am trying to change the number of fields in my dataset in SSRS and the refresh button is not picking up the added field from the SQL server. The query is definitely returning the correct data, as I have double checked in the server engine itself. Also, I have tried manually adding the field using the SSRS menu, but as soon as I exec...
Hi, I have two parameters using two different datasets. One is where you select a Sales Rep and one is where you select Account Manager to show their sales. I want to show all records that match the Sales Rep or Account Manager that are selected. Some are Sales Rep are also in the Account Manager list. Is there a way to make sure if...
Hi all--I'm having some issues with a report I'm trying to create for TFS work items that creates a stacked chart based on work item state and the cumulative count. I have Sum(Cumulative_Count) as the data field, System_State as the series field and Date as the category field. The problem I'm having is that for this stacked chart to be ...
How do you you display the running GROUP count via SSRS 2005? I have a report that has n groups where the source data must remain anonymous and I want that number in the header of the group... So instead of the name in the group header like such... Employee - John Smith Employee - Mary Swain ... Employee - Ahmad Sal I want... Employee...
The structure of report is like Main table Row 1 - Another table with master data (sort of header) Row 2 - Split into two sections : 1st section has 4 columns, second section is a table. Row 3 - Detail Table Row 4 - Kinda footer. Now there are no page breaks anywhere. Somehow after Row 2 in some records there is a page break. The ...
I'm working on a Microsoft Dynamics CRM Quote with a separate header report and sub report. The sub-report has a detail grid of what is quote, a terms and conditions statement which amounts to a large block of text, and other items. When the report shows on screen, the Quote looks just like I intended. However, when I export to Word ...
When create a report and deploy it on reporting service, I can access it with folloing url as PDF: http://localhost:81/reportserver?/MyReports/Report1&rs:Command=Render&rs:Format=PDF It is fine but it will give you a download dialog window and the open the PDF report by Adobe reader seperately and leave the browser window empty...
I need to call SSRS Report WebService using jQuery ajax request. Since the ssrs webservice is SOAP based and considering the example shown for "calling share point web services using jquery" I think I need to pass a soap envelope. Based on the ssrs webservice url how can i find out the soap envelope required by a particular method? (ex...
Good Day, I am creating a report with Reporting Services and am using several text boxes horizontally aligned next to each other. I would like to put periods so that report looks like: 1234 Robert Jones................... (234) 921-4922 1235 Jennifer Wilson................ (919) 582-2914 Is this possible to right-pad the text box w...
This is my statement: iif(sum(Fields!myfield1.Value) = 0, 0, sum(Fields!myField2.Value)/sum(Fields!myField1.Value)) Any suggestions? ...
I have a report that shows or hides columns in a group based on a header cell. SSRS makes this pretty easy and is kind enough to place a little plus/minus icon in the toggling cell. I want to HIDE this plus/minus icon when there is only one column of data in the subgroup, because it shows that one column by default so expanding the gro...
This week my team spent way too much time trying to do simple things in reporting services, and I've decided to start evaluating other options. I know there are some good options out there now that aren't too expensive. I've heard that Telerik, ActiveReports, and a few others are widely used. I was hoping to get some first hand accoun...
First, I ask that you not ask 'why.' In the famous words of Tennyson "Ours is not to reason why. Ours is but to do and die." It's one of those, "This is what you have, deal with it." situations. The source data comes from SSRS report. The goal is to load the data into a database via SSIS. The hopeful goal is to avoid human interventi...
I have a SQL query - fairly complex, but not too bad. When I run the SQL query in Management Studio, the query runs in about 10 seconds or less. When I put the SQL query directly into a reporting services report, the query runs in about 10 seconds or less. When I put the exact same SQL query into a stored procedure, and cal...