Tuesday, February 14, 2012

drill down report using Report sevices

Hi all

I am new in Sql Server reporting services ..So please help me to clarify my doubt

Please help me to know whether it is possible to generate a drill down report using Report sevices. If it possible please let me know how it can be generated

For Example

Measures

Quarter1 Quarter2 Quarter3#

Profit Profit Profit

====================================================================================

Dimension

Product1 200.50 1500.75 -200.40

Product2 5000.00 4000.00 6000.00

==================================================================================

In the above example Quarter 3 for product 1 shows los in such cases I want to drill down the transaction to get the detailed inormation and to find out the reason how the loss came..

Please help me to get such type of drill down is possible in measures to get the detailed report

With regards

Polachan

In your sample report, I assume these are aggregated values that are summed by some sales? You will want to use a table that holds the sales. That table can be collapsed by the quarters to show the sum of the product for that quarter and the expanded to show the details of the sales.

I know that this reply does not go into detail on how this is done, but it might be a start.

|||

Dear guyinkalamazoo3

Thank u for ur reply to my quries

is it possible to drill down the measure object. ?...

For example in quarer 3 for product1 shows -200.40 loss.

So I want to drill down

Profit

-200.400
--> Customer Product Date Invoice Amt
- -
x Product1 01/10/2007 001 -100
y Product1 01/10/2007 001 -100.40

Can I give this type of drill down is possible in Measure attributes Profit. So I can find in which transaction occure loss to my organisation

Please help me to get a solution for this...

|||

Unfortunately, I hope somebody else might be able to help you with this problem as I am not that familiar with using cubes and OLAP in reporting. This is something that I am just learning myself. I am sure that the technical aspects for drilling down into the actual data in the reports is the same, but I am unfamiliar with data from OLAP.

Sorry I could not be of any further help.

|||

I am just starting on Reporting Services myself, and just finished my first drill down report. What you describe sounds like you should be able to do it.

There is a series of tutorials for Reporting services. The link below is to part of one. This section has 6 lessons that build up to lesson 6 - a drill down report.

http://msdn2.microsoft.com/en-us/library/aa337432.aspx

Hope this helps point you in the right direction.

Shirley

No comments:

Post a Comment