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 10 of 34 << < 89101112 > >>

Topics

Replies
Rating
Status
Views
Subscribers
Last Post

Default dashboard view    

Started By  Ronnie
Ok...So I am setting up our Lawson dashboards for our Lawson 10 we are going to implement. We are coming from 9. Is there a way to set individual portal roles to have a certain dashboard tab show up as the main home tab that opens when they log in I have two created for our regular employees, but the additional tab is the one that is defaulting when they open up lawson. I have a main one created that I would like to default open when they log in. Where is this set
4 3837 0
by  RonnieJump to last post
11/12/2013 7:51 PM

LBI v 10.1.x cosmetic change    

Started By  Greg Moeller
In LBI version 10, we are noticing that the dashboards background is a deep blue/navy blue and the selected dashboard text is black. Anyone know which specific file this is controlled from We'd like to change the selected dashboard color.
10 3931 1
by  Matthew NyeJump to last post
11/11/2013 3:48 PM

LBI Uploading RIGHTS using CSV file --- Description is not uploadable?    

Started By  ric9d
I checked the CSV file format specs to upload rights, it doesn't have one for 'Description'. Does anyone have any idea Thanks in advance.
3 3208 1
by  JeanneSJump to last post
11/6/2013 5:51 PM

Querying PR35.2 versus PR36    

Started By  clb393
is there any way i can query the data on each form separately If not, is there a field indicator which would distinguish the two Thanks, Chris
0 3575 0
11/4/2013 1:13 PM

What to use for reporting financials in S3    

Started By  Melissa
I'm curious what others are using for reporting financials. we have been live on lawson since january and the report writer in lawson is great for the style 1 type balance sheet and P&L reports. However, being in healthcare we have a lot of need for slicing and dicing our accouting unit information and building all the calculations and groups etc that have to go into creating it is tedious. and then keeping track of them all in case something changes is almost impossible. Crystal reports is a ni...
15 7941 6
by  Chris MartinJump to last post
11/1/2013 4:56 PM

Direct reports in non-Lawson report    

Started By  Greg Moeller
Investigating ways to deliver a report via LBI to a select group of managers within our IT department based on their direct reports... Problem is, this is not a Lawson report, it is coming from our Help Desk application database. The database contains employee names. We've hard-coded the names and got a report that works, but it is all manual now as we have to go in and select the manager, run the report, export to pdf, and repeat for the next manager. Can I just build a ri...
1
3599 0
by  Greg MoellerJump to last post
10/30/2013 7:10 PM

The Value of RW100    

Started By  JonA
Can someone give me an overview of RW100 How is it used From what information I've gathered it seems to be a Financial reporting tool. Does it have any applications for supply chain/procurement What information can it provide that I can't get with Crystal Is it easier than Crystal
3 3921 0
by  JonAJump to last post
10/30/2013 6:31 PM

LBI back office report error.    

Started By  Justin R
I have a CU201 job in lawson. It is running and building instances (under C:\LawsonDocuments\147_CU201\Instances) of the back office report on the LBI server but when I try to view the latest instance it gives an error. Message: C:\LawsonDocuments\147_CU201\CU201.lxr (The system cannot find the file specified.) I can go in a view historical instances. I am new to this but I've got it to work before but I am testing a second report and haven't gotten it to work yet.
2 3545 0
by  Justin RJump to last post
10/24/2013 1:37 PM

Passing parameters to report through url    

Started By  George Graham
Trying to set up some reports to run as 'scheduled' every other week so setting them up in windows task scheduler to submit the URL and create a new instance, I have that working fine, including the login, but the report has parameters - and when I try to pass the parameters in the URL it still brings up the window and asks for them to be filled in. Version of RS is 10.1. Here is what is being passed as part of the string: &FiscalYear=2013&AccountingPeriod=4 Those are the parameters define...
3 3992 0
by  George GrahamJump to last post
10/23/2013 11:06 PM

What table has field SKI_DATE_LST_USED    

Started By  Donna
PA21 Identifies the Received Date as SKI_DATE_LST_USED when CNtrl Shift O is used but I cannot identify the table. Need help locating the field. Thank you. Donna
6 4265 2
by  DonnaJump to last post
10/8/2013 7:24 PM

Historical Report Instance and bursting    

Started By  James Deno
I'm wondering if someone could help me to understand how bursting works when applied to a historical instance of a report. I have a crystal report that is bursted based a field in the report (user ID) so they can view their page only. The bursting works fine when you select 'view the latest instance', however, once a historical instance is created from the scheduler, it prompts for a user ID and password. If you enter the UID and password at the prompt, it opens the report, but managers a...
3 3439 0
by  Greg MoellerJump to last post
10/7/2013 3:10 PM

Scheduled Report - must login to view    

Started By  Roger French
LBI 9.0.2 on Windows 2003 Env: Unix, with Oracle DB In reporting services dashboard, when there is a *scheduled* report, the viewer logs into Reporting Services initially. Then the viewer must log in again with Oracle credientials to actually view the *scheduled* report. Is this the way it's supposed to work Having to log in twice to view a scheduled report(Sorry I did not set up this instance of Reporting services). For regular, published reports, the user only need to log in one time. -R
15 7758 2
by  Rob MarshallJump to last post
10/4/2013 4:59 PM

lbi blank rows    

Started By  AJP
Hi Have had issues when the created and saved crystal report which is exported using LBI on a timed session to a user sent by email Every time one is sent - it seems to merge some cells and include blanks on rows and columns periodically Any ideas on how to remove this issue would be good I have tried not suppress & ensure there are no gaps between fields etc Thanks
1 3445 0
by  RobbyJump to last post
10/1/2013 2:46 PM

