LBI Back Office Reports, publish more than 1 rpt from same job -

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Elizabeth Ardito

Advanced Member

Posts: 34

5/22/2012 1:45 PM

We only have the 'free' LBI product that replaced E-Broadcast from years ago.

I have a new cobol program that produces 2 output files in the print manager (a .prt and the other file is called listing). Is it possible to publish the listing file? I have all the necessary coding in the program to include the tags on both reports.

I have had a case open with Lawson for the last 2 weeks and today they came back after they tried some 'canned' reports but determined they were not burstable that I was on my own.

Any assistance is greatly appreciated.

Elizabeth Ardito
Systems Analyst
Middlesex Health System

Ruma Malhotra

Veteran Member

Posts: 412

5/22/2012 4:15 PM

I agree to Lawson support. Only if a back office report has burstable tags in the program can it be burstable. Not all programs can be burst. At the back of the reporting services manual there is a list of programs that defines which back office reports can be bursted.

Elizabeth Ardito

Advanced Member

Posts: 34

5/22/2012 4:50 PM

To clarify:

This is a custom COBOL report that generates 2 print files NOT a canned Lawson program.

All the necessary workflow coding is including so that it will create the final output files with the necessary tags.

I am attempting to find out from all the great reporting services experts if it is possible to publish the 2nd report. If it is possible, how would I specify the 'listing' report?

Thanks in advance for your assistance.

Elizabeth Ardito
Systems Analyst
Middlesex Health System

Chris Martin

Veteran Member

Posts: 277

5/22/2012 5:08 PM

I encountered this challenge a few years back, and I'm pretty sure there is a feasible solution. I need to go through old emails/notes and see what I can find.

John Henley

Posts: 3353

5/22/2012 6:11 PM

Your custom program shouldn't behave any differently from a standard Lawson program, and as long as you have the tags in the output, it should be burstable.
Have you tried publishing it via LBI yet?

John Henley

Posts: 3353

5/22/2012 6:14 PM

Depending on your versions of LSF9 and LBI, you might have to fiddle with creating a .cfg file for the custom program to make sure the requisite .xml files are created in the print directory. That is what LBI reads to determine the print file structure. Have you tried publishing it via LBI yet?

SP

Veteran Member

Posts: 122

5/22/2012 6:31 PM

Bursting and publishing are two different things. Presuming for a moment that you don't have to burst (i.e. "filter") the data in the report, one option would be to simply publish the webrpt urll to the print file.

Have you tried creating a URL in LBI directly to the print file?

Ruma Malhotra

Veteran Member

Posts: 412

5/23/2012 1:19 AM

Have you looked to see whether the custom program has a .cfg associated with it? If the second report generates a .prt and it has the associated tags it can be published on LBI. There is a bldfxfiles utility that is used to publish a back office report. You may need to look at that as well as the FTP utility that picks up the files from the print directory to move it to the LBI server.

Elizabeth Ardito

Advanced Member

Posts: 34

5/23/2012 9:50 AM

First off, I thanks for all the responses.

We are on lbi version 9.0.4.2.93.

I have completed setup the best that I can within lbi. When I published the new report and get to the report field, I clicked on the yellow box with the ... and entered the report name of listing to match what is in the print manager and workdef (not sure if this is correct or not but my best guess).

I checked the $LAWDIR/system/ers/backoffice//publish.csv and it did update with the new job name; checked the server where reporting services is and it did create a new folder.

Next, I ran the program again, checked $LAWDIR/system/ers/backoffice// and there was NO broadcast.csv file created; checked the print manager and both reports have the necessary tags in the output; I checked the print directory and there is a listing.xml file.

I do not create separate .cfg files as we have $LAWDIR/system/rpt.cfg setup for all reports.

Thanks!

Ruma Malhotra

Veteran Member

Posts: 412

5/23/2012 3:15 PM

If the broadcast.csv file is not generated then there may be 2 issues. Can you check the bldxffiles utility and then check the ftp utility too.

Sometimes the broadcast.csv file is generated so fast and picked up and moved that you may not see it.

In the past when we have done this for customized programs we have tried to troubleshoot on our own. Have you tried the whole process with a CU201 program to make sure that a recommended lawson program and outout works before trying it on a custom cobol program.

Elizabeth Ardito

Advanced Member

Posts: 34

5/23/2012 3:45 PM

We have over 300+ reports setup currently in reporting services, some of them canned reports which have been cloned and the necessary workflow code added others are custom programs.

This is our development environment and have the retrieval of files set to 5 minutes so I know in fact that the broadcast file is not being created at all. Also, there are no files on the lbi server being updated.

Thanks! for your suggestions.

SP

Veteran Member

Posts: 122

5/23/2012 4:56 PM

So there are no canned unmodified Lawson reports (e.g. CU201) which are
currently broadcasting from your development environment to your LBI
server? Is this correct?

If so, have you verified the ftp settings between the RS "Lawson Data
Connection" and what is actually configured on the LSF development server?

On Wed, May 23, 2012 at 11:45 AM, wrote:

> [image: LawsonGuru.com Logo] <https://www.lawsonguru.com/> Lawson
> Business Intelligence/Reporting/Crystal Forum Notification A message was
> posted to a thread you are tracking. *RE: LBI Back Office Reports,
> publish more than 1 rpt from same job* Posted by: *Elizabeth Ardito*
> 05/23/2012 10:45 AM We have over 300+ reports setup currently in
> reporting services, some of them canned reports which have been cloned and
> the necessary workflow code added others are custom programs.
>
> This is our development environment and have the retrieval of files set to
> 5 minutes so I know in fact that the broadcast file is not being created at
> all. Also, there are no files on the lbi server being updated.
>
> Thanks! for your suggestions.
> ------------------------------
>
> To view the complete thread and reply via your browser, please visit:
>
> https://www.lawsonguru.co...1-rpt-from-same-job/
>
> You were sent this email because you opted to receive email notifications
> when someone posted and/or responded to a message on this forum.
> To unsubscribe to this thread please visit your user profile page and
> change your subscription options.
>
> Thank you,
> LawsonGuru.com
>

