Prev: how to stop subreports shifting horizontally if no data?
Next: How to show traffic light or status signs
From: KarenM on 1 Mar 2010 05:47
Hi All,

I want to build a SSRS report with two frames (or windows )in it.

The way I want the report to work in on the left hand frame I will
source data from a query to list products. When the user clicks on
left hand frame on a product I want the right hand frame to list all
sales for that product. I want to keep both the left and right frames
to be visible.

Please note the left frame is running a query creating a dataset
something like this:

SELECT ProductName From Products where region = p_region (the
region is selected as a report parameter)

I want the list of products in the left frame to be selectable. When
the user selects a product on the left frame and clicks on it I want
the right frame to do the following:


SELECT SalesDate, Customer, SalesQty, SalesValue from ProductSales
where Product = <the product selected on left hand side frame>

Please note both queries run against the same SQL Server Database
(same connection).

Can you please let me know how I can do this kind of reporting in
SSRS 2008.

Thanks
Karen
 | 
Pages: 1
Prev: how to stop subreports shifting horizontally if no data?
Next: How to show traffic light or status signs