Managment Reporter : Row data should not show for a particular coloumn

(0) Share

Report

Posted on by Mohamed Shuhaib

HI Everyone

We have a requiremnet where row data should not be shown or used in any calculation for a particular coloum ?

is it possible to achive in managment reporter

I have the same question (0)

All responses (13)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

There is the concept of a non-printing NP row.

Have you tried using that?

Please have a look at the default MS report examples that make use of this feature.

Best regards,

Ludwig

Was this reply helpful? Yes No
Mohamed Shuhaib 87 on at

Like (0)

Report

Hi Ludwig ,

This will not show all the coloumns ,

But Our requirment is to not show these rows for Particular coloumn .

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

The NP (non-printing) feature is available for rows and columns.

Best regards,

Ludwig

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mohamed,

Have you tried using the NP feature for your rows and did that work out?

Ludwig

Was this reply helpful? Yes No
Mohamed Shuhaib 87 on at

Like (0)

Report

Hi Ludwig

I Tried This feature in Row .

But all the columns will be not shown ,

i Used the feature Coloumn Restriction .

i didnt show the particular coloum as the requirement , BUt the issue is the totals are including the values in that row of particular coloumn .

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mohamed,

Can you provide more information on your total and the calculations set up?

Some printscreens or report design sketches would help here.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Mohamed Shuhaib 87 on at

Like (0)

Report

Hi Have restricted the cloumn Production for row 3093..3110

But in totals its showing up

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

OK.

Have you tried changing the parameter to calculate first columns and then rows and vice to see if this makes a difference?

Was this reply helpful? Yes No
Mohamed Shuhaib 87 on at

Like (0)

Report

Hi Ludwig

How can we change the parameter to calculate first columns and then rows

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Mohamed,

There is a report setting (parameter) available for that.

Should be in the settings tab of your report and called 'calculation priority'.

Please try running your report with different parameter settings to see if this fixes the issue.

Best regards,

Ludwig

Was this reply helpful? Yes No