Matrix with 2 subtotal

Hi All,

I wish to have a report with 2 subtotal using matrix control given by reporting service.

CD

DVD

Total Price

Total Qty

2.00

5.00

JOHN

5

25.00

5

JOLIN

5

10.00

5

Total Price

10.00

25.00

Total Qty

5

5

I only can came out total price(subtotal) which provided by matrix control.

Does the matrix control able to come out as table above with 2 subtotal?

Thanks

Kendy

The grid above has the unit price in the header and only the quantity measure in the details area. You need to create and additional Price measure and display both measures in the details area either on the rows or the columns as a static group. E.g.

Measures on Columns

CD

DVD

Total

2.00

5.00

Quantity

Price

Quantity

Price

Quantity

Price

JOHN

5

25

5

25

JOLIN

5

10

5

10

Total

5

10

5

25

10

35

Measures on Rows

CD

DVD

Total

2.00

5.00

JOHN

Quantity

5

5

Price

25

25

JOLIN

Quantity

5

5

Price

10

10

Total

Quantity

5

5

10

Price

10

25

35

|||

Thanks for your helps and advice.

Its really give me an ideas

Thanks Adam

Matrix SubTotals Visibility

I am creating a report using a matrix, and matrix subtotals.
I give the user the option of including the reporting hierarchy in their
reports. If they want to include it, I would like to hide the subtotal,
completely.
The reason for this is because if I include a hierarchy within a single
field of a report, the subtotals don't sum properly.
Is there any way to hide the entire subtotal field within a matrix report?
I have tried modifying the Hidden field (using an expression) of the
SubTotal textbox, but that only seems to hide the textbox itself, not
the subtotal fields.
Thanks,
NoahNevermind. Figured it out using InScope().
Noah
Noah wrote:
> I am creating a report using a matrix, and matrix subtotals.
> I give the user the option of including the reporting hierarchy in their
> reports. If they want to include it, I would like to hide the subtotal,
> completely.
> The reason for this is because if I include a hierarchy within a single
> field of a report, the subtotals don't sum properly.
> Is there any way to hide the entire subtotal field within a matrix report?
> I have tried modifying the Hidden field (using an expression) of the
> SubTotal textbox, but that only seems to hide the textbox itself, not
> the subtotal fields.
> Thanks,
> Noah

matrix subtotal

Hi Everyone,

I am trying to get something like this using matrix in reporting services

SE CP CG Total Qty Value Qty Value Qty Value Qty Value GST Net 7/07/2006 124 233 552 525 141 2544 563 4215 321 4536 8/07/2006 1245 211 11 142 555 1444 1987 1854 124 1978

The problem is, in the total group, the GST value and Net ( Net = Value + GST) can't added into the total group in the matrix.

Can somebody help... Thanks a lot.

You can use InScope in a matrix to determine 'where you are' e.g. are you a subtotal cell, are you within a particular column or row grouping

You can also create hidden groups

This helps to deal with non additive measures

In fact here's another post that may help

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1884435&SiteID=1

|||

Thanks a lot..

That help me a lot...

Matrix Pagination

Hello,
I've been developing a matrix report in Reporting Services, and for
some reason, pagination does not work. Instead of getting page breaks
when the report runs over the page height, the report renders as a
single page. PDF export seems to work fine (i.e., the pagination works
correctly), but regular HTML display of the report does not.
I've checked every parameter that I could find -- KeepTogether, page
height, etc. -- but the matrix does not paginate. Am I missing
something? What else should I check?
Thanks for your help,
GarrettIf your report uses toggles for visibility, pagination may not work correctly
in HTML, while it does render correctly in PDF. My understanding is that this
is being worked on for the next service pack.
John W
"Garrett" wrote:
> Hello,
> I've been developing a matrix report in Reporting Services, and for
> some reason, pagination does not work. Instead of getting page breaks
> when the report runs over the page height, the report renders as a
> single page. PDF export seems to work fine (i.e., the pagination works
> correctly), but regular HTML display of the report does not.
> I've checked every parameter that I could find -- KeepTogether, page
> height, etc. -- but the matrix does not paginate. Am I missing
> something? What else should I check?
> Thanks for your help,
> Garrett
>|||Bingo! I'm using an expression to determine visibility of the row
groups in my report. The report is meant to be dynamic so the user can
select which dimensions are displayed, and therefore the visibility is
based on specific report parameters.
I took out the visibility expressions, and pagination started working
again. Thanks for the suggestion and the quick response. Now I just
need to figure out a way to make pagination and dynamic groups work
together (besides waiting for the next service pack).
Garrett

