I have a drill through that passes four parameters. Three are passed from the current selections in that reports parameters and the fourth needs to be the customer name they click on in the body of the report so it's passed as Fields!fieldname.Value. When I click on the customer name, the drillthough fires but the report simply doesn't load. If I remove the parameter from the field clicked on and just pass the three parameters, it goes to the drill through correctly and that fourth parameter just sets to the default for that parameter in that report.
I can then simply check that parameter and select the value from the list that is exactly the same as the value I was attempting to pass it in the drill through and report refreshes correctly.
Whatever it is, is something in the manner that the value is passed in the drill through specifically.
Any ideas?
Figured it out. The table with the link in it was alone in a detail area. I put it inside a list like the other reports involved in this function and then the link worked. Problem there was that there was no grouping in this data. It's a block of data for a particular week; only about 13 lines each with the same week_end_date. I simply added a grouping on the week (required by the list) and then everything worked fine.
Not sure why you can do a drill through in a list but when you do the same drillthrough in a table not in a list it didn't pass the clicked-on field value properly. Is this a bug?
Tim
No comments:
Post a Comment