How can I have a Visual Studio Report(.rdlc) with account information and also a chart in the same r

Posted by Paul Mendoza on Stack Overflow See other posts from Stack Overflow or by Paul Mendoza
Published on 2010-03-16T20:36:35Z Indexed on 2010/03/17 9:01 UTC
Read the original article Hit count: 270

Filed under:

rdlc

|

reporting-services

|

reporting

I'm working on a report in Visual Studio 2008 with their Report tooling and I'm not sure how to approach this conceptually.

I have a report I want to generate. At the top of the report will be a bunch of information about a customer of our site (Name, Address, Phone). Then below will be a chart of the purchases that customer has each month.

My problem is that I want the content at the top of the page to use a query that selects from my Users table in my database. But then I need another query that gets all of the purchases grouped by month.

I've thought one way to approach this would be to place a subreport on the parent report that only contained the chart. The parent report would have the details of the account.

Is this the correct approach?

© Stack Overflow or respective owner

Related posts about rdlc

Reporting Services 2010 RDLC: Passing Querystring Parameters from an RDLC

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to build a simple RDLC report that shows some data, and has a 'select' link that sends the browser off to a certain url with some data in the querystring (a key). In the vs2010 report designer, I can double-click on the column, then select action, and there are a bunch of thigns that… >>> More
dynamically setting the size of a textbox in a RDLC report

as seen on Stack Overflow - Search for 'Stack Overflow'
Can a textbox's width in a local RDLC report be set dynamically using C#? I would like to auto size the horizontal width of the text box based on the data it contains. >>> More
Problem sub-total Matrix with rdlc report in vb.NET

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi everyone, I have a matrix and I need to add the money earned this year and past years. However, I must remove the money spent in past years. I must have the separate amount per year and the total of these amounts. This is what gives my matrix: Year = Fields!Year.value =formatnumber((sum(Fields… >>> More
When to use RDLC over RDL reports?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have been studying SSRS 2005 / 2008 in the past weeks and have created some server side reports. For some application, a colleague suggested that I look into RDLC for that particular situation. I am now trying to get my head around the main difference between RDL and RDLC. Searching for this information… >>> More
RDLC - Adding a Data Source in VS2010

as seen on Stack Overflow - Search for 'Stack Overflow'
Greetings. I have an RDLC file and am wanting to add a data source to it, although without any luck so far. The data source is a custom class written by myself (just to add, we do this all the time). We recently converted over to the VS2010 RDLC format which caused some problems, but we've made… >>> More

Related posts about reporting-services

Subtotal error on calculated field in a Reporting Services Matrix

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a Reporting Services report that has two row groups: Category and SubCategory. For columns it has LastYearDataA, ThisYearDataA, LastYearDataB, ThisYearDataB. I added two columns (one for A and one for B) to handle an expression calculation (to show a percentage different from LastYear to… >>> More
Reporting Services: Two Tables One Sum

as seen on Stack Overflow - Search for 'Stack Overflow'
My report is as follows: One table provides financial information with sums at the group footer (Grouping is called "StockTable_Shipped"). The group is controlled by a boolean value (1=shows shipped data, 0 = shows received data) The second table is a variance report for data that has been shipped… >>> More
Sharepoint/WSS Reporting Services Integration woes

as seen on Stack Overflow - Search for 'Stack Overflow'
after a number of failed attempts i seem to have successfully installed the Reporting services add-in to my WSS farm. However, I seem to be missing most of the enhanced functionality eg no report library template, no report center site template. the only additional functionality available is the report… >>> More
SQL Server 2005 Reporting Services - Configuration Manager & Management Studio Problems

as seen on Server Fault - Search for 'Server Fault'
When I open Reporting Services Configuration Manager on my server, an error message appears that says: Reporting Services Configuration Manager An unknown error has occurred in the WMI Provider. Error Code 800706B3 This error appears before I can even attempt to connect to an SSRS instance. In… >>> More
SQL Server Reporting Services Data Extention

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello! So... here's my story: I'm trying to create a SQL server data extension (to be precise, I'm trying to get some sample code to run) (SSRS2005). I've done the following: Placed the extension assembly into the ReportServer/bin folder. Placed the assembly into the Private Assemblies folder… >>> More