Hi
I have a crosstab report in which I am displaying 10 fields of geogrphay(Country,State,City etc..) information and couple of measures.
I am showing/hiding these 10 fields depending upon a code in database. I am achieving this functionality in report using condition variables.
I have a problem here in displaying the data. I have 4 records in database which have different states and city names but the country name is one only i.e. USA.
While displaing the data I should show USA i.e. country and the measure values. But its displaing only the first record in database with measures of that record.
The Autogroup & Summarize property of my tabular data is set to NO. Since I need to display different records to users.
I need to display 4 records with different measures or 1 record with total of measures.
Thanks in Advance
I have a crosstab report in which I am displaying 10 fields of geogrphay(Country,State,City etc..) information and couple of measures.
I am showing/hiding these 10 fields depending upon a code in database. I am achieving this functionality in report using condition variables.
I have a problem here in displaying the data. I have 4 records in database which have different states and city names but the country name is one only i.e. USA.
While displaing the data I should show USA i.e. country and the measure values. But its displaing only the first record in database with measures of that record.
The Autogroup & Summarize property of my tabular data is set to NO. Since I need to display different records to users.
I need to display 4 records with different measures or 1 record with total of measures.
Thanks in Advance