How to manage click-through

How will I possibly do click through on this type of chart when basically I'll have to bring in just Grand Total values to do what they want to do here in this mock-up:

SSRS 2005

Expected/Desired Outcome (user drew this using Excel and later wants click-through capability through SSRS 2005 on the bars later on):

http://www.webfound.net/chart3.jpg

I don't see how this is possible, can y ou shed some light? because basically what I'll have to do to get that few of bars is literally bring in just Grand Totals for the series....static Grand Totals from my dataset's stored proc calculation since I cannot perform really a GT by using SUM in the expressions for any fields in the chart or I'll get an error

Hi,

In SSRS 2005 charts you can do the click through. In the chart layout. Just go to "Drop Data fields here" right click on the button for properties and on the Action tab you can select Jump to report.

Before that you need to create a seperate report so that when you click on the value this particular report comes up.

Any doubts let me know.

Amarnath.

|||

thanks much. What about infinite click-through?

Can I even create charts that do this just like inifinte click-through for reports using models?

How to make Sub total will be first the first record in next page

I have a report with 1 group per page.

I need Sub Total from Group footer in page 1 will be Subtotal in Group Header in Page 2 (or viewing in Group Header in Page 2), Sub Total from Group footer in page 2 will be Subtotal in Group Header in Page 3, and so on...

How to implement it...Plase help me, urgent.

Thanks Before,

AgusHave you tried to use shared variables?One way to solve the problem is to calculate running total in group footer and assign the value to shared variable.Then you could split group header where top section would display shared variable and bottom section would be used to reset it.|||Dear Denan,...

Thanks for your suggestion.
Actually i never used shared variabel. Would you like to help make an example formula code where is it using shared variabel.

Thanks before,

Agus|||Hi Agus
Well,as I said one formula should be placed in group header.Here you display your total and reset it.Formula would be something like this.
shared numbervar Total;//This is your shared variable
numbervar out;//temporary variable

out:=Total;//Assign total to temporary variable
Total:=0.0;//Reset Total
out//Display result

In group footer you calculate running total and assign that value to shared variable which will hold it until CR passes through group header next time

shared numbervar Total;//Shaerd variable must have same name as in header formula
Total:=#YourRunningTotalName

I hope this helps|||Thanks Denan,...