Precisely Speaking
May 21, 2012, 07:08:35 PM
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News
: So what's news with you? Tell us about it in "Getting To Know You"!
Home
Help
Calendar
Login
Register
Precisely Speaking
>
Application Support
>
Activant/Prelude Support
>
Report Writer break totals
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: Report Writer break totals (Read 520 times)
DonQuixote
Rock Star
Posts: 108
To Dream the Impossible Dream...
Report Writer break totals
«
on:
February 18, 2011, 12:10:45 PM »
I have a Report Writer (/RD) report that has break totals for PRICE.EXT and PROFIT.EXT from the ORDER.HISTORY.LINE file. I am breaking on the invoice date, accumulating the PRICE.EXT and the PROFIT.EXT and get a total price extension (T.PRICE.EXT) and a total profit extension (T.PROFIT.EXT).
What I want to do is put on the same break line the gross profit percentage (T.PROFIT.EXT/T.PRICE.EXT). But all I get is blank. I am able to display each value again separately but when I put a formula like (T.PROFIT.EXT/T.PRICE.EXT) in the derived slot I get nothing. What else can I do?
Logged
precisonline
President/Chief Technologist
Administrator
Rock Star
Posts: 1532
Re: Report Writer break totals
«
Reply #1 on:
February 19, 2011, 08:09:13 PM »
Be careful about using the "/" for divide like this. Remember that in SB+ "/" doesn't mean the same thing as in BASIC. You might try using the pipe "|" instead. Any difference?
Logged
-Kevin
Accidents "happen"; success, however, is planned and executed.
DonQuixote
Rock Star
Posts: 108
To Dream the Impossible Dream...
Re: Report Writer break totals
«
Reply #2 on:
February 21, 2011, 10:08:11 AM »
That was it. Brilliant.
Logged
precisonline
President/Chief Technologist
Administrator
Rock Star
Posts: 1532
Re: Report Writer break totals
«
Reply #3 on:
February 21, 2011, 10:11:16 AM »
Love it when a plan comes together. That said, that pipe thing still trips me up with some frequency.
Logged
-Kevin
Accidents "happen"; success, however, is planned and executed.
Thomas
Professional
Posts: 21
Re: Report Writer break totals
«
Reply #4 on:
February 24, 2011, 09:19:19 AM »
Yeah, I've been having my fair share of problems with / vs |, myself. Took me a while to figure that one out.
Logged
* Government is not the solution to our problem; government is the problem - Ronald Wilson Reagan
* Democrats are the party of food stamps and Republicans are the party of paychecks. - Newt Gingrich
Pages: [
1
]
Go Up
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General Category
-----------------------------
=> Getting To Know You
=> Announcements
=> Big Thoughts / Cool Ideas
=> Rants & Raves
-----------------------------
Application Support
-----------------------------
=> Red Leaf
=> Activant/Prelude Support
=> Summit Support
=> Avante Support
=> PRC Support
-----------------------------
Training and Education
-----------------------------
=> Connect!
=> U2 Programming Questions
=> SB+ Programming Questions
=> Web Programming Questions
=> Business Intelligence / MITS
=> PC / Hardware / Miscellaneous Support
Loading...