how to aplly group on main report using sub report field

[Former Member]

Hello All,

I have a report where I have a field state coming from sub report.

In my main report I need to show data like this.

State:Ap

data--------------------

data--------------------

data-------------------

State:Telangana

Data------------------

Data-------------------

data-------------------

But the state field is coming from sub report.I thought of using shared variable but it will not work.

So please suggest how to aplly group on main report using sub report state field

[abhilash_kumar · Accepted solution]

Hi Kalyan,

You cannot group on a shared variable formula.

You would need to somehow create a single sql query that also contains the state field and use that in the Main report.

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

is there any workaround for this ?

Can you please suggest...