Forum: Lawson Business Intelligence/Reporting/Crystal

 136 Subscribed to this forum
Page 2 of 34 << < 12345 > >>

Topics

Replies
Rating
Status
Views
Subscribers
Last Post

Crystal Report Paramaters with Encryption    

Started by  JasonP
We have an email notification that goes to users that has an embedded link with dynamic parameters such as so that https://xxx.xxxx.net:9443/efs/FSRemotefsid=RS:RS-HMC Reporting Services:1099&Dobeforeevent=false&Company=10&Vendor=48663&Invoice=1153 Is there a way to encrypt the Company , Vendor, and invoice values and have crystal accepts those.
0 3191 0
9/28/2018 2:56 PM

Exporting crystal report in text format?    

Started by  Lance Jurgensen
Am I missing something in my system I don't seem to have an option to export a report run from LBI to Text The output to CSV is similar but it surrounds each line with quote marks. Anyone know of a way around this Thanks, -Lance LBI 10-6-17-0-339 Crystal RAS 2011
0 3355 0
9/12/2018 8:24 PM

Summarized Transactions - Payroll    

Started by  O. Johnson
I've been able to write SQL to get from the GLTRANS Summarized Transactions back to the invoices on the AP side, but now being asked to do the same on the PR side. Anyone have any experience in getting from a GLTRANS Summarized Transaction back to the PR transactions that make up the Summarized Transaction Thanks!
1 40846 1
by  Ragu RaghavanJump to last post
9/5/2018 10:53 AM

LBI and Crystal 2016, Windows 10 (UPDATED)    

Started by  Kelly H
We are in the process of migrating to Windows 10. One concern is that we are all using Crystal 2008 for our LBI reports and Lawson reporting. Our tech person is concerned about Crystal 2008 and Windows 10 not working well together. is anyone using Crystal 2013 for LBI Have there been any issues As of 11/29/17- it appears we can only upgrade to Crystal 2016. Anyone have Crystal 2016 and Windows 10 working with Lawson
4 44710 3
by  SRHarrisJump to last post
7/19/2018 4:10 PM

List of active employees at a certain point in time.    

Started by  agersh
I am looking to produce a list of all employees that had an active employee status at a specific point in time (specific date). For example, all employees that had an active employee status on 10/1/2015. Any idea of the SQL query that would produce these results
3 49043 3
by  agershJump to last post
6/11/2018 1:32 PM

Deliver LBI report to Email    

Started by  thummel1
I am exploring various delivery options of LBI reports to customers. One option I am exploring is the ability to deliver a scheduled LBI report to an email delivery device. We currently have that functionality in place for Smart Notes; however, this is not an option for this particular need. I am wondering if similar functionality exists within Reporting Services If yes, are there resources to learn about configuration We are on version 10.6.13.0.326 for reporting services. Thank you!
4 49826 3
by  Dave CurtisJump to last post
5/30/2018 7:00 PM

Lost Data Settings    

Started by  Katy Prince
Old reports have these data settings: Datasource in Report: Override Datasource Default User ID Default Password Confirm Password When Viewing Report: But when I try to publish a new report all of the above is missing... Anyone else ever run into this See attached.
3 43878 1
by  Greg MoellerJump to last post
4/16/2018 5:05 PM

Moving Lawson Documents    

Started by  Donna
I write reports and publish them but have never set up LBI. We have new administrators and are not sure how to point LBI from one location to another to find the Lawson Documents folder. We have done all the back up and copying for the folder but are looking for some guidance on the LBI technical side. Thank you. Donna Shelton
3 53143 0
by  DonnaJump to last post
4/12/2018 7:05 PM

QLIK    

Started by  Donna
We are in the process of implementing QLIK. We currently use LBI and Crystal Reports but will be moving some of our reporting over to QLIK. QLIK will be used at our hospital for some EPIC, Clarity, Lawson and other hospital subsystems.reporting. If anyone else especially in healthcare is using QLIK or in the process of implementing QLIK we would like to make contact with them and maybe eventually create a Lawson QLIK forum.
2 41630 2
by  NabilJump to last post
3/20/2018 2:55 PM

Convert PR261 to easy to read format    

Started by  thummel1
Has anyone had the need to replicate the PR261 report but in LBI, with the goal of being to be able to read it in a simple format, export to Excel, and run any necessary calculations against the fields for auditing purposes Our payroll department uses this report to ensure the taxable wages are appearing correctly, but the format is not ideal for auditing purposes. Payroll has requested a format that would display one row per employee, with each deduction code appearing in it's own column with ...
1 44147 2
by  Jason BeardJump to last post
3/9/2018 8:22 PM

Upgrade for LBI v10 - Infor BI, BIRST or other    

Started by  NatalieD
October 2016, we upgraded to Lawson v10 and LBI v10. We report heavily on operational/detail level data throughout our Supply Chain department. We primarily use Crystal Report files posted to LBI to facilitate data dumps and summary information to our end users (data to review and update inventory reorder theory, item conversions, etc). We regularly use Lawson Add-ins for large record changes so our field demand for reporting is quite large. For years we have struggled with record limitations in...
1 45662 3
by  NabilJump to last post
2/7/2018 8:15 PM

Lawson Smart Reports - LSR Designer    

Started by  dkester
I'm new to LSR and LSR Designer. We're just starting to test some of our reports using LSF Designer and unable to get a template created for PR260. I've been using the user guide, LSRDUG_10.0.3.0_W_01 to configure the designer but still unable to link the report to a template. The default, CU201 that INFOR provided looks pretty straight forward, but I'm unable to get another template setup. My goal is to create a barebones report for PR260 and apply our company logo, nothing fancy or complic...
2 31999 1
by  dkesterJump to last post
1/10/2018 8:55 PM

LBI vs. Infor Birst    

Started by  Nabil
Infor is promoting Birst as the LBI replacement. They said (in a Demo) that Infor Reporting is not the future direction and LBI is to be replaced by Birst. I'm wondering if any of you are considering this move We are just short of 200 Crystal Reports and some 30-40 Smartnotes. All of these will need to converted to Birst reports or Alerts. Thanks, Nabil
3 48432 4
by  JeremyJump to last post
1/2/2018 4:57 PM

Output to CSV does not retain    

Started by  thummel1
Since our upgrade to v10, we have several scheduled reports in LBI that are not retaining their output type settings. One specific report is set to save in CSV format in the Report Options, with the default Output Type saved as Comma Separate Values (CSV) and only Comma Separated Value is checked in 'Allowed Output types'. Yet when the report runs on the schedule, the scheduled instances are generating in RPT format. I've tried deleting the schedule and adding back in, deleting the report an...
0 2954 1
12/1/2017 1:36 PM

LBI Schedule Disappear Randomly    

Started by  Dave Curtis
Over a year ago we started having this random issue with LBI report schedules randomly disappearing. We have tried to find a reason why and tie it to some event but have not been able to. What is additionally head scratching is that not ALL of the schedule is gone. If I look in the table that has the schedule triggers (ejs_triggers: This is the info on the second part of the schedule with delivery info etc.) I will find the schedule but the actual schedule in ejs_cron_triggers is gone. So ...
10 50228 5
by  Joan HerzfeldtJump to last post
11/22/2017 2:15 PM

Report will not burst    

Started by  Donna
This is very strange. I have another version of the same report with the same bursting rights structure that runs successfully but the newly published report runs if I remove bursting rights but displays as a blank repot once bursting rights are added. We even republished the report with a new report ID but it will not burst or even display any data once the bursting is added.
8 41995 4
by  DonnaJump to last post
10/11/2017 9:15 PM

Survey Functionality    

Started by  thummel1
I am wondering if Lawson V10 has the ability to create a survey for employees in Employee Self Service
0 3658 1
9/5/2017 6:09 PM

Remove MNR PO Lines from Report    

Started by  brupp
Hello - I have a Crystal Report of open PO lines where PO qty < Received qty & have been asked to only include those lines without an invoice matched to the line. I found POLINE.MATCHED_NO_REC but do not understand the numeric values & they're not listed in the guru data dictionary. Does anyone know the values & their meaning, & will setting this field achieve the desired result in my Crystal Report Thanks.
3 50576 0
by  Kat VJump to last post
9/5/2017 12:18 PM