Matrix Group Shading

I am using SQL 2000 Reporting Services.
I am trying to get a column group to shade if it starts with the word
Total. The problem is there is not always a "Total" value for a
particular "row group" (date). Is there a way to shade the entire
column?
Here is the current formula. Is there a way to reference the current
group header?
=iif (mid(Fields!SubType.Value,1,5)="Total","PaleGoldenrod","")
Thanks,Basically I want to set the background color on the entire column if
the group (column) header begins with the word "Total".
daveg.01@.gmail.com wrote:
> I am using SQL 2000 Reporting Services.
> I am trying to get a column group to shade if it starts with the word
> Total. The problem is there is not always a "Total" value for a
> particular "row group" (date). Is there a way to shade the entire
> column?
> Here is the current formula. Is there a way to reference the current
> group header?
> =iif (mid(Fields!SubType.Value,1,5)="Total","PaleGoldenrod","")
> Thanks,

Matrix custom subtotals ? How is it possible ?

Hi ALL,
I have a problem and i becoming crazy !
I create a report like this using a Matrix in Reporting Services
Sales
Area 1 250
Customer 1 100
Customer 2 150
Area 2 60
Customer 3 40
Customer 4 20
I need to add a total row witch is the sum of AREA 1 + AREA 2 lke this
IMPORTANT : rows in matrix becomes directly from my query... they are
not grouping.
Sales
Area 1 250
Customer 1 100
Customer 2 150
Area 2 60
Customer 3 40
Customer 4 20
TOTAL 310
How can I express the contition... If I add a total to the matrix my
total is 620 (wrong !...)
Thank you !
Gas1970On Jun 13, 11:16 am, alberto.gasta...@.libero.it wrote:
> Hi ALL,
> I have a problem and i becoming crazy !
> I create a report like this using a Matrix in Reporting Services
> Sales
> Area 1 250
> Customer 1 100
> Customer 2 150
> Area 2 60
> Customer 3 40
> Customer 4 20
> I need to add a total row witch is the sum of AREA 1 + AREA 2 lke this
> IMPORTANT : rows in matrix becomes directly from my query... they are
> not grouping.
> Sales
> Area 1 250
> Customer 1 100
> Customer 2 150
> Area 2 60
> Customer 3 40
> Customer 4 20
> TOTAL 310
> How can I express the contition... If I add a total to the matrix my
> total is 620 (wrong !...)
> Thank you !
> Gas1970
Traditionally, in some cases, I obtain my sums/totals in the stored
procedure/query that is sourcing my matrix report. This should be a
good option in your case as well. Also, depending on the complexity of
the matrix report, you may need to use a while loop/cursor to
determine the sum/totals. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Matrix Cross-tab Report Not Counting Records

I am new to Reporting Services and cross-tab reporting in general. I
need to create a basic report that has dates across the top and reps
down the left. The data I would like to see reflected is the number of
entries created in the table by rep by day with cross sums. What I am
getting is a report that has a column for every entry with the date
repeated over and over and no totals, only 1 in each column.
Visually I need to see:
Day 1 Day 2 Day 3 Total
__________________________________
Rep1 4 10 1 15
Rep2 2 4 3 9
Total 6 14 4 24
What I am getting is a report where Day 1 would be repeated 6 times
with an entry of 1.
Can someone point me in the right direction?I would like to add that my table uses a datetime field that has a
unique value for each record. I do need a specific timestamp.
Probably part of my problem, but how do I resolve it?
zanecolvin@.gmail.com wrote:
> I am new to Reporting Services and cross-tab reporting in general. I
> need to create a basic report that has dates across the top and reps
> down the left. The data I would like to see reflected is the number of
> entries created in the table by rep by day with cross sums. What I am
> getting is a report that has a column for every entry with the date
> repeated over and over and no totals, only 1 in each column.
> Visually I need to see:
> Day 1 Day 2 Day 3 Total
> __________________________________
> Rep1 4 10 1 15
> Rep2 2 4 3 9
> Total 6 14 4 24
> What I am getting is a report where Day 1 would be repeated 6 times
> with an entry of 1.
> Can someone point me in the right direction?|||Solved my own problem. Created a view converting data type from and
back to datetime to get 12:00 time on all entries. Used that for the
report.
zanecolvin@.gmail.com wrote:
> I would like to add that my table uses a datetime field that has a
> unique value for each record. I do need a specific timestamp.
> Probably part of my problem, but how do I resolve it?
>

