Drill up/down functionality is not working in my report

[kalyan_y]

Hi,
      I'm developing a report based on DMR model. Geography(Region and Country are the levels) and Time are the  2 dimensions which I'm using to create a report.
      I have a prompt in my report,(text box prompt). I created a dataitem with the calculation that says, if the value entered is R then show Region else show Country.
      In the report, I have taken Time as the Columns and Dataitem as the rows in the crosstab .
      Based on the prompt selected, Region/country is displayed, but the drill up/down function is not shown up for datatitem.

     Is it that, if we define any calculations and use them in the crosstab, drill up/down functionality will not work?

Please help ???

[rockytopmark]

By default, the report will NOT have drill-down/up functionality turned on... You will need to enable this.

In the Data menu, Select Drill Behavior. 

[kalyan_y]

I have selected that option from Data menu. Still drill up/down is not wrkg on the calculated item that I have created... :(

[MFGF]

Hi,

The issue is that you are using a query calculation, thereby removing the prederermined hierarchical structure from your rows area.  Even if you define this as a member set and change the drill down behaviour to "replace expression", there will still be nowhere to drill down or up to that the report understands.

If I had to write a report like this, I'd probably try one of the following:

a) Use a Tree prompt instead of a value prompt (ie in your query calculation, use an expression such as [Your geography hierarchy] -> ?Geogparam?)

or b)

Create two crosstabs, one with the Region level in the rows, the other with the Country level in the rows, then use a conditional block to render one or the other dependent on your prompt.

Good luck!

MF.