Elizabeth Ardito

Advanced Member

Posts: 34

5/23/2012 5:07 PM

Yes I stated that we have 300+ reports setup some of them canned some of them custom.

I have setup cu201 and it burst correctly.

All the other reports I have setup are bursting correctly. The only issue I am having is with the special second report that I want to setup.

thanks!

John Henley

Posts: 3353

5/23/2012 6:03 PM

You mentioned in a couple of steps back about clicking on the "..." when publishing. I think you need to use the drop down to the left of that to select the different output file. =

Elizabeth Ardito

Advanced Member

Posts: 34

5/23/2012 6:24 PM

When I do that, only the main report with the .prt displays.

That is the part that I am stuck on as I am not sure what to do there on the second report.

Thanks!

Greg Moeller

Veteran Member

Posts: 1498

5/23/2012 6:47 PM

Does your custom report produce a file with an extension on it? I've found in some cases Lawson expects to see an extension of some sort... *Just an idea, not sure if it is applicable here or not.

John Henley

Posts: 3353

5/23/2012 6:59 PM

Ok, that helps. Hang in there.

SP

Veteran Member

Posts: 122

5/23/2012 7:18 PM

My apologies in advance. You may have already answered this, but does the
main rpt file broadcast as expected?

If so, have you tried generating a second *.prt file? I have some
high-level instructions on how if you need them.

On Wed, May 23, 2012 at 2:31 PM, wrote:

> [image: LawsonGuru.com Logo] <https://www.lawsonguru.com/> Lawson
> Business Intelligence/Reporting/Crystal Forum Notification A message was
> posted to a thread you are tracking. *RE: LBI Back Office Reports,
> publish more than 1 rpt from same job* Posted by: *Elizabeth Ardito*
> 05/23/2012 01:24 PM When I do that, only the main report with the .prt
> displays.
>
> That is the part that I am stuck on as I am not sure what to do there on
> the second report.
>
> Thanks!
> ------------------------------
>
> To view the complete thread and reply via your browser, please visit:
>
> https://www.lawsonguru.co...1-rpt-from-same-job/
>
> You were sent this email because you opted to receive email notifications
> when someone posted and/or responded to a message on this forum.
> To unsubscribe to this thread please visit your user profile page and
> change your subscription options.
>
> Thank you,
> LawsonGuru.com
>

John Henley

Posts: 3353

5/23/2012 8:03 PM

Can you post a screenshot of the contents in the print folder for that job?

Elizabeth Ardito

Advanced Member

Posts: 34

5/24/2012 9:42 AM

Yes I setup the main .prt report and it bursts normally.

I do not know how to make the second report appear in the print manager with a .prt extension. Any assistance with this would be great

Hopefully the screen shot of the directory will upload properly.

John Henley

Posts: 3353

5/24/2012 12:22 PM

You will need to set the workdef for this "listing" file to use the WsFld, match it to a working-storage field, and include code in your MH672PD to override the default "listing" filename.

SP

Veteran Member

Posts: 122

5/24/2012 12:33 PM

Elizabeth,

Here are the high level steps get a 4GL program to produce a second rpt
file in the print manager:
1. Define the additional report(s) in workdef, file type = Printer
2. In the .rpt file, clone the lines from $REPORT thru $ENDRPT
3. In the clone, under the $REPORT put a line: $PRINTFILE xxxx where
xxxx = the workdef file name
4. In the PD do this: OPEN OUTPUT xxxxx-FILE.

On Thu, May 24, 2012 at 5:51 AM, wrote:

> [image: LawsonGuru.com Logo] <https://www.lawsonguru.com/> Lawson
> Business Intelligence/Reporting/Crystal Forum Notification A message was
> posted to a thread you are tracking. *RE: LBI Back Office Reports,
> publish more than 1 rpt from same job* Posted by: *Elizabeth Ardito*
> 05/24/2012 04:42 AM Yes I setup the main .prt report and it bursts
> normally.
>
> I do not know how to make the second report appear in the print manager
> with a .prt extension. Any assistance with this would be great
>
> Hopefully the screen shot of the directory will upload properly.
>
>
>

>
> ------------------------------
>
> To view the complete thread and reply via your browser, please visit:
>
> https://www.lawsonguru.co...rpt-from-same-job/2/
>
> You were sent this email because you opted to receive email notifications
> when someone posted and/or responded to a message on this forum.
> To unsubscribe to this thread please visit your user profile page and
> change your subscription options.
>
> Thank you,
> LawsonGuru.com
>

Elizabeth Ardito

Advanced Member

Posts: 34

5/24/2012 1:16 PM

Thanks John for the instructions. I am in the midst of an environment upgrade and I am hoping in the next few days to get a chance to make the necessary coding changes and see if this will make the report display in reporting services as a report selection.

Thanks everyone for all the assistance.

Elizabeth Ardito

Advanced Member

Posts: 34

5/30/2012 3:26 PM

I am unable to get the program code correct to 'match it to a working-storage field, and include code in your MH672PD to override the default "listing" filename.

I have spent enough time attempting to figure this out without success so I am going to split the program into 2 separate ones to get both reports burst.

Thanks again for all the assistance in helping to get this to work.

Elizabeth Ardito