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 16 of 34 << < 1415161718 > >>

Topics

Replies
Rating
Status
Views
Subscribers
Last Post

RW100 copy to Crystal    

Started By  BShort
I was just at CUE and heard that we can take the RW100 and have it copied into Crystal without rebuilding the report in Crystal after all the work was completed in RW100. How do I do accomplish this task Thank you.
6 4740 4
by  AmyVJump to last post
6/29/2011 6:19 PM

Occassional blank LBI report    

Started By  des123
We are having an annoying problem with running LBI reports. They will occasionally display blank output. The workaround is to clear out the temporary internet files, cookies, etc... in the IE web browser (Tools -> Options). I thought it might be due to not enough space allocated for temporoary internet files and cookies so I increasing the amount of allocated space to 1024 MB but this did not help. This happens on various reports so we know that it is not report-specific. One moment a the...
6 6422 3
by  des123Jump to last post
9/28/2011 7:47 PM

QuickStep Crystal Reports - How to view data    

Started By  ErikaS
Hello, For the life of me, I cannot successfully connect a Lawson QuickStep Crystal Report to my data source. Out of the box, the data source is set to rock.lawson.com. I preview the data, it prompts for parameters (which I fill out) then it prompts for data source, username and password.  I fill in the data source credentials that I want to use and I get the following: 'Failure to retrieve data from the database. A failure occurred  during the generation of schema information f...
2 4709 3
by  Ruma MalhotraJump to last post
6/14/2011 8:38 PM

Drill Around question    

Started By  George Graham
I know in Crystal Reports I can create a hyperlink using drill.jsp. And I can use query builder to get the specific drill strings. However, is there a way to do a full drill around similar to what pulls up in portal I.E., when I'm on the Employee field in HR11 and select drill I the menu of all drill arounds. I've tried capturing the calls from within portal but those calls are simply generating the drill lists and I assume the servlet is then building the form displayed....
6 7126 2
by  Fernando LabradaJump to last post
6/14/2011 8:53 PM

Filter a Smart Notification on a Dashboard Tab    

Started By  MCordero
I've created a  Smart Notification with the username field set as a parameter. I can manually add the parameters to the URL to filter it with http://.....¶mcount=1¶m0=[username]  What are the steps I need to take to dynamically show the information on a dashboard to filter according to the user viewing it  If not with username, then employeeID or possibly a specific Security Group
1 3135 0
by  Matthew NyeJump to last post
6/22/2011 4:27 AM

LBI 902 compatibility with Lawson S3 901    

Started By  Deleted User
Greetings Gurus! Is anyone running LBI version 902 with S3 Lawson Apps 901  We are preparing for an apps upgrade from Apps 9msp6 to Apps 901.  Anyone have any input on the required changes for LBI  Your input as always is much appreciated! Joanna
1 2845 0
by  George GrahamJump to last post
6/22/2011 5:36 PM

Options for export?    

Started By  Greg Moeller
Just asking a question (at least for now). Is there any option available to export an LBI report automatically to a file share  We'd like to keep a couple reports, and don't want to have the manual task of daily saving the emailed versions. Thanks for any suggestions, -Greg
4 4116 0
by  Greg MoellerJump to last post
7/12/2011 6:43 PM

Search box in framework services?    

Started By  George Graham
Anyone know how to remove the search box that shows up for LBI Since this is linked into portal both search boxes are showing up and confusing users. I'm sure I can dig and find it but thought I would see if anyone has already done the leg work. Thanks.
3 3339 0
by  Chris MartinJump to last post
8/1/2011 5:27 PM

Unable to export LBI report    

Started By  TBonney
OK, this is a wierd one... I have a user who is attempting to export the output of a Crystal report run from an LBI dashboard. The report runs fine, but just won't export for her. Also, other users are able to successfully run and export the same report & save their results locally. However, when this particular user hits the export icon, the cursor simply displays this wierd little yellow icon that looks like some sort of sunburst with a squigley red outline. But, there is no text displa...
3 3441 1
by  mark.cookJump to last post
8/5/2011 5:11 PM

Publishing ReportWriter Reports    

Started By  ric9d
Is it possible to Publish reports written in report Writer I have been searching the web for a while and I havent a clue. If it is possible Can anybody tell me how to a step x step procedure will be most welcome. Thanks!
4
3903 0
by  Greg MoellerJump to last post
8/11/2011 12:23 PM

Bursting in LBI; user is noted as    

Started By  ric9d
I uploaded a bunch of users into LBI using import files. Some of them, those who has NEVER login to LBI (even if they were given access to it) would have their user id with ''. I bursted the report to 2 people, one who had accessed LBI before and the other never had. IT did not work, the former got his report but the latter didnt. Does anybody have any idea Do users HAVE TO HAVE lbi access to get an bursted/emailed report Thanks in advance.
1 3435 0
by  Greg MoellerJump to last post
8/10/2011 4:48 PM

Options for saving Report output (file name) from LBI Dashboard    

Started By  Daksha Desai
I have a link on a dashboard that creates a report in csv so that the user can save it. How can I set a file name with a type of txt for this Location (url) is: http://vmlbisrv.domain.corp:9080/ers/ersRequestHandler.jspCMD=VIEW&INSTANCEID=LATEST&OuterWrapper=true&NewReport=true&REPORTID=35&OutputType=csv
0 4098 0
8/16/2011 1:14 PM

Publishing a Crystal Report with a SubREport    

Started By  ric9d
Can anybody tell me how to publish a Crystal report with a subreport in it If you could do it on a numbered step by step process then I would greatly appreciate it. Thanks.
0 4297 1
8/17/2011 12:42 PM

LBI Uploading Rights    

