January 9, 2015 at 7:46 am
Hi,
I have an issue with Report Builder and linking to a report.
I have a Matrix report with two Row Groups of Area and Sub Area. It simply shows a total by area and subarea of our property stock.
I have a detail report that I want to link to. I want the matrix to work that when you click on either the area or the sub area it shows you those properties on a separate report.
On my detail report I have created two parameters. One called area_parameter and one called subarea_parameter. These are then added to the filter od the dataset.
On the matrix report – on the subarea total - I have an action to open the detail report when area_parameter = Area and subarea_parameter = subarea. That works perfectly.
The issue I have when I add an action to area. I have just placed area_parameter = Area in the action and I keep getting an error –
The ‘subarea_parameter’ parameter is missing a value.
What do I need to do to get this to work. As I’m only clicking on the Area, the Sub Area shouldn’t matter?
I’m lost at how to get this to work. Is there a way round this.
Both report have the same shared dataset
January 9, 2015 at 4:48 pm
it sounds like you just need to allow nulls in the sub_area parameter of the detailed report.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);January 9, 2015 at 5:52 pm
I already tried that and it still doesn't work?
Really bugging me.
January 14, 2015 at 9:01 am
Hi,
Ok so an update.
I've managed to do this using extra datasets.
So I have a Summary report and a Detailed report.
On the detailed report I have created a parameter and a dataset called "Location Status". The dataset only has one field in it.
In the parameter I set it to multiple values and also set the available and default values to "Get Values from a query" and pointed it at my dataset.
On the summary report I have a total number - that withing the tablix properties only shows a location status of occupied and void.
On the textbox I have set an action on it to open a report and at first I set the parameter I created in the detailed report to equal the location status. When you drill down you only get the occupied and not the void?
The only way I can get it to work is to have two parameters to run the report that uses the following fuctions -
= "Void"
and
= "Occupied"
Now when I click on my total it drills through correctly.
Is there any way to include the above in one parameter on the action instead of the two I have?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply