Forum: Lawson Business Intelligence/Reporting/Crystal

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.
137 Subscribed to this forum
Page 9 of 34 << < 7891011 > >>

Topics

Replies
Rating
Status
Views
Subscribers
Last Post

Bursting PDF to Dashboard    

Started By  Whitney Johnson
Trying to burst a PDF to the LBI Dashboard. The PDF report has both COMPANY AND ACCT UNIT as bursting elements, but I don't get the drop down box to assign COMPANY OR ACCT UNIT for Element for field mapping. Can a PDF file be burst through LBI Thanks, Whitney
3 4246 2
by  Roger2010Jump to last post
1/28/2014 3:35 PM

Burting by LBI Report content    

Started By  Ruma Malhotra
We have several reports that are needing to be bursted by a field on the report and we are on version 10 of LBI but we are experiencing that bursting is not working right and wanted to check with anybody out there what their experiences have been Thanks in advance.
2 3637 3
by  Susan PrenticeJump to last post
12/23/2013 8:24 PM

Upgrading to LBI 10    

Started By  ric9d
(Topic has multiple pages1 2 )
Has anyone here upgraded from LBI 9.05 to 10 I called Infor Support and was told that it would take 1-2 hours, maybe even less. And that it would just be an install on top of the existing one. Is it really that easy What should I look out for We are only upgrading LBI to 10. None of the other Lawson apps would be upgraded. Is that possible recommended Thanks!
38 7827 2
by  Chris MartinJump to last post
12/5/2013 4:45 PM

Report Schedules    

Started By  Robby
Good Morning, We're running LBI (201105) 9-0-4-2-137 We have reports scheduled nearly everyday, normally they run with no problems. However, yesterday and this morning, no reports ran as scheduled. (I have a Smart Note to alert me to this fact). Due to the nature of the reports, I needed to send them manually (so payroll could get their data). While running a couple manually, the rest of them 'started' back up and sent themselves out!! Is there a mechanism within the schedul...
4 3988 1
by  RobbyJump to last post
2/6/2014 8:55 PM

Report Auditing    

Started By  Greg Moeller
Since we are now on version 10 of LBI, I've been asked by several users to turn report auditing on. I've successfully done that and written an audit report with some of the information that the users wanted in it. My question comes in here. I turned auditing on at 17:00 on the 13th, now at 10:30 on the 15th, I already have 340 rows in the table. Can I just have my DBA strip the table of older data from the table going forward Maybe just keep a quarters worth, and strip the rest
6 4414 0
by  Greg MoellerJump to last post
3/28/2014 8:01 PM

Lawson report AM260 to Crystal cannot use csv    

Started By  Donna
The AM260 report is still in the user's print manager and he needs an excel file created. I just received this call 5 minutes ago. I used to 'crystallize' Lawson standard reports10 years ago but have not done it in recent memory. I rarely use OLEDB although I have it on my computer. Of course the users needs it tomorrow and I was going to be on PTO but I would still like to help if at all possible. I am searching for documentation on this that is newer than the article posted in the...
1 3539 2
by  DonnaJump to last post
11/27/2013 3:04 PM

LBI RFP    

Started By  Daniel
Does anyone have an example RFP for implementation of Lawson Business Intelligence that they could share. Thanks for any assistance.
0 4034 1
12/9/2013 4:16 PM

LBI without Lawson Portal    

Started By  Kate Liamero
We are having our systems moved and I want LBI to be available longer than lawson. We usually log into lbi via a link in the lawson portal but I do have the direct url for lbi. I am being told they are not sure if LBI can be up without the portal We don't want to allow users to log into the portal because we don't want any data changed. Our LBI is strictly reports only. As long as the database is up can users log directly into LBI and run their reports without the portal also being accessib...
3 3734 1
by  Kate LiameroJump to last post
12/13/2013 2:14 PM

Refreshing server for LBI    

Started By  Ronnie
I have a question and I am getting no where currently with infor support. I just want information from them but they are not getting anywhere with me and just wanting me to run fiddler etc. I feel this is an easy solution. Here is the issue. In our portal we have an area that uses xml pages. I have made a change to one of the xml files where it now uses a fully qualified URL instead of a short URL name. example...inside the XML file there is host=''> I have now changed this to say ...
6 4034 0
by  Alex TsekhanskyJump to last post
12/22/2013 9:50 PM

LBI Current User Formula???    

Started By  DanH
I am publishing an EE roster of 6000 people. I need the Manager running the report to only view employees they have access to. I concatenated a few fields where the IDs are to make the field i want touse to check the manager . i already tried the formula below: CurrentCEUsername in {Manager String} in lbi and crystal but it did not pull the data. In LBI, it kept asking the users for a default ID and PW. Can someone please assist Thanks!
3 5438 0
by  Greg MoellerJump to last post
1/2/2014 6:39 PM

Import Devices not working    

Started By  Mary Porter
We were upgraded to LBI Version10.1.12.0.179 and I have not been able to import devices since then. I am using the same device template as we did before. I checked the device type naming (from an earlier post by Greg Moeller) and still can't upload. My error is: - An error occured when attempting to save the device to the database. - The device import has completed with errors. Some devices might not have been imported. Nothing imported. Infor said they can't duplicate update to the next...
2 3531 0
by  Mary PorterJump to last post
2/13/2014 11:38 PM

