I am creating an RDLC report where the dataset consists of several datatables. There is one parent table and several child tables. What I would like to do is display relevant data from each child table for each row in the parent table. Here is a simplified example: table1 = "Purchase" has columns PurhcaseID, PurchaseNumber, PurchaseDa...
I have a WPF application using MVVM. I have some user controls that show some SSRS reports in a ReportViewer control hosted within a windows forms host control. The User Control has a simple combobox where the user selects a criteria and therefore the report satisfying this criteria will be loaded, its data fetched from the database and...
Hi im in the process of building a system that generates printed letters (around 1000 a day) that get sent to our customers and was wondering what are some good tools to use for this. So far i have looked into using Crystal reports and MS Fox pro reporting but find them frustrating to use. Anyone got any good suggestions? SQL repor...
Hello, I am facing a weired problem in reporting services while displying reports in pdf. I have a page header and column headers for data in each page. But the page header and column headers are not rendering in just the last page of pdf. Does any one faced this problem before ? Your response would be really appreciable. Thanks, Kri...
Hi there, Having a few problems with Timers within a service on Win2k3... Basically, creating a service that every X minutes/seconds, checks for a certain process and whether it is running. I figured the easiest way to get this done was via a Timer, and so I coded all that in, and it seemed to be working OK. Have managed to install the...
I need to use a TimeSpan object as the datasource for a chart in reporting services. Unfortunatley i get the error: Series data points do not support values of type "System.TimeSpan"... Is the some magic trick to work around this limitation? ...
A few months ago Oracle queries stopped working on our reporting services server after a service pack on the reporting server. I ended up having to grant permissions on Oracle directories to eliminate the first error and then renamed the NLS_LANG registry entry (effectively deleting it) to get rid of the second error. The old value was...
I have chart that plots values of Y-axis less than 1 (0.1, 0.24, etc). When the chart is built, Y-axis label just shows 0 at the origin and no other values along the axis. ...
I want to translate an XML file with data like the following: <FlatData> <Details1_Collection> <Details1 Customer1="Customer" Total1="3" /> ... </Details1_Collection> </FlatData> The data I am interested in is the attributes and their values in each Details1. The problem is that these attributes are not necess...
Hi I would like to put the input of a multi-valued string parameter in SSRS into a table, so I can join onto it, instead of using an in (@variable). I know how to do it in a proc, but I want to do it in SSRS itself, as sending it through to a proc limits it to 8000 characters. Thanks ...
Hi All, I am using 4 subreports in one of my report. where one of the subreport in itself is having another subreport call. i have kept the font size of data in all the reports as 10pt. But while running the report it shows the size as 8pt for the subreport which have the inner subreport. Why is it so? Any help would be really app...
Scenario: Production servers are running SQL Server 2008 in the domain myDomain.com Dev/test/stage servers are running SQL Server 2008 in the domain dev-myDomain.com Actual dev work done on local running SQL Server 2008 source controlled using SourceSafe First of all, does this setup/environment make sense? And, what are some good wa...
Hi, I tried creating a report using a subreport. When i exported it to PDF i have noticed that there is extra blank pages in the PDF. I made it clear that body width + left margin+ right margin <=report width. But still it gives the blank page. subreport as individual working grt. Also i am calling the subreport from with in a list in...
I'm relatively new to SSRS 2005. I've built simple reports, and spreadsheets but I'm just beginning to delve into the world of fun that is SSRS/RDL. I'm trying to pass one (custom/non-query) parameter from one report (*.rdl) to another. While logically I would like to add a global variable, there doesn't seem to be any straightforward me...
Hi, I am having a problem with my SQL Server 2005 database. The database must handle 1000 inserts a sec constantly. This is proving to be very difficult when the database must also handle reporting of the data, thus indexing. It seems to slow down after a couple of days only achieving 300 inserts per sec. By 10 days it is almost non func...
When I execute a T-SQL query it executes in 15s on sql 2005. SSRS was working fine until yesterday. I had to crash it after 30min. I made no changes to anything in SSRS. Any ideas? Where do I start looking? ...
i made one report(A) and in it i called three sub reports(b,c,d). Now i call Main Report(A) and i export it to PDF.I have data only in two reports(b,d) but not in third report(c),so now i got some space between report b and report d. I put condition in b report if data present then it displays otherwise not. So now plz tell me solutio, h...
Our system receives status information from fleets of buses. We currently use Reporting Services 2008 to present a list of daily events, such as vehicle breakdowns, speeding, passenger counts, etc. I'd like to add an interactive map to visually indicate the geographic location of each event. Unfortunately, I can't see an easy way to e...
I liked the grid points and the visible separation of the header/body/footer of the report on the design surface or vs2005. I hate the vs2008 report designer which is just a blank canvas with no grid lines/points and separation of header/body/footer... ...
I am trying to evaluate a Price per Kilo ($/Kg) based on sales of a product. This works fine if the product was acutally sold during the period specified. However if the product is not sold the Kg (the denominator) ends up being 0 (zero) and an error results. - Divide by Zero error. I tried this =iif(KgSold=0,0,Revenue/KgSold) It a...