Drill-through report

Hi,
I am trying to set up drill-through reports by passing parameters from
one report to the next.
The first layer works: when the user clicks on the field (the
department in this case) the second report comes up for that
department.
But when I try to pass the same parameter to the third report from a
text box, I get a warning: 'The expression referenced a non-existing
field in the fields collection.' The field is listed in the Fields
list and the text box is referencing it using the aggregate function:
=First(Fields!x_department.Value, "DataSetName")
What am I doing wrong? Thanks for any help you can provide...Is the "DataSetName" a part of the third report?
"Hella" wrote:
> Hi,
> I am trying to set up drill-through reports by passing parameters from
> one report to the next.
> The first layer works: when the user clicks on the field (the
> department in this case) the second report comes up for that
> department.
> But when I try to pass the same parameter to the third report from a
> text box, I get a warning: 'The expression referenced a non-existing
> field in the fields collection.' The field is listed in the Fields
> list and the text box is referencing it using the aggregate function:
> =First(Fields!x_department.Value, "DataSetName")
> What am I doing wrong? Thanks for any help you can provide...
>|||well it's a well known problem.
Insted of using Jump to Report use the Jump to URL.
"Ben Sullins" wrote:
> Is the "DataSetName" a part of the third report?
> "Hella" wrote:
> > Hi,
> >
> > I am trying to set up drill-through reports by passing parameters from
> > one report to the next.
> > The first layer works: when the user clicks on the field (the
> > department in this case) the second report comes up for that
> > department.
> > But when I try to pass the same parameter to the third report from a
> > text box, I get a warning: 'The expression referenced a non-existing
> > field in the fields collection.' The field is listed in the Fields
> > list and the text box is referencing it using the aggregate function:
> > =First(Fields!x_department.Value, "DataSetName")
> >
> > What am I doing wrong? Thanks for any help you can provide...
> >
> >|||Thanks for responding!
I am finally able to try the 'Jump to URL', but the parameter is still
not getting passed.
This is what I have in the URL:
=Globals!ReportServerUrl &
"/Incoming+Types+By+Department/Quarterly+Incoming&Department="+=First(Fields!x_department.Value,
"MonthlyIncoming")
I tried using the Parameter!Department.Value instead of First(Fields!
etc.) but it doesn't work either - (FYI: the report parameter is also
defined in the third report.)
The field x_department is being passed from the parent report (Incoming
Types By Department) to the first child report (Monthly Incoming). It
is the field I am trying to pass to the third report (Quarterly
Incoming.) from the 'Monthly Incoming' report.
Thanks!|||Never mind! it works now.
For whoever might be interested, this is the URL I entered in the Jump
to Url box:
=Globals!ReportServerUrl & "?" & Globals!ReportFolder & "/Quarterly
Incoming" & "&Department="&Parameters!Department.Value
Hella

Drillthrough question - how to return to same report page where drillthrough occurred?

Hello,

I have a master report that uses the "Jump to report" property to drill through to a detail report when the user clicks a report column value. This all works great and the users love it. However, when I click the brower's "Back" button to return to the master report, the master report is rerun and I am returned to page 1. If I drilled through on page 25 of the master report then I have lost my original position and I must navigate back to page 25. The users don't love this "feature"!

Is there a way I can return from the drill through detail report to the master report without using the browser's back button and losing my original position in the master report?

Thanks,

BCB

I forgot to mention that I am using Report Manager and not the .NET report viewer control. Also, I don't see any navigational control on the drillthrough report that allows me to "back up" to the master - that is why I have used the browser's "Back" button.

Thanks,

BCB

Drillthrough question - how to return to same page?

Hello,

I have a master report that uses the "Jump to report" property to drill through to a detail report when the user clicks a report column value. This all works great and the users love it. However, when I click the brower's "Back" button to return to the master report, the master report is rerun and I am returned to page 1. If I drilled through on page 25 of the master report then I have lost my original position and I must navigate back to page 25. The users sure don't love this "feature"!

I am using Report Manager and not the .NET report viewer control. Also, I don't see any navigational control on the drillthrough report that allows me to "back up" to the master - that is why I have used the browser's "Back" button.

Is there a way I can return from the drill through detail report to the master report without using the browser's back button and losing my original position in the master report?

Thanks,

BCB

Hi BCB,
sorry I haven't the answer, but can you just explain me how you do to drill through to a detail report with the option "jump to report"... I have a post here : http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1455055&SiteID=1

