thisismark

Hi! Thanks for the answer. Unfortunately, the report you provided doesn't retrieve records. I also checked the expression of the fields in your detail band and there was no "$V" stuff. Can you please provide a sample? ---- Never mind above. Saw it on the band properties. Thanks. And can you please provide me a link of where you learned the $V{Group_COUNT}? Thank you so much.

Hi there! I have created an SQL query which shows the following records: Bus Number Date Order Code Parts 1111 10/01/2012 1234 Front Left Wheel 1111 10/01/2012 1235 Rear Left Wheel 1112 10/01/2012 1236 Left Wiper 1112 10/01/2012 1237 Right Wiper 1112 10/02/2012 1238 Windshield Now, I want to show them in iReports this way: Bus Number Date Order Code Parts 1111 10/01/2012 1234 Front Left Wheel 1235 Rear Left Wheel 1112 10/01/2012 1236 Left Wiper 1237 Right Wiper 1112 10/02/2012 1238 Windshield I just want to make the BUS NUMBER and the DATE invisible after its first record. At first, I thought putting all of the fields in the same group header and then putting again the fields ORDER CODE and PARTS in the details section would do but came out like the one below. I thought the cursor would move to the next record. Bus Number Date Order Code Parts 1111 10/01/2012 1234 Front Left Wheel 1234 Front Left Wheel 1235 Rear Left Wheel 1112 10/01/2012 1236 Left Wiper 1236 Left Wiper 1237 Right Wiper 1112 10/01/2012 1238 Windshield Any ideas guys? :)