I'm in the process of deciding whether to use SSRS or CR for our reporting needs. I have read through several discussions, including Crystal Reports vs. Microsoft SQL Server Reporting Services and Compare SQL Server Reporting Services to Crystal Reports. All very good and valid points. The over-all consensus seems to be that SSRS is a...
Some time ago my company was evaluating different reporting solutions. We settled on MS SSRS particularly because it's capable of connecting to various types of data stores, including MS SQL, Oracle and SAP Netweaver BI. It has proven the test of time pretty well, however, we're now under fire from management because SSRS is not capable ...
I have searched a bit upon it but can't get it to work properly. I want the report to display as many decimal characters as the field has, simple as that. Example: Value = 169.99 | Ouput = 169.99 Value = 169.9999 | Output = 169.9999 If I don't set the Format property to anything, it kinda aligns the fields, sometimes it returns 2...
The application I am working on is generating .rdlc files that will end up being interpreted by Microsoft's WinForms ReportViewer control (not the ASP.NET one). I have only been partially successful with adding the interactive 'sort direction' controls on to these reports. The controls appear on each column and row in the report, when y...
I'm trying to enumerate, in c#, the reports for a user on reporting services. How do I do this? Is there a web services call I should use, or should I just get the html returned from http://localhost/ReportServer/lists.asmx and pull that apart? The second option sounds like a bit of a hack. Surely theres a better way? ...
Hi all, I use SSRS to generate an XML file using XSLT. All is fine, except that the XML file starts with the letters 'EF BB BF' which I need to get rid of. How do I generate an XML file without it? ...
I can view my reports on my p.c but on the other users,it only show plain SQL Server Reporting Services Home only. ...
Right now I have a project called reports with several reports. In solution explorer it looks like this: Shared Data Sources -- DEV Reports -- Report1 -- Report2 -- Report3 I want to make it look like this and have the same structure carry over to the report manager website when I click deploy. Shared Data Sources -- DEV Folder...
Is it possible? and how do you do it? Im using vs2008 report designer. Thanks!! MICROSOFT seems to say no...Darn Them... get your stuff together!! ...
I am trying to call BIRT API in linux environment. My source is an XML file and i create html, xml and pdf reports on that source XML. My html and xml reports generates properly, but PDF report is created with size '0' (no contents). However if i run the same program from a windows system, PDF report is created properly. Is BIRT havi...
Does SSRS use JavaScript behind the scenes when Exporting to Adobe PDF files? ...
I have a custom data extension which loads and works correctly for a 2008 (not r2) instance, but when updating the configuration to use the same custom data extension in rs i am getting the follow: ERROR: Exception caught instantiating CDESQL report server extension: System.TypeLoadException: Access is denied: 'Microsoft.ReportingServ...
I have a complex parameter to a web method in my .NET web service, and I want to query that web method with Report Builder 2.0 using SOAP. With soapUI, I get the following SOAP request for that web method: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:qcr="MyNamespace"> <soapenv:Header/> <soape...
I have a report that shows all errors (if there are any) from a process that runs every day. At the end of the process, I want to write some code to execute the report and email it. I am seeing how to email a report from code, but I can't seem to find anywhere that shows how to run the report from code. I am using C# in vs 08, and the re...
I'm using the latest (2010) ReportViewer Web Control in an ASP.NET 4 project. My client wants me to suppress / hide the initial "Loading" message that gets displayed while the report is being fetched. Yeah... I know... why hide information that tells you what's going on? But, the client wants what the client wants. I know that if you u...
Hi people. I'm having some problems with reporting and I thought you could help me: I have created a dataset (mydata.xsd). I also have designed a Report.rdlc, and I did the same with a frame with a ReportViewe inside, wich use mydata.xsd as a source data. I have designed mydata.xsd to have 2 columns (user, time). How would you fill th...
Hi By mistake I deployed wrong version of a RDL file on the ReportServer. This overwrote the existing RDL file (the correct one). Is there any way to retrieve the earlier version of the RDL? Note: No backup of the database is available. Thanks. ...
I am having a problem with SSRS 2008 reports that have fixed column headers. Whenever a report has these fixed column headers and also has rows that get expanded, the row that gets expanded jumps underneath the header. The Row would be moving to the correct place if the header wasn't there but because the header is there the row that get...
Hi can any one help me out for this. I have RDLC Report displayed on my web page using asp.net And C#.net I want to export it to PDF on button click. Please can you help me? Thanks ...
SSRS parameters are a pain. I want to be able to re-use reports for many different needs by allowing the users access to many different parameters and making them optional. So, if I start out with code such as: Select * from mytable myt where myt.date between '1/1/2010' and '12/31/2010' and year(myt.date) = '2010' and myt.partnumber ...