I have a report in SQL Server Reporting Services which should show a text box with a static text for "normal" users a text box with a hyperlink to open up a new details windows for "super" users The user level is determined by a parameter being passed into the report. How can I achieve this? I tried to create a textbox with a text ...
I have a SQL Report driven by a query that sorts it in ascending order of some numerical value. But the user wants two particular rows of data, which happen to appear at different ordinal positions in the query results, to be juxtaposed. Is there a way to do this, either through the report's driving SQL or the .rdl file itself? ...
SSRS 2008 reports are being developed using T-SQL Queries. The requirement is to display the numbers in Indian format. E.g 1234568 should be shown as 12,34,568. SSRS is applying thousand seperator(i.e 1234568 is shown as 1,234,568) only, though number format is set to regional settings for all the report items and the regional settings i...
Hi, I've moved my web application to a new server, when it calls the render method on the reporting services 2008 web service it brings back the error "Client found response content type of '', but expected 'text/xml'. The request failed with an empty response". It works fine on my development machine. Does anyone know what might be ca...
Hi, In my app I have a chart that is stored in Reporting Services, there is a method called 'RenderStream' which is called but it gives the following error: "System.Web.Services.Protocols.SoapException was unhandled by user code Message="System.Web.Services.Protocols.SoapException: The selected report is not ready for viewing. The re...
I have a report that has a header and footer that are both set up to fill the whole A4 length (minus margins of course) because I have some information on the far right and far left of each of them. Now in the body I have a List Element that allows me to have a tablix report and a chart next to each other. The body is also sized propery ...
I'm finishing up my reports in my SQL Server 2008 Reporting Services project, and as one of the last steps, I need to make things translateable. Since I have a bunch of reports, and they all share some identical labels, I decided to put all those labels I need to show into a SQL Server table, and I am surfacing that contents as a DataSe...
I am using SQL Server 2008 Reporting Services and set mode remotely. All is going fine and reports running on my machine. I am not using report viewer control, but switch to browser. Problem is that when I access the report from any other system in browser by providing required url. I m getting the following premission error: Serve...
I have set up SSRS on my localhost, and used BIDS to create a couple of reports on them. They access data from the same SQL Server where the SSRS is deployed, and when I preview them they run fine. Then I deployed them to my localhost SSRS and accessed them via the ReportManager web interface, again they ran just fine. Finally I deplo...
I have a tablix which grows horizontally (it is actually acting as a legend. I would like to right align it with the edge of a chart. I cannot find a way to do this. The RTL property will reverse the order of my values but it still grows to the right. ...
I'm currently building a matrix style report. After each rowgroup, i would like to add in a nice 2pt solid black border. Unfortunately not all fields in the matrix will have data in them, and therefore i don't seem to be able to use conditional formatting on the cell level. I've tried using IIF(RowNumber("group") = 1, "Black", "Light ...
I'm pretty new to Reporting Services though I have a lot of experience with Crystal Reports and databases (and MS Access reports if that counts ;-). Anyway, I created simple reporting project in VS2008 using wizard, with simple stored procedure that has 2 options parameters - and since they're optional I do not assign their values. There...
Original Question with Query attached as requested, thank you Hello, I have a table that retrieves data over a 3 day period on an hourly basis, there are several different machines that work on a specific bottle for a period of time, during the three day period there could be several different bottles go on that machine. I want to show...
I'm using SSRS 2008 and I have a financial report. I would like the dollar amounts in my table to be in currency or number format when exported to Excel. Currently they end up being text. I have trying a few things to see if its even possible. I removed the table header, didn't use the $ sign, and converted the field to decimal, but no...
I have a situation where I need my report server to be more-or-less publicly accessible, as we are using the ReportViewer control in an ASP.NET web application and groups of users will be accessing a variety of reports. This will be running against SQL Server 2008 Standard Edition. Security will be handled by creating linked reports (o...
I need local RDL report to be exported to HTML, preferably HTML fragment. In 2005 it wasn't officially supported but there was a trick. In SSRS2008 they seem to drop this support (there's no HTML extension in the supported extensions when enumerating using reflection) and use RPL instead which is a binary format that I doubt someone will...
We have report with cover page (disclaimer) normally printed on separate page and on the other pages main data. Works well when printing, but when exporting the same report to Excel cover page and data are presented on same sheet. I need a way to force the cover page to be on separate Excel's sheet. I tried everything: page brakes, put ...
I have reporting services setup on my machine. I can access http://localhost:8080/Reports_SQL2008 and the reports manager works fine. When I try accessing the web service URL (http://localhost:8080/ReportServer_SQL2008) all I get is a directory listing that looks something like: -------------------------------------------------------...
Hello, I have the following data: ID parentID Text Price 1 Root 2 1 Flowers 3 1 Electro 4 2 Rose 10 5 2 Violet 5 6 4 Red Rose 12 7 3 Television 100 8 3 Radio 70 9 8 Webradio ...
Hi, I have a SSRS challenge. Hope someone out there can help me out. I have an analysis services data set where is use a date filter as a parameters. When I deploy my report all the dates from my date dimension are displayed as selectable values in the filter drop down. It would be nice if the users could only select the filter values w...