Matrix control

Hi all,

I'm using matrix control as my reporting tools.

But i found one trouble, how can i do my matrix become like this.

Product A

Product B

Customer

Price

Qty

Price

Qty

Customer A

10

10

140

160

Customer B

12

120

120

160

Customer C

10

10

110

140

The price and qty is the static column, and i would like to make the static row also. (show in red color) but i can't.

Please help...

Thanks

Kendy

1.

Add matrix contol

2.

in the row add Customer

3. in the columns add Product

4. Right click on Data and select add column

no you will have two column

add price to the left onw and Qty to the right onw

|||

Hi Idanle,

I have create the matrix control, for the qty and price i using static column.

For static row, i have do it also but the result will be like this

Product A

Product B

Price

Qty

Price

Qty

Customer

Customer A

10

10

140

160

Customer

Customer B

12

120

120

160

Customer

Customer C

10

10

110

140

It will repeat because is static row same as static column where repeated showing out the "Price" and "Qty".

How to make the title "customer" only showing as header.

Thanks

Kendy

|||Can you send me the RDL or upload a print screen of youe design mode|||

Hi Idanle,

I have upload the excel file.

Inside the excel file, the tab name "Defect" is the problem i facing, wherelse the tab name "Output" is what i expected.

http://download.yousendit.com/ED0492A72B6C6C66

Thanks

Kendy

|||

I can't found the problem.

Can you send me your table (data source) and the RDL or the matrix definition?

|||

Hi Idanle,

As u can see from the excel file, the tab defect page.

The "Customer" header will always display as a row detail where show in red color.

But when see the output tab, where the result i wanted. The "Customer" header will remain as header, it wouldn't same like defect tab.

My question is can matrix control done as output tab, if yes how the way to do it.

Thanks

Kendy

|||

Hi,

I see the problem and I'ts seams somthing worng with your matrix setting since this problem should not occur.

This is way I ask for thr RDL and table.

If you can just create your data table in excel I will set for you the RDL

|||

Hi Idanle,

I have upload the table, rdlc and expected output i wanted.

http://download.yousendit.com/CA8B3D95276E0341

Thanks for your help.

Regards

Kendy

|||

The table you sent me is not the same table using your Expected output.

What is the problem with the current output ? it's look fine

|||

Hi Idanle,

Actually, when you look at expected output and current output. The only different is header, in expected output there are header where mark in red color wherelse in current output is without the header.

And i have try do it with static row (just try in one column name Customer), the result i get is like this, please download from the link.

http://download.yousendit.com/BC879C5820984C1A

So can i know how to do it become expected output using matrix control provided by sql server reporting services?

Thanks

Kendy

|||For column headers, what you need to do is put a rectangle in the corner cell. In this rectangle, put your Customer label textbox.

Matrix Cell Height?

Is there any way to get the Reporting Server to preserve the height of a cell
in a matrix? Currently, i set CanGrow and CanShrink to false (because i've
already designed the matrix cells to fit the text). However, with these both
set to false, the height is automatically changed to about 50 pixels, and i
can't get it to not do that.
Anyone know how to do this? Please help.
--whitOn Apr 25, 9:50 am, Whitney Yiu <Whitney...@.discussions.microsoft.com>
wrote:
> Is there any way to get the Reporting Server to preserve the height of a cell
> in a matrix? Currently, i set CanGrow and CanShrink to false (because i've
> already designed the matrix cells to fit the text). However, with these both
> set to false, the height is automatically changed to about 50 pixels, and i
> can't get it to not do that.
> Anyone know how to do this? Please help.
> --whit
Check each cell of the matrix control and make sure that 'Can increase
to accommodate contents' and 'Can decrease to accommodate contents'
are not selected as part of the properties (Format tab). Hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Matrix Calculation - New to RS2000

