Forum: Lawson Business Intelligence/Reporting/Crystal

 136 Subscribed to this forum
Page 29 of 34 << < 2728293031 > >>

Topics

Replies
Rating
Status
Views
Subscribers
Last Post

Upgrade Question for LBI?    

Started by  Ruma Malhotra
We have upgraded LBI 9.0.2.2 to 9.0.3.1. Since we also went from a 32 bit environment to a 64 bit enviroment on oracle I was wondering if anyone has gone through a similar upgrade and what happens to the LBI schema which was previously on 32 bit and now upgraded to 64 bit. Also&160; is ther any changes on the naming for the instances on 9.0.3.1 and how does this sync up with instances refreshed on 9.0.2.2. tia.
0 3316 1
4/6/2009 1:11 PM

LBI implementation timing    

Started by  Deleted User
We have LBI version 9.0.1.7.26 &160;that was purchased a while back and we are thinking of implementing this soon. We are currently going through LSF 9 migration on Windows and will be moving to apps 9 by May 2010. Would it matter if we did LBI before we did apps 9 or would it be best to wait until after
3 3629 2
by  Phil SimonJump to last post
4/3/2009 11:54 AM

Setting DataSource in Smart Notification    

Started by  Deleted User
I installed LBI 9.0.3 on our current windows environment running on LSF9.0 and WAS 6.1.17.&160; I was able to setup datasource in RS but not in SN.&160; I am using the following for the JDBC connection com.microsoft.jdbc.sqlserver.SQLServerDriver. When I do the test settingsI am getting the following message Test of Data Source Failed! com.microsoft.jdbc.sqlserver.SQLServerDriver. I am also not able to setup data source using DME connection also.&160; Did I miss anything during the in...
1 3706 0
by  Matthew NyeJump to last post
4/1/2009 12:15 PM

LRS- Report question    

Started by  mallgor
Hello- We are using LRS and Crystal 10. I have a report that is publihsed to a LRS dashboard but I&160;cannot locate the&160;Crystal&160;RPT file. How can I determine the location of the rpt file for this published report
1 3881 0
by  Matthew NyeJump to last post
3/27/2009 7:41 PM

SQL to link APDISTRIB to PO line Details    

Started by  Peter Brayton
Hello, &160; Has anyone successsfully linked apdistrib records back to the PO line items that make up that amount specific amount, i.e. Qty X Price = Ext amount&160; I have had some success, but not consistent success with all PO's.&160; Just checking to see what level of success others have had. Thanks.
2 3787 1
by  Peter BraytonJump to last post
3/27/2009 1:27 PM

How to show better report description in dashboard    

Started by  Jan
I have some labor distribution reports I'll be publishing every two weeks and this historical reports will stay in the dashboard.&160; We'd like the report description to show the reporting period the report is for.&160; Is it possible to do this without re-creating new portal and LBI jobs each time I run the report
6 4020 1
by  JanJump to last post
3/25/2009 6:10 PM

Invoice comments report    

Started by  Ruma Malhotra
Has anybody tried to query the invoice comments table to create a report.
2 8645 1
by  Peter BraytonJump to last post
3/25/2009 12:30 PM

Easiest way to create Balance Sheet in Crystal from Lawson    

Started by  Deleted User
I am a strong Lawson user, but average when it comes to Crystal.&160; What is the easiest way to create a Balance Sheet and Cash Flow statement in Crystal using Lawson tables
4 4629 2
by  John HenleyJump to last post
3/20/2009 6:49 PM

LBI Report Scheduling Options    

Started by  Jan
I&160;have a series of reports which I want to run following each of our biweekly payrolls.&160; However, the LBI scheduler only has monthly and single week scheduling options.&160; I don't see any way I ran run a report every other Friday, for example.&160; Does anyone have a workaround for this, or is there something I'm missing here
4 8179 1
by  lagapisJump to last post
3/18/2009 4:53 PM

Daylight Saving patch    

Started by  Vito Amatulli
Has anyone applied the Daylight Savibng patches for LBI&160;yet If so, what option(s) did you select&160; We are on IBM WebSphere Application Server - ND, 6.0.2.11 and&160;version 9.0.10 of LBI.&160; The IBM&160;site is a bit confusing and it appears that we have multiple choices. Any suggestions would be welcome. Thanks, Vito.
1 3305 0
by  Chris MartinJump to last post
3/14/2009 2:31 AM

Crystal Report Viewer    

Started by  vc727
Is there a way to hide the group tree as the defult when I open a report on a dashboard Also related to that can I set the display to be anything other than 100
3 4649 2
by  Chris MartinJump to last post
3/13/2009 2:02 AM

Relate arapplied to oeoinvoice    

Started by  TracyO
I&160;have a Crystal report using OeInvoice (this report also includes oeinvcline &&160;oeinvcmisc)&160; I need to add the date this was paid in AR and the due date. &160;I think I&160;need to get from the arapplied table to the oeinvoice table, but I need some common link in between the two. The oeinvoice file has the invoice nubmer in two seperate fileds and the arapplied has them comgined in one field so I&160;can not link on that common field. Has anyone linked these tables or kn...
4 3786 1
by  John HenleyJump to last post
3/12/2009 1:39 PM

Dashboards & Modules For New Instance of LBI    

Started by  Ruma Malhotra
We are in the process of creating a new environment for LBi. This new environment involved a brand new instal of LBi which was completed and the oracle schemas for reporting services and frameweok services were also copied. We have now noticed that we go into the dashboards it is missing certain modules and reports. So the solution to this issue is to export and import dashboards. When we try to import dashboards, what framewrok services is doing is trying to rename the ids of these contents an...
6 5235 2
by  Lenny MurneyJump to last post
3/11/2009 9:58 PM

