Normal Topic Upgraded Application - Two Hurdles (Read 627 times)
BWETTLAUFER
Full Member
***
Offline



Posts: 216
Location: Cambridge, Ontario
Joined: Apr 9th, 2010
Upgraded Application - Two Hurdles
Nov 7th, 2011 at 2:54am
Print Post Print Post  
Hey all!

I spent the weekend upgrading my application from 1.2 to 2.5 -- most everything went smoothly, fixing minor coding items that were upgraded or changed, and integrating some very nice functions that I was able to replace 10 lines of code with 1 line.

However, I got stumped in two major projects in the upgrade.

The first issue is that I have a report called Inventory Report.  It's a functional report, but it's awkward looking.

What I want it to do is simiple in theory, but I can’t seem to execute it in real life.

What I want is this:

===============
PAGE BREAK
REPORT TITLE
Client Number

HEADER
LINE
Inventory Details – Name, Reference Balance, etc.
LINE
Inventory Totals – Account Counts, Balance Totals, etc
===============

But I can’t seem to get working.  My biggest challenge is getting the report title and Client Number to be a banner across the width of the report, without affecting the first column of the inventory report (making the layout ugly).

I’ve tried programming a table report with a cell to ignore the column width, which hasn’t worked.  I’ve tried a freeform/table report, with the title in the freeform section, which also hasn’t worked.

Here’s my current report structure:

GROUP HEADER 1 (break on Client Number) - Cell with page break before always
GROUP HEADER 2 – Cell with Report Title as a String and the Client Number as a variable
GROUP HEADER 3 – Space
GROUP HEADER 4 – Header Cells
GROUP HEADER 5 – Line Cells
GROUP BODY – Report Body Cells
GROUP FOOTER 5 – Line Cells
GROUP FOOTER 4 – Total Cells Calculated on the Body Cells
GROUP FOOTER 3 - (empty)
GROUP FOOTER 2 - (empty)
GROUP FOOTER 1 - (empty)

Can anyone make any suggestions on how to make this kludgy report more elegant?

Thanks!

  
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Upgraded Application - Two Hurdles
Reply #1 - Nov 7th, 2011 at 4:47pm
Print Post Print Post  
BWETTLAUFER wrote on Nov 7th, 2011 at 2:54am:
But I can’t seem to get working.  My biggest challenge is getting the report title and Client Number to be a banner across the width of the report, without affecting the first column of the inventory report (making the layout ugly).


Hello Blair,

It sounds like what you are after is spanning the Value Box in Group Header 2 across all the columns.

Select the Value Box in Group Header 2
Switch to the Position Tab of the Property Editor
Click in Width
Enter C3(Replace the number 3 with the number of columns in the report)
Click the Arrow to the right to set it.

Let me know if that works for you.
-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
BWETTLAUFER
Full Member
***
Offline



Posts: 216
Location: Cambridge, Ontario
Joined: Apr 9th, 2010
Re: Upgraded Application - Two Hurdles
Reply #2 - Nov 8th, 2011 at 2:56am
Print Post Print Post  
That did it!  Thanks!
  
Back to top
IP Logged