I have a slight problem. I have a report which is structured the following way with two groups.
First group we will call Provider ID, second group will be called Seller ID. Before each Seller ID there is a header, which is my problem.
When run it is structured in this way
(Note: Numbers and letters I just made up)
123456 (Financial Network)
e10
e11
e12
e13
765432 (Mortgage)
987
1234 (master fin..)
r12
r4
What I want to do is take the last PROVIDER ID(1234) and combine the r12 and r4 sections into one section or group. That way the last Provider ID would only have one heading. The 123456 needs to have group headers for each Seller ID All second sections return multiple rows.
Can this be done?
First group we will call Provider ID, second group will be called Seller ID. Before each Seller ID there is a header, which is my problem.
When run it is structured in this way
(Note: Numbers and letters I just made up)
123456 (Financial Network)
e10
e11
e12
e13
765432 (Mortgage)
987
1234 (master fin..)
r12
r4
What I want to do is take the last PROVIDER ID(1234) and combine the r12 and r4 sections into one section or group. That way the last Provider ID would only have one heading. The 123456 needs to have group headers for each Seller ID All second sections return multiple rows.
Can this be done?