Exporting as CSV creating duplicates?    

Started By  thummel1
Hi, I have a Crystal Report that contains a sub report. This report is loaded in LBI. When I choose to export the report as CSV, first, it takes like an hour (annoying), second, it creates a duplicate or triple (or more) records for each record on the report. Why are the repeated records occuring on the report We have other reports that are exported this way that also have sub reports. Any insight would be much appreiated! Thanks! Tania Hummelgard
1 3724 0
by  Dave CurtisJump to last post
1/4/2014 11:21 AM

Crystal Report for S3 Fiancial Rolls    

Started By  Randy
Not sure if this belongs here or S3 Financials. Has anyone had success customing reports that would whow accounting unit summary at highest level, then the next levels downward I'm thinking the dbo.GLCONSOL table would be a start, but wonder if anyone has completed this and how
0 3163 1
1/13/2014 8:51 PM

MM280 DistributionReport    

Started By  Nicole M
Hi I'm looking to recreate the MM280 Mateerials Report using a query, not necessarily with Crystal Reports. Probably with SQL or another tool I have. Has anyone already recreated this If so, can you provide the tables and fields I would need.
4 5768 0
by  Gary GastaJump to last post
2/7/2014 1:36 PM

Invoke report from url and have it sent as email attachment    

Started By  TRK
Hi Another challenge. I've been trying to find the information in the documentation, but my skills are not high enough to get anything useful out of the, should I say, limited documentation available. Background From time to time I receive a file, which is then imported into a SQL DB via a Powershell script. The data imported should then be sent to the user in a nice looking report, which is attached as PDF in an e-mail. The report is created and takes 3 parameters: sender, messageID and ...
2 5127 2
by  TRKJump to last post
1/23/2014 5:41 AM

ODBC 64-bit driver    

Started By  Mary Porter
We have Oracle_11g 32 bit drivers installed but new client machines are being installed as 64bit. Where's the best place to get 64 bit drivers
3 4653 0
by  Mary PorterJump to last post
2/5/2014 10:53 PM

Assign user with an access to multiple reports in Lawson LBI    

Started By  Yugandhar
Can anyone of you tell how to assigh the security access for an user to access multiple reports other than assigning report user to individual reports
1
3237 0
by  Law123Jump to last post
5/6/2014 3:21 PM

Dashboard module to new tab?    

Started By  BarbaraS
Is there any easy way to move an entire module from one dashboard tab to a new tab without recreating the module and all of the links Thanks Barbara
2 3571 1
by  mark.cookJump to last post
3/10/2014 12:03 PM

PO Comment database location    

Started By  dukeslater
On PO20.1 there is a button labeled 'Add Cmt'. Clicking it brings up an Attachments window, and under 'Comments to Print on Purchase Orders' I need to find both the Title and Text fields. My usual methods of tracking this down don't seem to work for this one. Thanks in advance for any direction you can provide.
3 4784 0
by  dukeslaterJump to last post
3/7/2014 7:19 PM

Bursting, How can I restrict one group and allow the rest    

Started By  mikeP
Just getting started with bursting. We have a report that should generally be available to all, but handful of users (all in their own custom group) should only see one work location. Playing with a simple test report, I created the element, structure, and right to restrict that group. What I can't figure out is how to allow another group full access. The only thing that jumps out is to give them a right that is NOT= 'qwzyxs' or some other string that I know is not a real work location....
4 3204 0
by  amynelsonJump to last post
3/12/2014 5:30 PM

Transaction Counts    

Started By  FireGeek21
We need to report on the number of transactions we do. I can get transaction history from the HRHISTORY. How can I determine all the transactions done directly on HR11.1, HR13.1, BN32.1 and HR13.3 Thanks!
0 3827 0
3/12/2014 8:21 PM

Automating Rights Import    

Started By  George Graham
I thought I had seen this posted before but cannot find it. Has anyone been able to automate the import of rights from a csv We want to automate the setup of LBI users entirely and know we can update the tables directly - but would rather use the import option if there is a way to automate it.
1 3386 0
by  Ken CarleyJump to last post
4/9/2014 6:51 PM

Display burst rights info in report?    

Started By  mikeP
I have a Crystal report that's bursting properly now; most users see all info, one group sees a reduced set. Is there a way I can report some bursting rights info on the report, so I could place a header similar to: 'Report limited to Fund xxx', where the xxx comes from the filter criteria placed on the right's imported structure Thanks, Mike .
3 3573 0
by  mikePJump to last post
3/19/2014 4:08 PM

LBI Data Source of Instance Queue Connection    

Started By  khart
I know where the Instance folder is on our reporting server but what type of report am I able to use that data source It is useful in any way Example: D:\LawsonDocuments\12_reportName\Instances
0 3629 0
3/31/2014 8:26 PM

LBI and Cognos    

Started By  Nabil
Hello All, I'm wondering if any of you has heard if Infor is planning to move away from SAP Crystal to IBM Cognos thanks! Nabil
2 3824 1
by  NabilJump to last post
5/6/2014 4:04 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 9 of 34 << < 7891011 > >>


RSS Feed Available
Forums Performance Management

Group: Performance Management

Forums
Topics
Replies
Subscribers
Last Post
189 635 14 RE: SQL Help by  Greg Moeller 11/9/2023 2:49 PM