Hi Experts i hope all doing well,
I have a report containing groups country then state.and then fields in detail section.
Group 1: Country
Group 2: state
fields in detail section are brand total,brand total percentage........
Now i have a sub report which contains same groups country and state.Same query i am using but value type='s' here above main report value type='c'
fields in detail section are Store total,Store total percentage........
Now my requirement is like this.
i need to show in main report
India (group by country)
AP (group by state)
brand total,brand total percentage........
Store total,Store total percentage........(Sub Report Data)
US
Newyork
brand total,brand total percentage........
Store total,Store total percentage........(Sub Report Data)
please guide me how to achieve this requirement.