Where is the data (xml?) stored when a report is deployed?
When I haved developed a Reporting Services report and deployed it to the server, where is the actual report stored? I'm guessing the SQL-database, but what table and in what format? ...
reporting-services
Oracle 11g datasource on SQL Server Reporting Server 2008 R2
I have a SQL Server Reporting Server R2 installed on a Windows 2008 R2 machine. I want to store and run a report that selects its data from an Oracle 11g server. I have installed ODTwithODAC112012 on the windows machine where the report server is installed. Using report Builder 3.0, on the report server itself, I can select the oracle d...
Reporting Services: Strange Behaviour with hidden rows
When building a report in Business Intelligence Studio 2008, I've noticed that the hide/show details indicators default to a plus sign [+] if the row(s) are set to display when the report is initially run. Then, clicking the control causes it to change to a minus sign [-] when the rows are hidden. This is backwards from what I would expe...
SQL Server Reporting Service - Service Manager Error - User Does not have required permission.
I have Fresh Install SSRS 2008 R2 on Win2k8 box ( on which i am administrator). After install, When i run Reports Manager, It gives following error - User 'WIN2008\Tellink' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. ...
Reporting Services - deployment and global/shared configuration between reports
Is it possible to add global variables that are shared among reports in SQL Server Reporting Services? I know it's possible to add variables for a report but I want the same variables to be used from many different reports. Also, is it possible to have different configurations for different servers so that when reports are deployed they...
SSRS URL Paramter Value does not match with report parameter Values
Hi, We have rdl report and passing a multiple paramter values through URL. When the passed values exists in report parameter values then report displayes properly. But when we pass the values through URL which doesn't exists in report parameter value then it throws an error saying parameter value is missing. The reports db and the a...
Convert day number to date of this year in Reporting Services
Hello In my dataset, values are returned grouped by a daynumber (sql: datepart(day, xx)). In SSRS (2005), I want to convert this integer back to a date value. Eg 1 becomes 1/01/2010, 32 becomes 1/02/2010. I've already looked into the date/time functions of SSRS but don't seem to find any function that does the trick. Can anyone help me...
Invert header rows of nested column groups in matrix control
In a matrix control, I group columns by 'Size', and then by 'Color'. The resulting table looks like this: I need to invert the header rows, so the table looks like this: The values from the child group should display above the corresponding value from the parent group. ...
ASP.NET session expired error when viewing a report
Hi, I am getting "ASP.NET session has expired" error when viewing a (SQL server reporting services) report using report viewer control. sometimes it works fine and sometimes I get this error, it works fine in Dev, but not in test environment. Please let me know if you have any clues. thanks in advance. here is the code for the report vie...
Hiding multiple columns based on a multivalued parameter
Hi I've been stumped by this for a while. I need to build a report in SSRS 2005 where a user can select the columns he wants to see from a parameter. So basically the other columns need to be hidden. I can get this to work on 2 coulumns only as the minute I add more and make the Parameter a multivalue parameter nothing works. ...
How to render a report using the ReportService2010 namespace
I'm working on a project where we will be interacting with the ReportService2010 reporting web service under SQL Server 2008 R2. In the past, I've worked with the ReportService2005.asmx, and my problem here is, I can't find any reasonable examples on how to render a report with this new (2010) reporting web service. When using the 2005...
"An item with the same key has already been added" Error on SSRS When Trying to Set Dataset
When i try to set the Dataset in SSRS IDE, i get the error you see in the snapshot. The query works totally fine in SQL Server Management Studio, i wonder where did i go wrong?! The connection to DB is well established. OPTIONAL: In case you want to have a look at my query (its too long), i checked it very well. Nothing wrong in ...
Oracle Database with SSRS reports
Using SSRS with Oracle DB is not orthodox, but still i am forced to use it. So, while i am working on my reports, if another collegue of mine tries to do a query on the same database, an error occurs, on the TNS Listener. When i check the number of sessions active or inactive, they are in the limit secified. After i close and reopen the ...
Unable to create new Team project over the internet getting SQl Reporting service resolve error
Hi I have installed a Team Foundation Server 2010, and it works perfectly over my Lan, but I need it to work over the internet too. My problem is that when Im connected to my team server over the internet, I get the following error, when I try to create a new Team project. TF218027: The following reporting folder could not be created o...
How to get the value of multivalued parameter in textbox in SSRS
when the multivalued parameter is selcted how to get the valu in textbox? eg my dropdown box is having select all, success,failure i want to display the above values in textbox..so i have selected the value for text box as Parameters!value.Value(0) it works if we select only succes or only failure in the drop down box but when we sel...
Object Data Source with Reporting Services in Visual Studio
I'm working on a site where we want to include a pie chart on a page. Right now I'm working on implementing that through Reporting Services (RDLC file) with an object data source. The SelectMethod of my object data source is a method that returns a list of business objects; lets say a List<Alpha> and Alpha has a sub object Beta with a N...
Hidden dynamic matrix groups still take space in SSRS
The Problem I am using dynamic matrix groups as in Dynamic Grouping from Chris Hays's Reporting Services Sleazy Hacks Weblog (which has some great stuff and is worth checking out, by the way). I have my row and column groups bound to two multi-value parameters and everything is working great, except for one thing. Even though I am suppr...
The tablix 'Tablix1' is invalid. The value for the DataSetName Property is missing - Help
For some weird reason i can not run my report, when i try to preview i get this error: (PLEASE RIGHT CLICK THE IMAGE AND CHOOSE VIEW IMAGE TO SEE IT LARGE) Here is how my tablix property looks like: Any idea what to do? The current .rdl was copied from another one. I changed the newly copied .rdl values to match my needs. I always...
How to sum duplicated values in a Group(SSRS 2005)
How to sum duplicated values in a Group*(SSRS 2005).* eg. My query returns values like the following: CusID Discount Amount 1 20 1000 1 20 2000 1 5 700 2 15 1500 2 15 3000 But,when I sum Discount amount in Group Footer, I cannot get the total values like below. I get 45 fo...
Default properties for controls in BIDS 2005 (Report Designer) - Custom Controls
I'm new to BIDS. In Business Intelligence Developer Studio 2005 in the Report designer, the default toolbox has Report Items displayed. My end goal is simply to default the properties of the controls in that toolbox. For example, the Textbox control should be defaulted to a specific font and background color. How can I accomplish thi...