I am fairly new to SQL Server Reporting. I am using SQL server 2008, running on a server using server 2008 standard and Business Studio to create the reports. I have built my report which can be accessed via a button on my secure (ssl) website and it all works great. However, I have yet to find a way to eliminate the need for the cred...
i have sql server 2008 on windows 7. am trying to design a very simple local report to display just about 10 records in a database table in a report-viewer control on a windows forms application startup form. when i run the application the report shows up, i can see the report header text but it does not show any rows(and there are rows ...
I have a brain-teaser for all you SQL Server 2008 Reporting gurus out there :-) I have a report which displays a bunch of data, including the UserID and OrgUnitID for users. It's a server report which I'm rendering on the server, from within an ASP.NET application. My requirement is that a "normal" user can only see his own data rows...
I'm using SSRS 2008 to make something for label printing. I want to make use of all horizontal and vertical space on the page to fit as many labels as possible, so I'm thinking I probably want multiple Report Columns. This technet article would have you believe that you can set the number of Report Columns to make what they call "newsl...
I have a dataset that is showing the correct data, but putting it into a stacked bar chart and using the RunningValue function to try and plot it cumulatively is giving numbers that start way higher than they should. My data is aggregated at the database, giving a dataset of: Date of data Count Sum of Value Filter Item 1 Time Since Da...
Hello, I'm having trouble displaying Hebrew strings in SSRS. The problem is that whenever a string has both characters AND numbers (for example, an address), the spaces around the numbers either dissapear or change positions to the opposite part of the number. This seems to be a display/configuration issue. The SQL query is returning ...
I have some server-based reports (*.rdl) which returns data from a SQL Server 2008 view. The user would like to be able to dynamically add filtering, e.g. show me only data with Language = English, or show me only data for a given organizational unit or stuff like that. The number of filter criteria is reasonably small (four or five...
SQl 2008 Reporting Services (SP1, CU4) installed on Windows 2008 R2. Service account is configured to use Network Service. Port 80 is open in the Firewall. Continue to get "HTTP Error 503. The service is unavailable." error no matter what i try. Need advice on what else I can check or where I can look for any errors with more detail besi...
Hello there, as reporting services are not very agile with page header/footers (like word is with sections) I am doing some hiding/showing of items which are all stacked in the page header. Currently I do a simple expression for visibility IIF(Globals!Pagenumber = 2, True, False) As I have growing tables beginning on page two I do no...
i work in Project already built on SQL SERVER 2005 and Reporting Service 2005, and i'am planing to upgrade my development environment to (SQL SERVER & RS) 2008,, but we have a lot of customer have to SQL Server 2005 and RS 2005. and when we test deploying Reports that have been upgraded to 2008 it's failed. is there anyway to solve this ...
Disclaimer: I know very little about Microsoft Reporting Services and Analysis Services. So go easy on me! ;) We have an ASP.NET MVC website, it allows the user to choose their language by clicking a link at the top of every page. This link essentially sets a cookie that indicates the user's language choice. The ASP.NET MVC code look...
I created a data model in BIDS for SSRS 2008 SP1. When I try to deploy, I get the following error: Exception of type 'Microsoft.ReportingServices.RsProxy.AccessDeniedException' was thrown. When I Googled the issue, all I can find is information such as this: Open “Report Manager” using http:///reports; Click “Site Settings”...
I have a report that via a text box property action triggers a drill-through report (and gives it two parameters (start date, end date)). That all works fine in the report designer, however after deploying the report on the server the pane in the drill-through reports is hidden. Is there a way I can change this behavior. Our users want t...
I have some SSRS 2008 reports that need to be localized. That is: Report titles, column headers, etc. all need to be in the user's locale. (Note that in my situation, the User!Language expression may or may not be useful, but that's not the major problem.) The localized strings must be retrievable from a table within the same DB as the...
Can you disable the SSRS 2008 manager (http://mydomain/reports), while leaving the report server working (http://mydomain/reportserver)? EDIT: Got it! This is how you do it in SSRS: Turn off Report Manager ...
I suspect the answer is no, but here goes.. I'm using the WebForms Report Viewer on a public-facing website to allow users to report on themselves or their users (if the user is an admin user). A report has a parameter called Users where an admin can pick a user from the list and generate a report from it. Mundane users can also view t...
Dear friends, I have no problems to render any report in SQL Server 2008 Report Server in my asp.net (Not Sharepoint) applications. There are so much reference on how to do that whether through report viewer or through custom renderer on http response object. I failed to find any article or book that could really goes deep into SSRS2008...
What are the advantages and disadvanges of using the Set NOCount on TSQL for Reporting Services. ...
I have a report that needs to be able to render a very large amount of pages (about 4500 in this instance) in a web browser. The total time needed to finish on the report server from start time to end time is about 30 mins for the instance that I am looking at. Does anyone know what options exist for handling the rendering of such a la...
I am trying to create horizontal bar chart to look like a pill chart. I would like to take a either a stacked bar chart or a 100% stacked bar chart and put rounded ends onto this chart. I would only be using 1 row within the chart. One idea I had was just putting rounded images on either end of the chart to accomplish this but I'm n...