Hello!
Iâ'm hoping somebody out there can help me! I am a new user of SQL Reporting
Services 2000 and have been asked to create a report showing studentsâ'
attendance. After a lot of reading and research I created a matrix report
that looks like this;
=Fields!attendance_type.value Total
=Fields!student_id.value
=Fields!week_no.value =Fields!register_id.Value =count(Fields!attendance_type.value)
It gives me the following results;
PR AA AB Total
0003 7 ACCA2 4 0 0 4
BUSA2 4 0 0 4
LANA2 2 2 0 4
8 ACCA2 2 2 0 4
BUSA2 2 2 0 4
LANA2 2 0 0 2
9 ACCA2 4 0 0 4
BUSA2 2 0 2 4
LANA2 3 0 0 3
10 ACCA2 4 0 0 4
BUSA2 4 0 0 4
LANA2 3 0 0 3
I would now like to add another column next to Total (subtotal of
=Fields!attendance_type.value) to calculate the % Attendance by using
PR/Total*100.
So in the end, I want something like this;
PR AA AB Total % Attendance
0003 7 ACCA2 4 0 0 4 100
BUSA2 4 0 0 4 100
LANA2 2 2 0 4 50
8 ACCA2 2 2 0 4 50
BUSA2 2 2 0 4 50
LANA2 2 0 0 2 100
Your help would be much appreciatedâ?¦
Wilma KhaliqYou can do a second query and append it to this one with "union", like
select blah blah from blah where blah
union
select blah2 blah2 from blah2 where blah2
except in the bottom select you can do your total, making a new type called
'TOTAL'
--
"Everyone knows something you don't know"
"Whee4ever" wrote:
> Hello!
> Iâ'm hoping somebody out there can help me! I am a new user of SQL Reporting
> Services 2000 and have been asked to create a report showing studentsâ'
> attendance. After a lot of reading and research I created a matrix report
> that looks like this;
> =Fields!attendance_type.value Total
> =Fields!student_id.value
> =Fields!week_no.value =Fields!register_id.Value =count(Fields!attendance_type.value)
> It gives me the following results;
> PR AA AB Total
> 0003 7 ACCA2 4 0 0 4
> BUSA2 4 0 0 4
> LANA2 2 2 0 4
> 8 ACCA2 2 2 0 4
> BUSA2 2 2 0 4
> LANA2 2 0 0 2
> 9 ACCA2 4 0 0 4
> BUSA2 2 0 2 4
> LANA2 3 0 0 3
> 10 ACCA2 4 0 0 4
> BUSA2 4 0 0 4
> LANA2 3 0 0 3
> I would now like to add another column next to Total (subtotal of
> =Fields!attendance_type.value) to calculate the % Attendance by using
> PR/Total*100.
> So in the end, I want something like this;
> PR AA AB Total % Attendance
> 0003 7 ACCA2 4 0 0 4 100
> BUSA2 4 0 0 4 100
> LANA2 2 2 0 4 50
> 8 ACCA2 2 2 0 4 50
> BUSA2 2 2 0 4 50
> LANA2 2 0 0 2 100
> Your help would be much appreciatedâ?¦
> Wilma Khaliq

Matrix - No data display "NaN"

Hello,

I have matrix object in reportin (SQL 2005 reporting services)

When in some field have no data it display NaN.

How can I change it ?

I try to use iif(my function = nothing.....) but didn't help

Hi there,

Here's a blog posting that may help

http://blogs.digineer.com/blogs/jasons/archive/2006/08/18/374.aspx

cheers,

Andrew

Matrix - Alternating row colours

Hello,
My first posting - I am fairly new to reporting services and I wonder if
anyone knows how to alternate the background colour on a row in a matrix?
I can do a similar thing in a table using
=iif(RowNumber(Nothing) Mod 2, "#ffffff","#d3efef")
this doesn't function correctly if it's placed across the matrix row - and
outputs wrong over individual cells.
# Broxi #Please read this blog article:
http://blogs.msdn.com/chrishays/archive/2004/08/30/223068.aspx
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Craig Thomson" <craig@.mercatus.no> wrote in message
news:eZyGk3HoEHA.1460@.TK2MSFTNGP12.phx.gbl...
> Hello,
> My first posting - I am fairly new to reporting services and I wonder if
> anyone knows how to alternate the background colour on a row in a matrix?
> I can do a similar thing in a table using
> =iif(RowNumber(Nothing) Mod 2, "#ffffff","#d3efef")
> this doesn't function correctly if it's placed across the matrix row - and
> outputs wrong over individual cells.
> # Broxi #
>

Matrices in reporting services

Hello All,

I am attempting to produce a Summary report that will detail all financial losses incurred by a company. These losses are seperated into categories and each category has two types, direct and indirect. To date I have employed the use of multiple matrices.

