I am using VS 2008 and trying to create a dataset for ms sql reporting services. I have two tables that I want to relate. One has a column with type of int, the other shortint. VS give me an error of "Parent and Child columns don't have type-matching columns." Is there any way to over ride this? In old sql reporting services I could...
Is there a way to make items right aligned, say with the page or with some other item in a report, using reporting services 2008 ? Right now, I'm sort of emulating this behaviour by shifting items to the right manually so that they look right aligned, however, when there's an item with a dynamic width (e.g. a tablix with data ir the hori...
Using Microsoft Reporting Services, with local processing mode. Loading data sources and everything works nicely. What I would like, is to, in the the report definition, check if a certain value exist in on of the data sources. Is this possible? Like, if I have a data source with just one column of "Name". Can I somehow check if the nam...
I have a report that runs a stored proc: EXEC ra_spProjectCalendar @Month, @Year, @ProjectID ProjectID is A multi-select dropdown. When a single project is selected, it works fine. If I select multiple projects, I get the error: "Must declare scalar variable "@ProjectID" It works fine when I run it from the Data tab, however, when ...
Hello All, i am using the reportviewer control in a winforms application, with local processing. I want to handle the ReportError event, and if that happens, display a message to user and exit out so i don't have to show subsequent error messages that occur during rendering. problem is, that even if i do this.close (Close on form that ...
I would like to have a chart in SQL Server Reporting Services 2008 show the top X values and sum/group the rest as other. Is this possible without doing the grouping in T-SQL? Example: A query brings back the total sales from 50 US states. I want to show the five states that have the most sales and group the rest as "All Other States" ...
We have a lot of reports on the Intranet that take parameters. All reports are going to be re-built in SSRS. Our goal is to pass all the parameters to the report from the .net application. What would be the easiest and the fastes way to render reports from .NET application? ...
Hi, I have a report and when i tried to create a subscription for email delivery to my address, I have received a status messgae as "Failure sending mail:An error has occured during report processing". What can be the possible reasons of this message. The report works fine normally, is since it failed due to some reason the error messag...
We have a setup where we have multiple instances of an application - one instance for each customer. We call a lot of our reports via URL, passing in parameters on the querystring. Early on, when we were on 2005, we identified a problem with this: I could change my querystring a bit and get into someone else's data. We got around the...
I am writing a report to show gas usage (in gallons) used by each department. The request is to view each month and the gallons used by each department. A column is required to display what each departments target goal is, based on the gallons of gas they have used in a past time frame. Each departments target goal is x percent less than...
I'm working on a web application that renders a reporting services report as a PDF and one of my requirements is to allow for multiple locations to be included on the same report. To handle this, I have created a multi-value report parameter which seems to do the trick when using the RS UI, etc. But, I am using the webservice for repor...
I am trying to understand the pricing requirements for a client to deploy reporting services reports to the web. Do they have to buy any sort of special Report Server license in order to deploy reports, or is that included in the standard versions of SQL 2005? ...
I have created an ASP.NET 2.0 web application and would like to use SSRS 2005 for reporting purposes. The web application uses forms authentication and custom roles for authorization. I have created reports and deployed it to a our SQL Server 2005 box. I have two options to integrate the reports into my application: 1) Link to SSRS fr...
I'd like to create a simple report that shows files that currently have pending changes (checked out) from a TFS 2008 server. I know that I can "Find in Source Control" option from the Team Explorer, but I rather have a reporting services report if that's possible. Ideally, I'd be able to show when the file was checked out and the user t...
I've set up a solution that creates rapid fire PDF reports. Currently it seems I can't get Reporting Services to use all the resources it has available to it. The system doesn't appear to be IO bound, CPU bound, or memory bound. Any suggestions on trying to figure out why it's running so? The application isn't network IO bound, and it i...
I have created an rdl doc that points at a proc that returns 90 000 rows and I am getting an out of memory exception. Is there a limit to how many rows the report projects can handle? Currently I have changed the proc that drives my report to just do a select Top 90 000. My specs are to be able to create a report with 120 000 rows. M...
Hi, Could you please tell me if there is a way to pass the parameter of boolean type from reporting services to PL/SQL. I tried using data type boolean in PL/SQL that is not allowing me to create the dataset. my report is having a radio button , asking for the sort order asc or desc. i was thinking of sorting it from the procedure sid...
Hi, I have a subreport contains 4 subreports in a list. My subreports are getting overlapped. if the top report is nothing to return the bottom one goes up. How do I fix this. Please get me an idea. Thanks in advance, briji ...
I have some "kiosks" that run under machine specific AD accounts that I would like to deploy reports on. For security reasons I need to verify individual user credentials before allowing access to the reports. Is there a way to do this with reporting services?We are running Reporting Services 2005, but will be upgrading fairly soon. ...
Hi, I have 3 subreports in my SSRS report. If the first subreport is not having result the place is blank in html rendering and excel rendering , where as when exporting to pdf , the second subreport(the bottom one) took the place of the first one(top one)and the data is overlapped. How do I avoid this overlapping in PDF version. Yo...