Formatting question on making an immitation table.

[cmyoung]

Hey everyone,

So I have a report that I have to seperate the columns with vertical lines, sort of to immitate a table.

The kicker is that I have a parameter to show detailed information. So when the detailed information is shown the lines cut right through there. The detailed information isn't really formatted the same way as the totals so the lines just cut through them.

Even when I only draw the lines on the footers and headers of the summarized report side, the detailed version has the lines cut through them.

Is there an easier way to do this?

personally I would rather do without, just gotta convince the boss that...

 

[briangriffin]

How about creating two crosstabs - one that displays the detail, and another that shows the summarized information.

Create two additional report headers. Put the summary crosstab in RHb, and the detail crosstab in RHc.

In the Section Expert, put this formula in the Suppress X2 formula for RHb:

{?Your Parameter} = "Detail"

For RHc, it would be:

{?Your Parameter} = "Summary"

The hardest part will probably be getting the detail crosstab to display the data you want to see.

I hate drawing lines on reports, too...

 

[cmyoung]

Yeah I had thought about this but unfortunately my stupid summaries are all variable equations because I had to use a running total in my equations. So they don't show up as something that can be added to a crosstab.

As for creating new equations for a crosstab to work I don't think I am ready to spend too much time on that haha.

I did try crosstabs before but forgot to mention it.

Thanks for the reply!

Time to go promote the no vertical lines! I still think it looks nice and there is decent spacing in between.

 

[lbass]

I think you should magnify the view to 200% or so and then in design mode make sure that your lines are not extending beyond the section they are supposed to be in.

-LB

 

[cmyoung]

Yeah, yesterday I had realized that a line from the Page Header was crossing into the next section which was on purpose. But that section had not always repeated on the next page so it would continue through the detailed information.

Just a case of telling a computer to do something and then not realizing what what you told it to do haha.