Forum

Hi;

I'd like to change the DataCompositionSchema template for a Report based on some conditions. (I especially need to change the report query). How can I do it? Can I do it in Report form?

Hello, Joanna.
Normally it is better to create several reports or report variants with different queries and use filters and parameters to provide a user additional options.

Yes, but I thought it would be more elegant to have only one report and change the query based on user role rather than create two reports...

I've got this...

In Report object module, I've just put the lines:

If IsInRole("MyRole") Then   
   
ThisObject.DataCompositionSchema = Reports.MyReport.GetTemplate("MainDataCompositionSchema1");
   
Else
   
ThisObject.DataCompositionSchema = Reports.MyReport.GetTemplate("MainDataCompositionSchema");
   
EndIf;