The problem is that if the company has incurred no losses for a specific category then this will cause the matrix to automatically cater for the lack of this column. However I want this to show up regardless of there being data...

I cannot employ the use of tables...as it simply does not work!

Does anyone have any suggestions? Ideas?

All would be appreciated!!

Thanks

JrDevRon,

You could return "Zeros" or Blank space in your SQL where no losses occur for specific categories. This is ensure that you always return all categories regardless.

Ham

|||

Hi Ham,

Thanks for the reply!

I have this implemented already and this works fine when at least one of the cells in the same column/row has been populated. If there is no data for a specific column then the whole thing disappears regardless...this is something I do not want.

Right now I have it this way and giving me a subtotal, I also then have another row detailing the recovered amounts which apply to my categories below my subtotal, obviously due to restrictions I have to use a second matrix for this information. I then subtract the corresponding information from the subtotal. But due to the above problem these columns do not always line up on the report...

I know this sounds convoluted and more complex than it probably needs to be but I would be appreciative of any help...

Thank you all!!

master.dbo.xp_fixeddrives

SQL Server 2000
master.dbo.xp_fixeddrives stored procedure is reporting different values
when executed by 'sa' and a regular user.
Results:
(When executed by 'sa')
drive MB free
-- --
C 18432
D 118784
E 16384
(3 row(s) affected)
(When executed by 'UserA')
drive MB free
-- --
C 8192
D 68608
E 3072
(3 row(s) affected)
Is there any reason for this difference?
Thanks,
--payyans
sorry this might be stating the obvious but,
ensure that UserA and sa are logged on to the same server.
"payyans" wrote:

> SQL Server 2000
> --
> master.dbo.xp_fixeddrives stored procedure is reporting different values
> when executed by 'sa' and a regular user.
> Results:
> (When executed by 'sa')
> drive MB free
> -- --
> C 18432
> D 118784
> E 16384
> (3 row(s) affected)
> (When executed by 'UserA')
> drive MB free
> -- --
> C 8192
> D 68608
> E 3072
> (3 row(s) affected)
> Is there any reason for this difference?
> Thanks,
> --payyans
>

master.dbo.xp_fixeddrives

SQL Server 2000
--
master.dbo.xp_fixeddrives stored procedure is reporting different values
when executed by 'sa' and a regular user.
Results:
(When executed by 'sa')
drive MB free
-- --
C 18432
D 118784
E 16384
(3 row(s) affected)
(When executed by 'UserA')
drive MB free
-- --
C 8192
D 68608
E 3072
(3 row(s) affected)
Is there any reason for this difference?
Thanks,
--payyanssorry this might be stating the obvious but,
ensure that UserA and sa are logged on to the same server.
"payyans" wrote:

> SQL Server 2000
> --
> master.dbo.xp_fixeddrives stored procedure is reporting different values
> when executed by 'sa' and a regular user.
> Results:
> (When executed by 'sa')
> drive MB free
> -- --
> C 18432
> D 118784
> E 16384
> (3 row(s) affected)
> (When executed by 'UserA')
> drive MB free
> -- --
> C 8192
> D 68608
> E 3072
> (3 row(s) affected)
> Is there any reason for this difference?
> Thanks,
> --payyans
>

Master->Detail Reporting

I'd like to put together a summary report for some of my management staff. The report should show the # of jobs that match about 20 different statuses. Each status has different criteria. For example, one might look for a date in a datetime field and the type of job. Another might look at whether a date has passed and the quantity we're shipping.

Sort of like this:
Status Items Jobs
Status #1: 50000 15
Status #2: 25251 3

I want the user to see this summary information, but also have drill down capability. I'd like the ability to print the summary or just a drill-down.

I'm also considering using Dundas Charts for RS on the report.

Can I accomplish this with Reporting Services? If so, any tips on how to do it? If this a bunch of sub-reports? Can I sum the # of jobs on a sub-report? Should I be looking at BI for this?

Or should I be working on a Forms-based?

Thanks!
Brian

bes7252 wrote:

I'm also considering using Dundas Charts for RS on the report.

Why would you need a chart for this? Basically you would use either a table or matrix for this.

bes7252 wrote:

Can I accomplish this with Reporting Services? If so, any tips on how to do it? If this a bunch of sub-reports?

