Lawson v10 Office Hours

Unknown

Infor Global Professional Services is proud to present the Lawson v10 Office Hours Series.

We realize Infor Lawson v10 customers are still leveraging our v10 solutions and we want to make sure that you are able to get the value out of your solution. We know you have ad hoc questions around how to, potential training topics or best practice questions.

In the spirit of partnership, Infor Global Professional Services is scheduling a series of office hours sessions for the v10 suites to discuss and review specific topics. Agenda topics for each forum will be determined based on client input and staffed with experienced Lawson v10 consultants. We are setting up within each Infor Lawson v10 Community a forum where questions and topics can be proposed for future discussions. Please visit this site and submit your questions today! In addition to the forum, there will also be a calendar of events.

We are very excited with the response to conduct these forums and look forward to reviewing your questions and participation.

ehoffman3

Just received another invitation to join and post questions, but have never seen a TIME for this session on Tuesday.

Unknown

https://community.infor.com/discussion/comment/47592#Comment_47592

Hello Erica,

There is an invite on the calendar for the call on Tuesday, 3/23/21.  It is scheduled for 9am PT, Noon ET.  Below is a link to the calendar invite.

https://community.infor.com/infor-lawson-supply-chain-management/c/e/303

Thank you,

Luanne

ehoffman3

https://community.infor.com/discussion/comment/47593#Comment_47593

I have a question for the forum.  We use Crystal reports extensively for reporting. Is there a way to summarize the participants table values into one output field.  For example for a PO25 header, can I list all participant companies in one output field instead of listed one on a line below the header data?  I can build formulas to summarize counts, but can find a way to concatenate or array this information.  My IT department can't find code for this functionality either.

StephanieD

ref: crystal help "to create running totals using a formula".  Your IT group should be able to make this work for you.

This would be your detail formula to accumulate the participants, then you would have a reset and a display formula on your agreement ref group.

WhilePrintingRecords;
NumberVar Participants;
Participants := Participants + ' ' + {prk.company};

ehoffman3

https://community.infor.com/discussion/comment/47651#Comment_47651

Does this code go directly into a Formula field in Crystal?

StephanieD

Please review the crystal help "to create running totals using a formula" this should explain in detail.  The code I provided would go in a formula field on the detail line after you update PRK with the participants table..

ehoffman3

https://community.infor.com/discussion/comment/47657#Comment_47657

This is not a running total and explains why i receive a an error message "A number, currency amount, date, time or date-time is required here.". 

I'm looking to string like an array or concatenate, but with data from the SAME field for on multiple records with a common parent.  In this example the data is the text values stored in the POAGRMTPART.COMPANY field into a single reportable field to be displayed with the VEN_AGREEMTN_REF so I don't have to display multiple rows to show the values contained in the Child table.

StephanieD

Running total example

3 formulas

1. Reset the running total in group header

WhilePrintingRecords;

StringVar Participants := '';

2. Running total in detail

WhilePrintingRecords;

StringVar Participants;

Participants := Participants + {PROCTMPPAR.REQ_LOCATION} + ' ';

3. Display the running total in group footer

WhilePrintingRecords;

StringVar Participants;

Hide the group header and the detail and display only the group footer with the concatenated values for the group.

 

ref: crystal help "to create running totals using a formula".

ehoffman3

https://community.infor.com/discussion/comment/47768#Comment_47768

Since I'm attempting to add this in the detail groupings, I'm attempting to use the following:

WhilePrintingRecords;

StringVar Participants;

Participants := Participants + {PROCTMPPAR.REQ_LOCATION} + ' ';

However, I'm using POVAGMTPART.COMPANY, which is a number field.  Therefore, the StringVar value returns an error. What needs to be updated to make this work for a number field?

Erica Hoffman

StephanieD

Erica,

You will need to adjust this to what you are trying to do.  I was just providing an example of how to set it up...trying to help.  I realize you are working with a different field than the example that I provided.

ehoffman3

https://community.infor.com/discussion/comment/47835#Comment_47835

I'm not familiar with any of this type of data setup, I don't know HOW to change this to use for a numeric field type as opposed to a string.  My SQL/Crystal coding does not currently include this type of processing.

StephanieD

Here's from my original post 7 days ago.  Try using NumberVar in place of StringVar.  Let me know if any problems.

WhilePrintingRecords;
NumberVar Participants;
Participants := Participants + ' ' + {prk.company};

ehoffman3

https://community.infor.com/discussion/comment/47840#Comment_47840

I'm using in the Crystal Parameter window

WhilePrintingRecords;
NumberVar Participants;
Participants := Participants + ' ' + {POAGMTPART.COMPANY};

And keep receiving an error message: A number, currency, amount, date, time or date-time is required here. then it highlights the ' ' portion of the last line when I select OK.

StephanieD

Switch it back to StringVar and use the ToText function to convert the company field to text.  You'll need this to have a delimiter to separate each company in the concatenated list.  Sorry I didn't think of this on the last post.

WhilePrintingRecords;
StringVar Participants;
Participants := Participants + ' ' + ToText({POAGMTPART.COMPANY};);

StephanieD

I see I accidentally put an extra semicolon between the company field and the last parenthesis.  Hopefully you noticed this was a typo.

ehoffman3

https://community.infor.com/discussion/comment/47844#Comment_47844

When I use the following coding in the formula screen, my Crystal report blanks out immediately on Save. I have to re-run the report to see the later pages and the app crashes each time.  Before the refresh, I have one contract with participants on screen, and the formula field ONLY shows the first of the 21 company values for this Agreement.

Not sure what the coding issue is, but this code doesn't work for this purpose.

ehoffman3

https://community.infor.com/discussion/comment/47849#Comment_47849

If I page down one page at a time, I can get the report to run, however,  the data is not correct.  Multiple iterations of one value with a sprinkling of others, but not an accurate list.  Every time I ask it to scroll to last page it begins to page down then crashes.