Hi all. I just started using report services in VS and I wanted to know any recommended books on Microsoft Reports. I know of Crystal Reports but I'd like to concentrate on Microsoft Reports now. Any help will be appreciated. Thanks. ...
Hi Say I've published a simple report model with only one table: SalesOrders (OrderId, Date, Type (A or B), TotalAmount) Can a end user using Report Builder create the following graphs: A graph showing weeknumbers in the x axis, and number of orders in the y axis as two series (A and B)? A graph showing weeknumbers in the x axis and...
I have a set of reports using SSRS on a dedicated Reports server. Our reports are launched via hyper links on an aspx page. The hyper links open a report (in a new broswer) with selectable paramaters. There is no data when the reports initially load. However, the first time loading a report in the browser takes a significant amount o...
Very frequently I see error reporting GUIs in commercial software. This includes the whole gamut of commercial software: games, enterprise apps, office apps, etc. For some of my company's software I would like to provide exception reporting GUIs if (and ultimately when) my application fails unexpectedly. Building the GUI is not hard. It...
I have a report that runs a stored procedure that takes about an hour to run. After about 30 minutes I get this error message on the report body: An error has occurred during report processing. Query execution failed for data set 'DEV'. A severe error occurred on the current command. The results, if any, should be discarded. Operation ...
Hi, getting confused here. I'm trying to install a second instance of reporting service sql server 2008 r2. Now does it mean I need to install a second instance of sql server or can i use the existing sql server instance to create anothe reportserver database? ...
How can I loop through the rows of a dataset in the custom code? I have a report containing a dataset. I pass the dataset as a parameter to the custom code function. But what then? Where is a reference about the available members etc.? Here is my dummy sample code so far: Public Function ShowParameterValues(ByVal ds as DataSet) as objec...
Hi I have created a Report Server models and 50+ Reports working off the Model. Now that I have pointed the model to a Live database, I have noticed it limits the results. I can't seem to see data before 2009! Has anyone had this issue and is there a way to get my model to show the data I want? I have done an Explore Data on my table...
We are tasked with creating a reporting frameworks that does the following. Clients can create list reports from the web. Schedule reports to run at a given time. Developers should be able to use a full report layout tool to design reports without code Reports respect data filters. Can I get these options with any packages that or out ...
Can you do this? The list filter I want to use looks like this: Expression Operator Value =Code.GetOccCat(Fields!accountnumber.Value) = =1 No dice. Basically, it acts like that function returns null as far as the filter is concerned, but when I take the filter off and put the exact...
In my work we need to generate contract documents that dynamically extract information from the database to personalize client related information. These documents not only have text, but also they need tables with dynamic rows (ie.: shows some products owned by the client). These tables can be placed in different parts of the document ...
Hoping someone here can help. Trying to install SQL Server Reporting Services to use for TFS 2010 and i'm having issues. I'm going directly from the TFS Install Guide. At first i had issues getting report services working so i decided just to completely uninstall SQL Server and reinstall. When i try to connect to: http://MyServer:80/Rep...
I have a very basic question with the Microsoft CRM 4.0 Report wizard. I am very experienced in SQL syntax and database queries, but I have no knowledge of MS CRM and SSRS. I was helping someone create a SSRS report via the CRM wizard tool, and I'm trying to understand what the "Primary record type", and the "Related record type" is. ...
Hi. I'm trying to figure out how I can dynamically hide/unhide parameters for a Reporting Services report I've created via a URL query string. I've tried reading a whole bunch of stuff I found through a Google search and I've also tried reading various MSDN documents regarding SQL Server, but I have yet to find a way how I can pull this ...
How i can get list of parameters from report using ReportingService2005 API? ...
Hello all, I am going to upgrade and move current ssrs 2005 to another ssrs 2008 enterprise edition server. I'd like to ask for a clean way to do please. Upgrade first and move? OR Move first and upgrade? OR Any tips will my. Thanks. ...
I have SQL 2008 (not R2). I would like to have a matrix report where user can select one of the SQL resultset columns to be the matrix column group.. For example A B Value a1 b1 10 a2 b2 20 a3 b2 30 So the possible matrices could be (user selects from dropdown with A, B). By A a1 a2 a3 Value 10 20 30 By B ...
I need help in creating a BIRT report; the situation is that I have multiple queries but the report all columns should be grouped by One column for example (Operator) Like : Operator | Expr1 | Expr2 | Expr3 | Expr4 | op1 | ## | ## | ## | ## | op2 | ## | ## | ## | ## | op3 | ## | ## | ## ...
I have a RDLC report and I am displaying it on the Report Viewer Control in my front end application. I get the report perfectly and theres no problem in it. But the problem arises when I try to export the report to a PDF (using available option - basically the inbuilt option). I get the report in 3 pages whereas my client wants it to ...
I need to implement custom security for SQL Server Reporting Services. To do this, I would like to add some configuration into the web.config of the SSRS' Reports Server web application. My question is - is it safe to do this? Might my custom configuration be overrun by some SSRS process? Or by an automatic update to the SSRS? ...