Hi!! I have configured Reporting Services on one Server and have the ReportServerDb & ReportServerTempDb on other server (Future requirement of scale out deployment). I am connecting to these servers using a domain account. I have configured Reporting Services using ReportingServiceConfiguration Wizard and it seems to have worked fine ex...
We installed SP1 on our Team Foundation Server 2008 server. Everything seems fine after the install, except there is a red X on the Reports folder in the Team Explorer in Visual Studio. If we attempt to access the Reporting Services web site, we get a message that says that the "report server is unavailable". There were no errors during ...
Hi, i am using oracleclient peovider. i was wondering how do i use a parameter in the query. select * from table A where A.a in ( parameter). parameter should be a multivalues parameter. how do i create a data set. Thanks. Susan ...
In SQL Server Reporting Services (SSRS), the number of columns on a page for a report is set in the Report Properties (this is not the same as the number of field columns which vary with the data). By default this is set one, but it could be two or more, flowing down then across. I want to be able to set this dynamically, depending on...
How can I set drill down in an SSRS chart? ...
I have a new SQL 2005 reporting services installation and it doesn't work. Database access works fine. I've setup a new IIS site, set it to run on port 90. It has the two virtual folders - Reports and ReportServer. I can access ReportServer just fine, but Reports (the report manager) throws HTTP 400 error. I've changed the URL in rsre...
I am trying to find the value of a cell 1 column over and 2 rows up using something like excels offset ...
I have a report page on reporting service. In Layout tab i have to something that count the rows. I used rowcount(nothing) function to do that but it is insufficent for me. I have to call some function to count rows. How can i write a function and where can i call it from? ...
Hi, I have yet another problem with Reporting services. Finally I was able to set the ball rolling, achieving success in configuring reporting services with a domain user account. Now I have a problem accessing the server from another machine (in the same domain) using Integrated Windows Authentication in IIS 6.0. I have never had probl...
I have a report which has a list that is used to group data by a particlar field (City). In the list control is a table which has a footer row. In the footer row, the data in the table are summed together using SUM(Field!SalesAmnt.Value). The problem I have is that the calculated sum values for each group/city are the values for ALL gr...
We have Reporting Services running, and twice in the past 6 months it has been down for 1-3 days, and suddenly it will start working again. The errors range from not being able to view the tree root in a browser, down to being able to insert parameters on a report, but crashing before the report can generate. Looking at the logs, there ...
hi, How do i pass a boolean type parameter from SSRS to boolean type in PL/SQL stored procedure. Any idea, i wanted to have the report parameter as radio button in my report design. Please help me to get an idea, if there is a way. thanks, San ...
I am looking at the report viewer WinForms control in SSRS 2005 and want to know if you can have actions do something other than call a URL or show another report. My boss likes the report viewer control but wants to know if you can set it up so that if you click on a cell it could open up another form. I think the "Action" property ...
In some of our SQL Server Reporting Services reports we wrote for SQL 2005, we used the Me.Value in the hidden expression to determine if the cell should be shown. This worked fine with SSRS 2005 (even though it probably shouldn't have). However, it no longer works with SSRS 2008. Is there an alternative (other than using the actual fie...
Hello, I'm new to reporting svcs and I'm writing a report based on a report model (.smdl) created in VS.NET 2008. I seem to be missing out on the report builder query view's analog to a "left join." Model is very simple: Three entities: Cust (custid, custname) Ord (ordid, custid, orddate, ...) Charge (chargeid, ordid, chargetype, cha...
I have 2 reports, first one is an Authorization Form and the second one prints RMA Tags, all that is needed to run these reports is an RMA # A third report is used so that I can have 2 sub reports (one for the Auth Form and one for the Tags) on it so that they can run 1 report and get all of the data that they need in 1 spot. This repor...
Is it possible to make a group and sort conditional? If so, is it possible to somehow do this based on the value of a textbox item? I thought I could just set the Expression of the group and sort to something like =IIF(ReportItems!TheTextBox.Value = 0, 0, Fields!FieldName.Value), which would be perfect, but it doesn't allow me to use Re...
Is it possible to use SSRS for reports in an ASP.NET 1.1 application? Is there a report viewer control for ASP.NET 1.1? If not is there any workaround for this? ...
How would I embed a ASP.NET server control on a SQL Server 2005 Reporting file (.rdl)? I am using the design view to accomplish my task? ...
I am stuck with a problem of implementing security at dimension level in SSAS. Here is what I did - 1. Defined a role in SSAS and applied security at dimension level (Unchecking cube dimensions that I don't want this role to access and setting Allowed & denied Sets). 2. Tested using Cube Browser, it worked fine. 3. Tested using SSRS, no...