Thank you to take few minutes...
please
|||

Hi Alineo,

You open the properties window for the report field that you want to turn into a drillthrough link. On the "Navigation" tab you select the drillthrough report. Finally, you click the "Parameters" button to add all parameters that the drillthrough report requires. That's all it takes.

BCB

|||

I've had the opportunity to investigate this a little more and I believe it has something to do with report parameters that do not have default values. I'm convinced that a report with no parameters will return to the same page when you click the brower's Back button. In other words, the report won't be run again before you see it.

Reports that have parameters without defaults always seem to be rerun when the user clicks the Back button even though the previously entered values are used when the report is generated.

My results with reports that have parameters with default values have varied. Some reports seem to return to the last-viewed page when the Back button is clicked and other reports are rerun.

I'm still looking for an answer to this so if anyone has a theory I'd appreciate hearing it.

Thanks.

BCB

|||

After spending several hours decomposing a report that suffers from this problem, it appears that a report with a parameter of multi-value type will be always run when the user returns to it by using the browser's Back button. This causes the original report to display page #1 again. Not very nice if you happened to viewing page #39 when you clicked the drillthrough link! I can't be sure there is no other way to cause this problem but the multi-value property is guaranteed to do the trick. I'm assuming this is a bug.

We are running SP2 on our servers.

If anyone has experience working around this problem I'd appreciate hearing your solution. Multi-value parms are a requirement for us.

Thanks,

BCB

Drilldown reports

I want to show a list of accounts and when a user clicks on one show
account's details.
What is a best way of approaching that?
ThanksIf you generate a dataset with all the accounts' details you could then use a
table control with grouping by account. You would hide the detail line by
default but allow this to be toggled from a textbox on the group
header/footer.
HTH
--
Magendo_man
Freelance SQL Reporting Services developer
Stirling, Scotland
"Mark Goldin" wrote:
> I want to show a list of accounts and when a user clicks on one show
> account's details.
> What is a best way of approaching that?
> Thanks
>
>|||But since I have a detailed report already how can I create report with
links to the detailed report?
"magendo_man" <sql@.kappa.co.uk.(donotspam)> wrote in message
news:FEE2EC61-3596-4C90-92FE-C1A1EDF5DF6E@.microsoft.com...
> If you generate a dataset with all the accounts' details you could then
> use a
> table control with grouping by account. You would hide the detail line by
> default but allow this to be toggled from a textbox on the group
> header/footer.
> HTH
> --
> Magendo_man
> Freelance SQL Reporting Services developer
> Stirling, Scotland
>
> "Mark Goldin" wrote:
>> I want to show a list of accounts and when a user clicks on one show
>> account's details.
>> What is a best way of approaching that?
>> Thanks
>>|||Most of your detailed report is not visible because the detail line is
hidden. You will only see a list of account numbers. If you click the +
toggle, which you would probably have beside the account number, you would
then see all the detail for that account.
Your other option is a separate drilldown report. To do this you would need
to define an "action" linked to the account number textbox which opened
another report. One of the parameters you would pass to the drilldown report
is the account number.
--
Magendo_man
Freelance SQL Reporting Services developer
Stirling, Scotland
"Mark Goldin" wrote:
> But since I have a detailed report already how can I create report with
> links to the detailed report?
> "magendo_man" <sql@.kappa.co.uk.(donotspam)> wrote in message
> news:FEE2EC61-3596-4C90-92FE-C1A1EDF5DF6E@.microsoft.com...
> > If you generate a dataset with all the accounts' details you could then
> > use a
> > table control with grouping by account. You would hide the detail line by
> > default but allow this to be toggled from a textbox on the group
> > header/footer.
> >
> > HTH
> >
> > --
> > Magendo_man
> >
> > Freelance SQL Reporting Services developer
> > Stirling, Scotland
> >
> >
> > "Mark Goldin" wrote:
> >
> >> I want to show a list of accounts and when a user clicks on one show
> >> account's details.
> >> What is a best way of approaching that?
> >>
> >> Thanks
> >>
> >>
> >>
>
>

drill through report

Hi All,

I have one dotnet applciation in that i am viewing the report in report viewer. In the same report if the user clicks on one field another report will open. I got a problem with this second report. the image placed on the second report is not coming and if the user clicks on the print button which is on the report viewer the first report is only getting printed. How can I print the second report.

Thanks In Advance

Sorry, to answer my own question just found the option linked report in report manager!