Report refresh

[Former Member]

Hi All,

I have a issue where user refreshes the report based on hierarchy nodes.

"A" is parent node in hierarchy and b,c and d are child nodes.

Lets say that user has authorizations only for nodes b,c and d.First refresh of the report, the output is OK.

But on refreshing second time(same opened report) nodes b,c and d disappear and node "A" appears with a message "no authorization".All data from previous refresh also disappears. Then report has to be closed again and then reopened and refreshed to get correct result

Can you help on this.May be there is some issue with refresh functionality.

Regards,

SS

[tnecnivo]

Hi SS,

Please check whether is there any Restriction/Variables in Default Value Tab in Query Designer.