Publishing LBI / Crystal    

Started by  Joe O'Toole
We recently installed LBI and I'm looking for a way in LRS / Crystal to create reports that are written to disk. I've heard that some versions of the Crystal server can do this, but I’m told the version of this that Lawson OEM’s with LRS does not have that functionality and that LBI&160;can only publish to a printer or email device. It was my understanding that Lawson was positioning LRS / Crystal&160; as the “new technology” offering for users who wanted to get away from RW100 and HR Writer. ...
15 6911 1
by  Joe O'TooleJump to last post
3/11/2009 8:39 PM

Viewing Reports from Portal    

Started by  jellis
Hi, We use bookmarks in Portal to view reports on our old LRS server. They use a link like- http://server.com:18001/efs/FSRemotefsid=RS:RS-Lawson LRS/LBI Server:806 Is the the fsid the SID etc I&160;have tried a similar link to the new LBI box and also used a link like- http://newserver.com:9080/ers/ersRequestHandler.jspDisplayReport=true&CMD=VIEW&REPORTID=25&INSTANCEID=LATEST with different permutations, and still no luck. What am I missing I&160;have been sifting through...
18 8236 2
by  jellisJump to last post
3/10/2009 9:48 PM

RNI Aging report    

Started by  Ruma Malhotra
Has anyone created a RNI aging report can you shaer what is the quickest and easiest way to create this report Thanks, ruma.
2 5308 0
by  Ruma MalhotraJump to last post
3/2/2009 5:48 PM

Websphere 6.1 Fix Packs-What Version?    

Started by  jellis
Hi, I originally tried to run with FP 21 from IBM, but there was a change in the ODBC driver that is included with Websphere and it broke ODBC connectivity. I&160;did find that there is a minor rollback, but I&160;find that kind of sloppy and would just like to run with the most current complete FP without having to piece it together. What is the latest-no broken FP available that will run with LBI Are you running it Thanks.
7 3808 3
by  Matthew NyeJump to last post
2/27/2009 6:34 PM

More Performance from LRS    

Started by  jellis
Currently we have a single LRS server with plenty of memory and CPU power but reporting is dismal and takes forever. The server with max users on it only hits 1-3 utilization. Currently we have limited the maximum RAS allowances to 60 reports at once since it crashes the RAS service with anything more. Since I am new to Lawson and just started working on this box yesterday here is what I have done to increase performance- This is CRAS 10, Tomcat 4.06 on a Windows 2003 server SP2. For T...
15 5718 1
by  Greg MoellerJump to last post
2/26/2009 3:35 PM

LBI Installed    

Started by  jellis
Well I&160;have managed to install LBI (efs,ers, and sn) on Websphere 6.1 FP13 with CRAS VI R2. I&160;can login and publish reports, but when I run them I&160;get an error that the file could not be found. Below is my Websphere log- com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: The device is not ready. ---- Error code:-2147467259 Error code name:failed com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: The device is not ready. ---- Error code:-21474672...
21 15277 3
by  jellisJump to last post
2/23/2009 9:21 PM

Access Lawson tables in MS Access    

Started by  Petter
(Topic has multiple pages1 2 )
Hi, Is there any way of accessing Lawson tables via MS Access Either via DME calls or ODBC/OLE-DB &160; Petter
29 21937 4
by  cmarcousJump to last post
2/7/2009 12:49 AM

LBI Documentation Help    

Started by  AG
I have been searching (if that’s what you can call it)&160;through the MyLawson support pages to no avail! God do I hate that site, I can NEVER find what I am looking for! In LBI I want to display a Crystal report and then have that report only display the current logged on user's data on that report. The field on the report that I want to use for my report filter&160;is 'major purchase class'. I currently have the report setup and displayed on the dashboard, that part works fine. I just...
8 6829 2
by  Matthew NyeJump to last post
2/3/2009 6:29 PM

Heirarchial reporting using RW100    

Started by  Ruma Malhotra
We are using attributes defined on every accounting unit to group it as a management heirarchy in the organization. For eg every accounting unit has a Director, Sr. Director, VP and Sr. VP. This helps us to group all accounting units to belong to a director which then falls under a sr director, which falls under a VP and then under a SR VP. Using the consolidated option for report writer we use it to look at the totals for a VP. But the report writer's limitation is you can use it only for one ...
9 4958 1
by  Kim92Jump to last post
2/3/2009 2:41 PM

LBI/Crystal cascading parameters    

Started by  Deleted User
I have a report that has several parameters; two of them are Boolean. I set them up with descriptions so they don't just say True or False. If you use it for a while (in testing), when you click the drop-down, you don't just see my 2 descriptions, you see a list of True, False, True, False, etc. Screenshot attached. Has anyone else had this issue and did they find a resolution Thank you.
6 4701 1
by  Deleted UserJump to last post
1/26/2009 6:40 PM

LBI user id / password question    

Started by  Jan
LBI userid/password question When I develop a Crystal report to later be published into LBI, I use my own user id/password.&160; When the report is ready to publish, I want to schedule that report to run and publish over the weekend.&160; When the report is scheduled to run in production, though, I don't want to leave my userid/password in the schedule for various reasons - such as the fact that my password will change periodically, or -- if I leave my position, my userid would be disabled. ...
7 4687 3
by  Matthew NyeJump to last post
1/22/2009 9:33 PM

LBI 9.0 Elements and Structures    

Started by  Deleted User
We want to burst a report on our new dashboard. Can anyone give me a clear explanation of what Elements and Structures are/do The documentation is vague. Any replies would be greatly appreciated!!!
3 3759 2
by  Deleted UserJump to last post
1/22/2009 3:58 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 29 of 34 << < 2728293031 > >>


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