Helllo,

I need to acheive TITLE / Subtitle Format in one of my reports.

For Eg:
Details ------------------Cost Details
Car Country ---------RetailCost Dealercost Sales

Here "Details" and "Cost Details" are main Titles.

Car and Country are Subtitles within Details.
RetailCost Dealercost and Sales are Subtitles within cost Details.

I need the grid between the main titles.

Could someone help me to implement this ?

This message has been edited. Last edited by: Kerry,

Whaaaa?

Ramkumar, there is no such thing as TITLE / Subtitle in WebFOCUS.

The tool allows you to have a TITLE for each column and that's it.

What you ask to have (if I understood correctly) can *perhaps* be achieved via HEADING's but this would only work in HTML.

Just search this forum for posts on COLSPAN, HEADALIGN and External CSS (CLASS) styling. You should be able to get some ideas.

Rakumar,

For something quick and dirty (cuz that's how I roll) you could do the following:

  

TABLE FILE CAR
SUM 
  RETAIL_COST AS 'Retail Cost<br/><nobr>Gouge the losers!</nobr>'
  SALES  AS 'Sales<br/><nobr>You call that sales?! My dog could sell better than that!!</nobr>'
BY COUNTRY AS 'Country<br/><nobr>What''s with that Spotted Di*k pudding in England?</nobr>'
BY CAR AS 'Car<br/><nobr>I can hardly wait for Chrysler to sell Fiats!!</nobr>'
END

This will prevent the second line of the title from wrapping. Or as an alternative you could use CSS and reference a class such as ".nobr" in the TYPE=TITLE of the WebFocus stylesheet if you want your code to validate properly.

.nobr {white-space: nowrap}

Best wishes,

Norb

You don't mean Total and Subtotal ?

Hi All,

Thank you for your response.

@Waz - No. It is not total, Subtotal.

@Francis - Yeah. This is one of my Client's report requirment. We are migrating a Legacy application from Foxpro to Webfocus. So the report in the same layout.

@Norb : I need 3 and more Subtitles and Columns within every title.

@njsden : I am trying to implement using Heading and Colspan. But still, I wanted to know, whether there is some dirct way of doing this.

See the below image. Total sales, Margin are Titles.

*** / V.Pl / V.pl% are subitles.

This message has been edited. Last edited by: Ramkumar - Webfous,

You might use 'Cumulative', 'V.Pl', and 'V.Pl%' as column titles, and then use Njsden's suggestion to span those columns with 'Total Sales' and 'Margin', either as SUBHEADs or HEADINGs.

If your output is PDF, you have a bigger problem.
I had to do that once. I placed the top level titles (TOTAL SALES etc) on the bottom line of the header with spot markers. Then to get the boxes around the titles I overlayed a transparent gif of the borders only.
This was tech support's solution to the problem. But it really wasn't that hard to draw
the gif.

Still, I hope you are not needing PDF.

Hi Dan / Selph... Thank you for your replies.

@Dan, I have implemented the report that way. But the problem is with getting the Borders of the same sort.

@N.Selph, For now I am developing HTML and Excel. But I need to implement PDF also. . Could you please elaborate me more on the Overlayed GIF.

To do the overlaid gif:
I measured my printed output carefully, after placing the wording on the bottom line of the heading exactly above the titles they needed to be.
I drew a picture of the borders in Windows Paint, and saved as a transparent gif file. I made this picture the right width and length to cover the header section of my report, and tried to draw the boxes in the right place.
Then placed this gif file in the Header section of the report at the top left.
I had to go back to Paint and adjust the lines over by a few pixels a couple times, because its hard to get the right placement even if you have measured carefully. It didn't take that long, though.
Alternatively, convince the client that they need something else,