Infor Enhancement to APAUDIT    

Started by  NatalieD
Currently, when we audit changes to our AP10.1 and AP10.2 address changes using APAUDIT, the table also shows address changes to PO10. Auditing AP10.1 and AP10.2 address changes is required by our internal audit department. We utilize field ID's 5, 6, 7, 8, 9, 10, 11, 12, 18, 19, 20, 21, 22, and 23. We are showing false audit findings due to the merged data in APAUDIT. Please reference Infor incident 10826136 for troubleshooting with Infor tech and their test findings. Currently no way...
0 3648 1
8/21/2017 10:51 AM

Guru Data Dictionary    

Started by  FireGeek21
Does anyone know information about accessing the data dictionaries on here Going to Tech -> Data Dictionary -> clicking on 9.0 for tables, getting an error - 404 - File or directory not found. They have been helpful for us in the past. Thanks!
15 41153 3
by  John HenleyJump to last post
8/3/2017 6:29 PM

UTC Conversions on Date Range Functions    

Started by  Joan Herzfeldt
I'm accessing a database that has dates stored in UTC so even though 'an action was taken' on 6/30/2017 20:12:00 Central time (where I'm located) , due to the conversion to UTC this record does not show up on the report if I use ' in the LastFullMonth' because it converts to 7/1/2017 01:12:00 UTC. I know how to replace LastFullMonth with two separate date parameters. What I want to know is... Is there a way to convert any of the 'Date Range Functions' (ie: LastFullMonth) to take the time zone...
1 45866 1
by  John HenleyJump to last post
8/3/2017 2:29 PM

LBI On Demand-passing in authuser value    

Started by  petec
We are using the LBI RS ers/ersRequestHandler.jsp to create report bookmarks in Portal for remote EMSS users. Has anyone been able to use &SelFormula or perhaps &LawUserID to pull the authuser value (user who has logged in) For example, if user 3436 logs in, I want that valued passed as a parameter into the LBI\Crystal report so the user only sees their data. Let me know. Thanks. (need it for Portal and eventually workspace, these users won't have LSO).
7 41001 3
by  Who Da PhillyJump to last post
7/20/2017 12:21 PM

ReportWriter GL Income Statement 12 Mo.    

Started by  Ron Soclof
How is it best to create formulas to have columns for the 11 prior months to CPAMT. I tried CPAMT-1 which just subtracts 1 from the current period total. I tried CP-1 which displays the prior month number I was trying to get the previous months totals for those prior months. Thanks
0 2955 0
6/27/2017 2:50 PM

LBI Server Out of Memory    

Started by  thummel1
We have been experiencing a routine weekly outage with LBI. Users receive the message 'LBI Server Out of memory'. We were informed that it could be due to the volume of activity on the RAS Server, and suggested remedies included changing reports to not open in a Crystal Report viewer so that it bypasses the RAS Server. That was done on the reports that seemed most problematic yet the issue continues. Another suggestion was to rebuild more complex reports residing in Crystal in other systems ...
2 42373 1
by  Greg MoellerJump to last post
5/30/2017 8:46 PM

LBI Delete Parameter Values    

Started by  Katman
When updating an LBI report, I cannot delete a value in the parameters drop down list. Steps to Recreate (See attached image): Edit LBI Report Click Maintain Parameters under Data Filtering Select Parameter to update In Available Values box, check the value you want to delete. Click Delete button. Nothing happens. I am the report owner. I have also logged in using Lawson master account. I still cannot delete a value from the list. &91;img&93;/Portals/0/...
1
50077 0
by  KatmanJump to last post
5/30/2017 5:54 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 2 of 34 << < 12345 > >>


RSS Feed Available
Forums Performance Management

Group: Performance Management

Forums
Topics
Replies
Subscribers
Last Post

Smart Notification

189 635 71 RE: SQL Help by  Greg Moeller 11/9/2023 2:49 PM