I'm trying to display a boolean field in Report Designer in Visual Studio 2008. When I tried to run it, an error occurred: "An error has occurred during report processing. String was not recognized as a valid Boolean." I tried to convert it using CBool() but it didn't work. ...
When I try to install the Reporting Services on a second node of a failover cluster, I get the following error message: Existing clustered or cluster-prepared instance failed. The instance selected for installation is already installed and clustered on node 2. But, we never installed it before. Does anyone have any ideas? This is ...
I am working on an application that loads a generic list of objects into an RDLC report, which is then rendered on the client machine using the webforms report viewer control. It renders fine and exports fine, but if I try to print it, it spools maybe 500k to the printer and then stops responding. ...
Based on several report parameters in SQL Server 2005 reporting services, I would like to automatically generate one or several chart(s) for each row in the return result and paginate or space them out. How do I go about that? ...
The default chart object in the SQL Server (2005) Business Intelligence Development Studio doesn't seem to some have formatting options like : specifying the text direction of labels in the x and y axis adding a trendline to a bar chart arbitrarily resizing items in a chart - for example, if I resize the chart object, everything gets r...
Hello, After diving into the www, I don't have a clue about the support of vectorial grahics/image by reporting services. It seems to be impossible. We are using Reporting Services with a PDF rendering and we are forced to use raw bitmap into reports. That leads to huge sized reports. We know that dealing with vectorial graphics will he...
I've been following this tutorial (lesson 6) in order to build and deploy a sample report with an embedded subreport which reads its parameters' values from the parent report. This subreport is embedded in one of the group rows of the report's table, and both share the same datasource. Additionally, detail rows appear collapsed until the...
I was wondering if it is possible to not attach Excel sheet if it is empty, and maybe write a different comment in the email if empty. When I go to report delivery options, there's no such configuration. Edit: I'm running SQL Server Reporting Services 2005. Some possible workarounds as mentioned below: MSDN: Reporting Services Extens...
I'm trying to use VS's attach to process tool to debug add-ins I'm developing for Sql Server Reporting Services. I am able to correctly debug it with attach to process when I copy dll's and pdb's in my project debug/bin dir to the ReportServer/bin dir. But, if I use my msbuild script and copy those dlls and pdbs to the ReportServer/bin...
While generating charts using RS 2008 betas, RC0 and such., I never specified any fonts for axis labels, legends etc. They were all rendered with the Arial font by default, which looked awesome. But as soon as we switched to RS 2008 final, the fonts got all messed up - they are rendered in some kind of bold console font. My initial tho...
How does one dynamically load a new report from an embedded resource? I have created a reporting project that contains a report as an embedded resource. I added a second report file and use the following code to switch reports: this.reportViewer1.LocalReport.ReportEmbeddedResource = "ReportsApplication2.Report2.rdlc"; this.reportViewer1...
I need to get the Folder size and display the info on a report (SSRS). I need to do this for a number of Databases (loop!). These DB's are websites' backends. Has anyone done this before? Can you please point me to some samples or right direction? Does xp_filesize and the like the right solution? Help! ...
Which of Crystal Reports and SSRS (SQL Server Reporting Services) is better to use? ...
We use SQL Server Reporting Services for our web reports. At the moment, our clients are all in the UK, so for each report, we set the Language property for the report to "English (United Kingdom)". But now we have US and French clients. So, we'll need to change the language and currency for the French, and the date format and currency ...
Is there an easy way to generate a PDF report from an RDL that's been uploaded to Report Manager and put that file somewhere on the server's disk? I already have a location on disk to put the file, I just need to know how to programmatically generate the PDF. This is for SQL Server 2005 Reporting Services. Code in either VB or C# is fine...
Here's my situation. I have a button on my ASP.NET webform. This button creates a new browser window pointing to a page which has a lot of hidden fields (which are dynamically generated). This form submits itself to SQL Reporting Services on the bodies onload event. This works fine and the report is displayed in this new window. Howeve...
The title says it all. How do I go about adding a trendline to a bar chart in reporting services 2005? ...
Is there some way to cache a generated report in the reporting services, so that I could later export it to some other format ? I.e., currently, I'm generating an HTML version of the report (throught the webservice) and if the users asks for an excel file, I generate it again, this time in excel. The problem is, that the data can pote...
I'm trying to determine how to open/edit existing SQL Server Reporting Services (SSRS) 2005 report projects (.rptproj) and reports (.rdl) with Visual Studio 2008, without having to install SQL Business Intelligence Development Studio (BIDS) 2005. ...
I'm considering using reporting services 05 SP2 with share point integration on a new reporting project. In this project's reports users can only see records they own. I was thinking a simple userId parameter on the report would allow me to filter the report's results to only these "owned" records. I'm curious: Can I pass the current...