Crystal Formatting Problems

[SeekingAnswers2003]

Hi to all,

How can I formatt a field. Here's my problem....

I have a number that represents total time, this number is in seconds (i.e. 90) I would like to convert those 90 seconds to show up in my report as 00:01:30

How do I do that? I'm using Crystal Reports 8.5

Thanks.

Daniel.

 

[synapsevampire]

I have a FAQ on this here:

faq767-3543

-k

 

[MonitorMonkey]

Hi, Experts!

I'm an inexperienced CR user and this is my debut on your forum.

In version 8.5 I'm trying to create a form letter which uses 3 linked tables.

A heading will print on every letter (current date, name, address, subject lines, greeting and opening sentences).

The heading will be followed by the section I'm having trouble with. This section uses a file in which each record contains logical fields A - Z.

Suppose the first record's logical field values are: field RecA = true, field RecB = false, Field RecC = true and the remaining logical field values are all false.

I want to print the string associated with a true value in field RecA, skip 2 lines, print the string associated with a true value in field RecC, skip 2 lines and then end the form letter with another section that appears on each letter (closing text, name, title, phone number).

I've stored my string values in formula fields and I am able to get the strings to print for true values.

Here's what I don't know how to do:
1.) Suppress the blank lines for field values which are false and
2.) skip 2 lines after each line containing the string associated with true values

Too much or too little information?

Any help offered is appreciated.

 

[lbass]

Monitor Monkey--

Welcome--but you should have started a new thread--see the top of the forum where you can click on "Start New Thread."

But, to answer your question anyway:

First place each logical field in its own detail section--go to format->section->details and click insert until you have detail sections_a to _z. Then for each detail section_a to _z also check "Suppress Blank Section."
Then in preview, right click on the gray area to the left of each detail section and choose insert line twice to create the two line spaces.

-LB