LBI and SSL    

Started By  George Graham
I'm missing something right in front of my eyes. Setting up SSL for Lawson environment and have SSL for Lawson application server working fine. But can only get http://lbi/efs/go to work - not https://lbi/efs. SSL has been set up on the LBI sever and installed in WAS. But https just not working. And http still is - logs in just fine. BIggest issue is that lbi is integrated into portal roles as the home page and getting the popup to accept unsecured data with lawson being setup correctly. ...
0 3944 3
9/29/2013 8:00 PM

LBI: Report Events    

Started By  Robby
Reporting Services offers 4 types of 'Report Events'. These are defined in the UG as a 'user exit that allows for a specific user-defined report task to be performed at a predetermined time.' The one example given is that of a logging program which tracks the amount of time it takes for the report to run. Is anyone out there in Lawson/Infor Guru-land using this feature Can you share a business application that you find useful for this Thanks for your time! -Robby
2 3430 1
by  RobbyJump to last post
9/17/2013 5:09 PM

Reporting Services - Why would you publish a Non-RPT File    

Started By  Robby
OK, So I've just now realized that there is a selection called 'Non-RPT' File when you go to upload a report in Reporting Services. I looked in the Infor KB to see if something would give me a hint as to when you would want to do this. Seems that you can upload a word doc or excel file (). I can't think of why you would want to Is anyone doing this and why (what is the Business Need) Thanks! :confused:
3 4565 1
by  dcaianiJump to last post
9/13/2013 7:25 PM

New service for reports on the dashboard    

Started By  Nancy
I am trying to set up a new service that we can use to point to html programs for our dashboards. Ever since we went live our dashboards have the full url to the XHRNET program it is calling. I have been told that we can set up a new service to replace the commom portion of the URL so that if it changes (which we are on the second round of changing) - it only has to be changed in one place. I would like to know what goes in the different fields on the new service screen and what do I ...
2 4315 1
by  NancyJump to last post
9/5/2013 6:32 PM

Scheduling a Group of Reports    

Started By  pnaq1120
I was looking to get some help regarding scheduling in LBI. We have about 60-70 reports that we are scheduling at different times each month and was hoping there is a way where these can be scheduled all at once instead of going in to each report one at a time and changing their run times individually.
1 3313 1
by  Matthew NyeJump to last post
8/26/2013 4:16 PM

query builder timeout    

Started By  Justin R
When ever I click to expand the users to see the jobs it waits for a minute or 2 and then says it can not load. Is this some security issue Another user can expand it just fine.
0 3605 0
8/14/2013 7:19 PM

LBI crystal report with link to Portal Form    

Started By  JeanneS
How do you create a link in a Crystal Report that is published on a dashboard to link to the Lawson Portal  I have a report that contains PO information and I want to create a link so when the user clicks on the PO number it takes them to the PO20.1 form with the PO number from the report auto populated in the PO20.1 form. Thanks!
3 5130 1
by  Nirav BhattJump to last post
7/22/2013 6:01 PM

Cannot update Crystal Report in LBI    

Started By  dcaiani
Good afternoon, We have a Crystal report, data source is a view built by our IT department. When I run it in Crystal I can get it to refresh after inputting new parameters (date range). I publish it in LBI and I can get to the report via the dashboard, but when I try to refresh and enter a new date range I get the following error message: Failed to open the connection. Failed to open the connection. EE Listing by HM AU with parameter {9C50237D-53A6-411C-A755-7C6B10D036D5}.rpt We have a...
2 3944 0
by  dcaianiJump to last post
7/16/2013 11:58 AM

LBI report prompt for username and password    

Started By  Xin Li
I have a strange LBI report porblem. I can open the report with 'View with Data Refresh'. However when open the report 'View Lastest Instance' it prompts for username and password. I republished the report, it still has the same issue. However, when I publish the report as a new LBI report, no problem when 'View Latest Instance'. Any help greatly appreciated.
2 4601 0
by  imtyJump to last post
7/15/2013 10:11 PM

LBI report output to Excel - unwanted merging of cells    

Started By  clb393
Hello! I've created a report in Crystal 2008 which displays perfectly when exported to Excel. However, when this same report is uploaded to LBI, and then opened in .xls format, cells are being merged. Is there a setting so that i can have it output exactly as it is doing in Crystal Thanks, Chris
1 3024 1
by  SimoneJump to last post
7/9/2013 6:34 AM

Help with LBI dashboards and crystal reports    

Started By  Steven
We recently purchased LBI so we are still very new to this tool. We have several reports that we need to build right away but don't have the skillsets in house just yet. Can anyone recommend some vendors that I can talk to
5 3757 1
by  mark.cookJump to last post
7/8/2013 10:47 AM

CR hyperlink opening in same window, window keeps shrinking    

Started By  mikeP
We have a system of 10 reports set up like a mini-web site, the reports link back an forth to one another in a variety of ways. All the reports are published in LBI with 'Same window' selected for the Hyperlink Targets setting in the report's Output Options. This is the way we want it, and it works well except for one issue: Every time a hyperlink is clicked to invoke another report, the client area in the CR viewer adds another narrow margin, which in effect make the border around the ...
3 2795 0
by  Matthew NyeJump to last post
7/2/2013 6:25 AM
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 10 of 34 << < 89101112 > >>


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