I'm currently working on a reporting tool for a company that conducts the same survey at different clients. So the analysis and report would be the same, except for the conclusions. The ultimate goal of the project would be a tool that automatically extracts, analyses the data and creates the report. SQL Server and Visual Studio are mand...
Hello all: I work for a ISV. Our product can use both SQL Server and Oracle as its back-end server. It includes a number of reports (currently in Crystal). We are investigating moving to Micrsoft Reporting Services, but I'm beginning to think that it's a bad idea. We want for our reports to look and feel as though they are a part of ...
I need a way to dynamically change a reports file name based on a parameter it is given. ...
This may not be a direct programming question but I am in desperate need of this and if you people feel that the question is irrelevant , please do close it but after the answer. Like if we visit www.asp.net we will get the videos(free and down loadable) for asp.net, ajax etc.). Likewise, which is the site from where I can get the free...
Hi, is report builder connected to database directly from client pc or it is thru the reporting service server(data source)? Thanks ...
Hello, I've visual studio 2005 installed in one machine (dev machine) and SQL Server 2005 installed in another machine. But only when we install SQL Server with SSRS, we get the Business Intelligence Project templates in Visual Studio. Now having SQL Server in another machine how can i create a report server project in VS 2005 in the ...
Hi every boddy, It ´s a real pleassure to be part of this great community. My questions it's that.. How can a I set a Report Footer (Information that just appear on the last page of the report ) in reportViewer?. cause when I set Page footer it appear on every single page of my report, but I need the information only once, on the last ...
I'm trying set up an execution account following the steps here: http://msdn.microsoft.com/en-us/library/ms156302.aspx I follow these steps: Start the Reporting Services Configuration tool and connect to the report server instance you want to configure. On the Execution Account page, select Specify an execution account. Type the ac...
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 ...
How can I make identical output from a transformation go to two separate places e.g., an OLE DB destination and a DataReader destination? Background: I have an existing package that reads data from a text file, does some transformations, and loads the data into a SQL Server table. Now I'm trying to make the package be callable from ...
I have a custom data source which pulls out data form a flat file. The flat file contains a timestamp , source and data. I can use sp_execute to execute a select query against the flat file. I'm currently using 2 stored procedures . - one which runs a select * from flat_file into a temp table - the other which does a select min/max...
I am trying to create a Pareto Chart in SQL Server Reporting Service 2005. I created a chart, but having difficulties in trying to get my cumulative(line) to display. I listed my values below. =SUM(Fields!Total_SR.Value)/MAX(Fields!Total_SR.Value, "SeriesGroup")*0.75 cumulative value: =RunningValue(Fields!Total_SR, Sum, "SeriesGroup...
Hello, I can connect to sql server reporting services both in the browser and through studio manager, but with problems. In the browser, there's no "site sections" at the top or anything in the tab area (content, etc). In Studio Manager, when I expand the "Home" node, I get the error "Failed to retrieve data for this report.....The pe...
When we work on an SSRS report on our local laptops, we have a data source we use. However, when we put the report on our SSRS server, we'd like to be able to specify a different data source. So, when we upload our report to the SSRS server, we specify a different data source. But, when we run the report, it gives us an error saying it...
Hi, I want to backup reporting services encryption key daily using SQl server agent job. I will be using the following syntax rskeymgmt -e -i <> -f <> -p<password> but when run on cmd it prompts me "are you sure you want to extract encryption key from report server". Only after typing "y" and pressing enter it lets me finish the task...
I have a solution file in BI that contains 10 report projects. I publish these projects manually with every change. I want to know that is there a solution to deploy these projects on report server programmatically? ...
I want to print a report (RDL) directly without previewing it. Is there a solution for this work? ...
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...
A project I own was just moved from an older server to a new one, and in the process of moving the web folder, re-deploying the SSRS reports, restoring the database, configuring IIS, etc... I have lost the ability to view the Microsoft Chart Controls that are embedded in the SSRS reports, that are then displayed by a Microsoft.ReportView...
Morning, We are using SSRS (2005) and have a ASP.NET frontend using the SSRS WebControl. I've boiled the problem down the time it takes for one particular report to be generated is greater than the timeout on the proxy server. It looks like the way the SSRS web control tries to do things is by performing an HTTP request for the report...