Dynamic Headings 1

[pl1101]

I am trying to use a field as a dynamic heading but I am having trouble creating a distinct list as the heading and making the data line up with the appropriate heading.
Currently, the heading will on show up for the one piece of date.



Program Project Status Release date
Assets Books on Hand Active R1.09
Posts Books needed Active R1.10
Links Buckle up Inactive R2.09
Links Tickets on Hand Active R4.11

Need the report to display like:
R1.09 R2.09 R1.10 R4.11
Assets Books on Hand Active X
Posts Books Needed Active X
Links Buckle up Inactive X
Tickets on Hand Active X

When I used the cross-tab it does not create the distinct header. It only shows the ones for each program.

 

[lbass]

Please don't start multiple threads on the same topic--you could have added this clarification to your original thread.

I think you can handle this with an inserted crosstab. Insert rows on: program, project and status, and go to the customize style tab and select each of these that are activated and check "suppress subtotal." Then back to the main crosstab screen, add {table.releasedate} as the column field. Then create a formula like this:

if not isnull({table.releasedate}) or
trim({table.releasedate}) <> "" then
"X"

Use maximum as the summary field.

-LB

 

[pl1101]

That worked great!! I had to create distinct sql statement to build the Release Date as the columns.
New question: How do I eliminate the "white space" when I suppress all of the totals?

 

[lbass]

Instead of suppressing the summaries in preview, go into the crosstab expert->customize style tab->suppress row totals and/or suppress column totals.

-LB

 

[pl1101]

Thank you for that idea, but, I still can not shrink the section any more. The suppressed totals are still there, although hidden.

__________________________________________

Release_Date
-------------
total (grayed out)
-------------
___________________________________________

I want the section to shrink to Release_Date (Height). Manager does not want to see that much white space.

Thank you for responding so quickly!! I appreciate it!

 

[lbass]

If you are doing this correctly, there IS no total line. There are two areas to check. If you are referring to subtotals, then in the upper left area on the customize style tab, you should highlight the fields where you want to "suppress subtotal". Then in the lower right corner in the same tab, you can "suppress row totals" and "suppress column totals". If this doesn't resolve it, you need to explain your rows, columns, and summaries, and how you have formatted them.

-LB