Yes, you can accomplish this with RS. You need to craft the proper SQL query that will give you the data you need for the table. If you get stuck, there are many SQL pros here that can help you. This doesn't have to be a bunch of sub-reports. It could be as little as two -- one to drilldown on the Item field and one to drilldown on the Jobs field.

Tips:

1. Create the parent report and get the data for the report that you need using a SQL query.

2. Create the subreport layout and pass parameters as needed from the parent report to subreport.

bes7252 wrote:

Can I sum the # of jobs on a sub-report? Should I be looking at BI for this?

1. Yes

2. If you want to, but it isn't necessary.

You will find that the power of these reports is SQL. If you aren't comfortable with SQL, you probably won't be very comfortable doing this.

|||> Why would you need a chart for this? Basically you would use either a table or matrix for this.

I should have used the word Gague instead of Chart. The report is sort of a dashboard look at a section of our business. I figured if I wanted to provide more info for each status (like avg jobs/day over the last 2 weeks) then a gague might provide a nice visual.

I am comfortable with SQL, but an not familiar with all the ways to use MSSQL. It seems like every time I figure out a way to do something, someone shows me a better way. I think you're suggesting I create the columns in the SELECT statement like this:

SELECT (SELECT COUNT(*) AS EXPR1
FROM Person.Contact
WHERE (EmailPromotion = '1') AND (LastName > 'S')) AS col1,
(SELECT COUNT(*) AS EXPR1
FROM Person.Contact AS Contact_1
WHERE (EmailPromotion = '0') AND (LastName <= 'S')) AS col2

Assuming I've done this correctly, I have a concern. One of the reasons I considered a sub-reports is then I know the data from each subreport will match the total on the parent. If I use a WHERE condition (like shown above), can I make sure the drill-down data always uses the same condition? Maybe store it in a variable? I'm concerned that down the road we'll change the condition in the parent, but forget to change the detailed view.

Brian
|||

bes7252 wrote:

> If I use a WHERE condition (like shown above), can I make sure the drill-down data always uses the same condition? Maybe store it in a variable? I'm concerned that down the road we'll change the condition in the parent, but forget to change the detailed view.

Brian

The where condition shown above is what we call a 'hard-coded' value. You would want to create parameters in place of those values. In reporting services, we typically use parameters (similar to variables).

It would be something like WHERE EmailPromotion = @.emailPromotion AND LastName <= @.lastName.

When I use parameters, I like to put them in a stored procedure (as opposed to a text query).

The final step to this (once you get a stored procedure working in the parent report with parameters) is to pass the values by right clicking on the chart -> properties -> navigation. Here you can pass the parameters to the drill down.

In the drill down you would use a similar approach:

WHERE EmailPromotion = @.emailPromotion AND LastName <= @.lastName

Therefore, it would get the passed parameters from the parent report. Then the values are not "hard-coded".

|||

Greg,

That makes sense. Can I define the entire Where clause as a parameter? Then pass it in to the stored procedure and have the SQL built on the fly?

(This one might be outside the scope of this forum.) I'll probably use a ReportViewer control embedded in a WPF application. Once the user drills down he'll see job numbers. When the user clicks on a job #, can I have launch a form? Perhaps this would involve some kind of event binding between my code and the ReportViewer control?

Brian

|||

bes7252 wrote:

Can I define the entire Where clause as a parameter? Then pass it in to the stored procedure and have the SQL built on the fly?

I would just use the parameters that I indicated with @. signs as parameters. I wouldn't pass the entire where clause as a parameter.

bes7252 wrote:

When the user clicks on a job #, can I have launch a form? Perhaps this would involve some kind of event binding between my code and the ReportViewer control?

I use Visual Studio to handle all of the event binding. Do you have Visual Studio 2005 or just SQL 2005? Visual Studio handles this quite well.

|||

>> I would just use the parameters that I indicated with @. signs as parameters. I wouldn't pass the entire where clause as a parameter.

Will I suffer performance loss if I do this? I ask because the WHERE clause for each status will be drastically different. I'd prefer to guarentee the parent always matches the child by storing the entire string in a parameter.

>> I use Visual Studio to handle all of the event binding. Do you have Visual Studio 2005 or just SQL 2005? Visual Studio handles this quite well.

I have VS2005 Pro. The app uses WPF for the interface, but the ReportViewer is inside a Winform control. (I can't remeber what it's called). I'll look through the event bindings.

Thanks much for your help.

Brian