Author Topic: Break in report writer  (Read 4851 times)

DonQuixote

  • Rock Star
  • *****
  • Posts: 205
  • To Dream the Impossible Dream...
Break in report writer
« on: August 04, 2015, 10:21:30 AM »
I'm trying to break on a dictionary item in report writer.

The field is a derived description 30 characters long and I only want to break on the first letter.
The dictionary item converts using T1,1
but conversions are for appearances only.  It still breaks on the entire description.
I've tried putting the conversion in the derived field area but that is ignored.
I've tried [1,1] in the derived field but that is ignored

VEND.DESC1
Derived Field:  (F("VEND",@PARMS(1)<1>:VEND.NUM)<1>)

Any suggestions?

Tom Pellitieri

  • Rock Star
  • *****
  • Posts: 224
  • Tom Pellitieri - Toledo, Ohio
Re: Break in report writer
« Reply #1 on: August 05, 2015, 07:32:56 AM »
Try this:

((F("VEND",@PARMS(1)<1>:VEND.NUM)<1>)"T1,1")

DonQuixote

  • Rock Star
  • *****
  • Posts: 205
  • To Dream the Impossible Dream...
Re: Break in report writer
« Reply #2 on: August 05, 2015, 08:18:19 AM »
I tried and sadly it made no difference.
What did finally work was to call a paragraph where I was able to truncate the value and return it.

precisonline

  • President
  • Administrator
  • Rock Star
  • *****
  • Posts: 1612
    • Precision Solutions
Re: Break in report writer
« Reply #3 on: August 05, 2015, 07:38:16 PM »
I tried and sadly it made no difference.
What did finally work was to call a paragraph where I was able to truncate the value and return it.

I really need to stop in here from time to time.  Sorry folks.  This should be the derived value, not conversion, as the break happens before the conversion is applied.

(F("VEND",@PARMS(1)<1>:VEND.NUM)<1>[1,1])
-Kevin
Accidents "happen"; success, however, is planned and executed.

DonQuixote

  • Rock Star
  • *****
  • Posts: 205
  • To Dream the Impossible Dream...
Re: Break in report writer
« Reply #4 on: August 06, 2015, 09:02:51 AM »
Though both derived statements create a dictionary item that displays the first character.
The purpose was to get a break working for the first character in the statement.

SORT CKP BY VEND.DESC BREAK-ON VEND.ALPHA1 VEND.DESC


VEND.ALPHA1 is the new dictionary item.  The derived slot
(F("VEND",@PARMS(1)<1>:VEND.NUM)<1>[1,1])
produces a column of a single letter but breaks on each unique description and not the first letter

Changing the derived slot
((F("VEND",@PARMS(1)<1>:VEND.NUM)<1>)"T1,1")
also produces a column of a single letter and
breaks after all the descriptions that start with "A", "B",...
That's what I need!

I thought for sure I had tried everything.  Its mystical powers of magic confusing my mind.


precisonline

  • President
  • Administrator
  • Rock Star
  • *****
  • Posts: 1612
    • Precision Solutions
Re: Break in report writer
« Reply #5 on: August 06, 2015, 09:37:10 AM »
Very odd.  Both should have worked.
-Kevin
Accidents "happen"; success, however, is planned and executed.

Tom Pellitieri

  • Rock Star
  • *****
  • Posts: 224
  • Tom Pellitieri - Toledo, Ohio
Re: Break in report writer
« Reply #6 on: August 07, 2015, 06:42:40 AM »
Yes, both should have worked...

But I've become distrustful of combining F(file,key)<attr> with other options.  That's why I recommended putting the entire phrase in parentheses.  I suspect a derived field of

((F("VEND",@PARMS(1)<1>:VEND.NUM)<1>)[1,1])

would also work.

precisonline

  • President
  • Administrator
  • Rock Star
  • *****
  • Posts: 1612
    • Precision Solutions
Re: Break in report writer
« Reply #7 on: August 07, 2015, 10:55:33 AM »
A healthy suspicion is a prerequisite for an informed electorate... and it's also good when working with SB+. :-)
-Kevin
Accidents "happen"; success, however, is planned and executed.