reporting-services

Microsoft reporting services vs ssrs

Hi folks, is there any difference between ms reporting services & ssrs? Does ssrs succeed ms reporting services? ...

Debugging report error on SSRS

Hi Folks, we have a bunch of reports (RDL) on SSRS built using officewriter. Sometimes errors occur in a report after updating the excel template. While the report renders fine, an error occurs on the server when trying to save the report using 'export to excel format for office writer' option. How do we debug to find the cause of the er...

sql reporting nested table/data

This is the scenario. A customer(Customer table) is linked to an account(Account table). And within each account there are multiple items(Items table). I need to show a report like below. What is the best way to achieve this? I have done the customer account table part since that is just a simple report. How do I nest the table wi...

Microsoft. ReportingServices.ProcessingCore not found

Hello, I'm trying to add a third party reporting chart control in to my project. I'm using visual studio 2005 and i've installed SQL Server 2005 along with the Reporting Services. When i try to add the third party dll to the tool box, i get the error message 'Could not load file or assembly 'Microsoft.ReportingServices.ProcessingCore...

SSRS Reports with datetime parameters

I have created one report in SSR with two input parameters . FromDate and ToDate . Both fields i declared as DATETIME and i checked the option to allow NULL for both of these values . So in the reports one NULL CHECKBOX is coming along with this parameters . and when i click on the link , the report is automatically loading for NULL inpu...

SSRS 2008 export to MS Word A4 issue

I have a simple report maid in bids 2008 and deployed to a ssrs2008 server. it has this report properties: page unit : Centimeters page size : Orientasion: Landscape paper sise: A4 width : 29,7cm Height: 21cm all margins ar 2,5cm Showing and printing this report works fine making it perfekt on a A4 paper. expor...

Editing SSRS 2005 Reports in VS 2008

I have an old Report Server Project created in Visual Studio 2005. The reports are deployed to an SSRS 2005 Server. When I open this project in Visual Studio 2008 it converts the project file and then when I try and deploy any of the reports (from Visual Studio 2008) I encounter this error: The report definition is not valid. Details:...

How can java applet be used to mask divx source (with example)?

For example look at ninjavideo's divx player source. It is this: src="http://127.0.0.1:64651/nv/47244" How do they use the java applet to output the src as a divx readable file? Source: http://beta.ninjavideo.net/video/47244 Warning: You will need to allow java applet ...

Slow Loading of Calander Control in Report Viewer in SSRS

I have several SSRS reports that are displayed through the Report Viewer control on a custom website. The page renders quickly but the control bar of the Report viewer does not respond for roughly 5-10 seconds. The page then re-freshes slightly and the Calander controls can be selected. I think it has something to do with Java but canno...

SSRS: Export To Excel?

Whenever i export my SSRS report to excel, the record gets extracted to multiple columns instead of one column which makes harder to do much stuff in excel? I know it has to do with alignment but can anyone tell me specific what i can do to fix this? ...

Hand-picking records from a dataset in Microsoft Reporting Services 2005

I am using a Matrix to aggregate data on a per-category basis and would like to override the default subtotal calculation per sub-category, as well as the Grand Total. To this means, I can dynamically determine the set S of cells to override using combinations of "iif" and "inscope" in the formula. Here comes my difficulty. I would li...

SSRS: Oracle TNS:listener error?

I have a SSRS report which is using Business Object Provider. The dll has a connection with Oracle server. Whenever i run the report i keep on getting this error message: "Oracle.DataAccess.Client.OracleException ORA-12514: TNS:listener does not currently know of service requested in connect descriptor " Anyone knows why? ...

Unable to create data driven subscription for ssrs report

I have a SSRS report which displays daily status report for the team members. The dataset of the report depends on User!UserID as a parameter which is passed to the SQL Query to fetch the data. I want to create a data driven subscription on this report so that every user gets his/her daily status report each morning. But when I click on ...

Reporting Services running on SQL Server 2008 Express

I know I can run Reporting Services on SQL Server Express w/ Advanced Services. The articles I have read do not touch on my question. I'm wondering, in this scenario, can remote users execute reports from the report server remotely using URL access ex:)http://mySQLExpressBox/ReportServer/rptMyReport....... etc - Or will reports only...

Integrating security between ASP.Net and Reporting Services

I have an ASP.Net website with the standard forms auth membership database, and then a Reporting Services instance with a bunch of reports on it. How can I integrate the security between the two servers? Worst case, I could just frame in the reports with some code and pass a universal set of credentials to the Reporting server, but I l...

SQL Server Reporting Services: web references vs assembly references, poor performance

I am using Reporting Services to render a report directly to PDF. It requires that I use two web references: ReportExecution2005.asmx and ReportService2005.asmx. The performance on web references seems really poor. Since my web server (IIS7) and my SQL Server (2008) are on the same box, is there a way I can reference them directly? If no...

SSRS Code export.

I have an Item in the Header in SSRS 2005. It is filled based on code that returns a value based on a report item in the body. When viewing on screen it shows correctly. When printing or exporting, it does not show up. The code takes a string then depending on the value returns a string. ...

what is the work around for User!UserID when creating data driven subscription

I have a report that uses User!UserID. But "Data Driven Subscription" cannot be created on reports using the "User Collection" or having data source with Windows Integrated Security. What is the work around for this? ...

Print SSRS Report Automatically

I am fairly new to using SSRS and I would like to create a report that automatically prints to a specified printer when the report is generated. I found this question on SO and it mentions writing code in the Business Intelligence Development Studio that can "fire off" a print job. How might I do that? EDIT: Forgot the URL of the thr...

SSRS shared data source to SSAS and MDX query

I am trying to deploy reports that connect to an SSAS cube as a shared data source. The problem I'm having centers around that fact that even if I change the Initial Catalog in the SSAS connection string, all the MDX queries in the rdl files still reference the old SSAS cube by name. This is a particular problem because these cube names...