Started By  ric9d
I had several RIGHTS uploaded to LBI. Then I scheduled bursted (crystal) report. However all users are getting a 'File is corrupted of damaged' error message. Interestingly, if I manually create a RIGHT and schedule the report, bursted and all that, it works! If anyone has any idea or has encountered this issue, please, please let me know. I have created a ticket for this with Lawson Global Support, however, sad to say, they are as CLUELESS as me!
1 3259 0
by  George GrahamJump to last post
8/24/2011 2:37 AM

Solution Set for Reports - Report ID?    

Started By  George Graham
How is anyone else handling this: Report is created on test LBI and validate by users. Report is attached to a dashboard - therefore the link in the dashboard has the ID of the report in the URL. The desire is to be able to make test and prod LBI identical - and utilize automated procedures to migrate stuff from test to prod. But when creating a solution set from test and then loading it on prod, when the report is loaded on prod it loads it as a new report with new ID. So for new reports ...
1 3149 1
by  Ruma MalhotraJump to last post
8/24/2011 3:26 PM

Reporting Services: Saved Parameters Option    

Started By  WRB
Has anyone used the Reporting Services Option 'View with Saved Parameters' I am attempting to actually save a parameter but not having any luck. 1. I mark the option under Maintain Parameters 2. I run the report that has parameters 3. I complete the required parameters 4. I name the parameter set. 5. The report runs but when I go in the 'View with Saved Parameters' there is nothing there. Once I get the 'View with Saved Parameters' option to work how do I show it on the Dashbo...
0 4357 1
8/24/2011 2:13 PM

Budget Actual Reporting (K12)    

Started By  amynelson
Has anyone had to create Crystal Reports to show Budget Actual for a K12 or similar customer This particular situation is that at Year End when the GL198 is run it shows all open PO's no longer as an commitment, but as an expense. So when they run budget analysis reports for period 12, prior fiscal year all Encumbrances and Commitments are zero and Expenses are increased and Budget remaining is reduced. The problem that I am finding is that when the GL198 is run, the commitment year and ...
0 4361 0
8/26/2011 2:09 PM

Is there a way to execute a program from within Crystal Reports 2008?    

Started By  C Fritz
Hello - I am trying to find out if its possiblet execute a Windows batch file from within Crystal Reports. Does Crystal reports have the capacity to make a system call to the OS and execute a command outside itself If it does can you please explain the syntax or point me to a source that enables this Thank you.
11
12041 2
by  C FritzJump to last post
9/23/2011 6:31 PM

LBI report field overlapping    

Started By  Xin Li
We have a crystal report that has a longer field that is overlapping the field to its right. We shrank this field so that it will not overlap in crystal designer. However, when we publish the report to LBI, the report is displaying field overlapping. Anyone experienced this and any suggestiion
6 5638 1
by  Xin LiJump to last post
9/8/2011 2:20 PM

LBI timedout issue    

Started By  Xin Li
We open LBI by click link in Lawson portal. However, we encounter page cannot display error everywhere in LBI after a period of time. We have to logout Portal and login back then reopen LBI. Even if portal prompt us to login again, it still have the same issue. This problem occured after we upgraded to LBI 9.0.4.2.79.
2 4425 0
by  mark.cookJump to last post
9/9/2011 11:37 AM

Assigned role not stick with user in LBI    

Started By  Xin Li
After we upgraded LBI to 9.0.4.2.79. We found another crazy issue with LBI. In Lawson security we assigned four roles to a users. IF we go to manage users and roles it sometime show the user has four correct roles. After a while, two role disappeared from this users. Sync user and roles they may show up with four roles or only two roles. Anyone had such issue What are the solution
1 3255 0
by  Xin LiJump to last post
9/13/2011 6:03 PM

LBI Email Delivery Scheduling    

Started By  jeff-lbi
I have set up my email device in LBI, and perform a test delivery (we have also scheduled deliveries but have yet to get them) I have activated my email device as well. Which is through email, so why we don't get any other emails is confusing. When we do a test we get the following error: Unable to send content to host {0}. Simple and broad message, but just wondering if anyone had any insight Thx
3 4871 1
by  Ruma MalhotraJump to last post
9/15/2011 6:59 PM

The maximum report processing jobs limit configured by your system administrator has been reached.    

Started By  Xin Li
We have a crystal bursting to hundreds of users every month. It worked before we upgraded to LBI 9.0.4.2.79 and CRAS 12.3.0.61. Now report bursting was crashed and user got pdf file unopenable. The error is 'The maximum report processing jobs limit configured by your system administrator has been reached.' It looks like LBI just overloaded CRAS server when brusting rendering report.Google the whole internet universe and change PrintJoblimit in registry, no luck so far. Any help appreciated.
3 5489 0
by  Greg MoellerJump to last post
9/16/2011 9:08 PM

Not valid for List error message when trying to access LBI report list    

Started By  Louise I
Help! This was working yesterday and stopped working today. Also yesterday another analyst and I were looking at setup screens but do not recall clicking or changing anything. There have been other Lawson issues and a company firewall change that went in. Also, the custom group that these employees are members of was strangely missing from all the reports that used to have it in the Users lists. I added it back and that did not resolve the problem. There's also an attribute called HR that wa...
4 4486 1
by  Louise IJump to last post
9/28/2011 7:40 PM

Only Crystal?    

Started By  mcarlson
maybe a really dumb question....or maybe one that has been covered out here before....but here it is... Can SSRS (SQL Reporting Services) be used with LBI or is it required that you use Crystal Any success or failure stories using something other than Crystal Thanks!
2 3335 0
by  WRBJump to last post
9/27/2011 7:57 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 16 of 34 << < 1415161718 > >>


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