Normal Topic Columnar report help (Read 840 times)
tcgeo
Full Member
***
Offline



Posts: 278
Location: Traverse City, Michigan
Joined: May 13th, 2008
Columnar report help
Dec 24th, 2008 at 2:29am
Print Post Print Post  
I have a columnar report that shows the data, a line, and then a subtotal. I can’t for the life of me figure out how to add a space below the subtotal before the next column of data is displayed.

Example:

Data_________________
Subtotal
     Need space here
Data_________________  
Subtotal

Any help would be appreciated,

Thanks                    
  
Back to top
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Columnar report help
Reply #1 - Dec 24th, 2008 at 5:44am
Print Post Print Post  
Assuming you are using a static text element with something like: "Subtotal:"

A very easy way would be to add two line breaks to that static element's label, like this (without quotes): "Subtotal:<br><br>"


PS: You could also use "Subtotal:<p>". This will usually cause the browser to give a slightly larger vertical space. (I prefer the double <br>.)
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
tcgeo
Full Member
***
Offline



Posts: 278
Location: Traverse City, Michigan
Joined: May 13th, 2008
Re: Columnar report help
Reply #2 - Dec 24th, 2008 at 1:44pm
Print Post Print Post  
Thank you very much for the response Carl that works great!

If you don’t mind, a couple more questions.

Is <br> an HTML specific code?  And, where can I find all the other goodies, if there are any, for dressing up a report?

I’d also like to be able to produce the same break in a PRINT_ONLY-PREVIEW report if it’s possible. Are there codes for this also?

Thanks again for your help.

Merry Christmas,

Brandon
  
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Columnar report help
Reply #3 - Dec 24th, 2008 at 8:40pm
Print Post Print Post  
You can also add a second Footer row and fill it with Spacer elements to create a space between the subtotal and the next row of data. I don't have documentation in front of me, but this trick may be in the manual. Adding additional Groups (which is how you get another Footer row) is definitely in the manual. It has certainly been written up elsewhere.

I'm out of town right now, but I can send you some tutorial documents when I get back, if you want.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
tcgeo
Full Member
***
Offline



Posts: 278
Location: Traverse City, Michigan
Joined: May 13th, 2008
Re: Columnar report help
Reply #4 - Dec 25th, 2008 at 1:49am
Print Post Print Post  
Thanks Erika.

I'd love to have the tutorial docs when you get back.

Merry Christmas,

Brandon
  
Back to top
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Columnar report help
Reply #5 - Dec 25th, 2008 at 6:22pm
Print Post Print Post  
tcgeo wrote on Dec 24th, 2008 at 1:44pm:
Thank you very much for the response Carl that works great!

You're welcome.

Quote:
Is <br> an HTML specific code?  And, where can I find all the other goodies, if there are any, for dressing up a report?

I’d also like to be able to produce the same break in a PRINT_ONLY-PREVIEW report if it’s possible. Are there codes for this also?

Yes, it is HTML, and it will only work in the HTML type reports. This trick will not work for the "Print Only" type reports, and these codes will be visible in Print Only reports. So, if you are using those, you may want to use Erika's solution instead. (I never use the Print Only type because I like using the HTML tags to tweak the look of my reports. I find it easier than creating additional groups. Just my preference.)

MERRY CHRISTMAS!
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
tcgeo
Full Member
***
Offline



Posts: 278
Location: Traverse City, Michigan
Joined: May 13th, 2008
Re: Columnar report help
Reply #6 - Dec 27th, 2008 at 1:56pm
Print Post Print Post  
Ok Carl, thanks again for the help.

Brandon
  
Back to top
IP Logged