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 18 of 34 << < 1617181920 > >>

Topics

Replies
Rating
Status
Views
Subscribers
Last Post

Crystal Effective Date Reporting    

Started By  John Henley
Here's a a technique for creating effective date reports from Lawson data. In particular, this is useful for reporting from HR history data, where you want a report to reflect the value of a piece of data at a given point in time, not its current value. For example, you might want to a report listing your employees their employee status as of a given date. Read Crystal Effective Date Reporting.
2 5225 1
by  NabilJump to last post
3/24/2011 6:30 PM

Lawson back Office reports in Excel ?    

Started By  Ruma Malhotra
Usually publishing back office reports allows users to download only in pdf.   Has anybody found a way to download backoffice reports in excel format We have a number of RW100 backoffice reports that are published that can be downloaded in pdf format.I am investigating ways of downloading in excel. Tia.
4 5216 1
by  George GrahamJump to last post
3/3/2011 2:31 PM

ERD Files - LBI Reporting Services    

Started By  JeanneS
Is there any documentation for the ERD files What does the PK before the field SECURITYGROUP ID represent on the ERS_SECURITYGROUPS table I need to create a crystal report that lists the members in LBI security groups. The ERS_SECURITYGROUPS table gives me the names of the tables but not the member names. Any suggestions as to how to get the member names Thanks.
2 4218 1
by  Greg MoellerJump to last post
3/3/2011 9:08 PM

User Role Based Crystal Reports in LBI    

Started By  ChrisS
We here in HR have over 100 canned reports that are being ran throughout the month (Weekly, Bi-Weekly, 1st of the Month, 5th of the Month, etc.). Previously, these reports were generated in Crystal(20) and Access(80). We'd like to move them to the Dashboard, but I'm very confused on the contraints an end user (ie. Leadership) would have. We'd like to enable Leadership to run the Crystal Reports directly from the Dashboard and have the option to export to whatever file format they wish. ...
9 7074 6
by  ChrisSJump to last post
1/23/2011 1:04 AM

Bursting of Notifications    

Started By  Ruma Malhotra
I have a row of data which captures the operator who put in that data into the system as well as the director who needs to approve the data, is there a way to burst this notification in such a way that it bursts by the director as well as the operator so that the director and the operator gets the same data using a single notification. I cannot define a delivery device for the operator since I do not know on a daily basis who keyed in that peice of data. Since in the bursting step there i...
19 4069 2
by  George GrahamJump to last post
2/23/2011 12:05 PM

2008 Server (for LBI)    

Started By  Greg Moeller
Does anyone have any summary/detailed steps for installing WAS 7, LBI, DSSO, etc on a 2008 Server that they would be willing to share
4 3119 3
by  Greg MoellerJump to last post
1/21/2011 6:17 PM

Auto-import of rights    

Started By  Greg Moeller
Is there some way to script the import of rights I can create a file with what I need to import, but don't want to go through the wizard on a daily basis. Everyone here should have at least one right imported automatically and with our ever-changing workforce, it would be nice to auto-load at least this one (or two) rights. Any ideas
9 3639 1
by  Greg MoellerJump to last post
1/21/2011 9:09 PM

Crystal 2008 export more than 65k rows to Excel 2007    

Started By  Deleted User
Has anyone been sucessful at exporting more than 65k rows of data from Crystal 2008 to an Excel 2007 format  The work around is to save as .csv and then open the file in Excel 2007.  I'm curious if anyone has found Crystal 2008.dll updates which export large record sets directly into Excel 2007
1 4479 2
by  Shane JonesJump to last post
2/2/2011 3:42 PM

Sending large Excel attachments on LBI    

Started By  Deleted User
When using Crystal 2008 ODBC reports and RAS 2008 some large excel attachments never make it to the user inbox in e-mail.  The Websphere logs show 'e-mail sent'.  The same report with a .PDF format will arrive in the end user's mail system inbox.  Has anyone experienced this LBI issue before
1 3254 1
by  Matthew NyeJump to last post
1/30/2011 6:36 PM

Added memory does not show up in reporting service    

Started By  Deleted User
I'm not sure this is the correct forum.  Our LBI server was increased from 2g to 4g ram but the 'About Reporting Services' screen still shows the old memory settings.  Any ideas
1 3542 0
by  John HenleyJump to last post
2/2/2011 7:08 PM

LBI/BPW implementation?    

Started By  Jeff House
Executives are seriously looking at combining reports from Lawson, time clocks, patient billing, nursing scheduling, and patient data systems. Based on a some internal knowledge and a little research, it appears LBI combined with BPW seems the answer. If my brief research is correct, BPW is quite new for S3 customers. If you currently use LBI for pulling in data from multiple systems, what type of full time resources do you have What's your ideal amount Anyone have BPW up and running Any ...
8 8731 3
by  ErikaSJump to last post
3/3/2011 6:32 PM

Crystal Report Filtering    

Started By  Matt T
Hey all, We are trying to setup a filter for one of our reports and we can't seem to get it to work.  We have data at different levels (Company, Territory, Region, State, Area, Zone).  We're trying to set it up so people have the ability to see what's in their area and everything under it (i.e., Zone users only see Zone data, State users see State, Area, and Zone, etc.).  Has anyone done something like this before and can provide us with help or tips on how to do it   Thanks, Matt
0 4351 1
2/8/2011 1:34 AM

Using a Custom Crystal Report with my data    

Started By  ErikaS
Hello, I'm very new to Crystal Reporting and the Lawson OLEDB connection. Another one of Lawson's clients gave me a Crystal Report file that they have customized for their reporting needs. How would I use that report with  my data through the OLEDB connection I see their formula fields and I see something that looks like they created with the Query Builder...can I/will I be able to view what they created in Query Builder I'm sorry if I'm not using the right terminology. Thank...
7 4448 2
by  ErikaSJump to last post
2/28/2011 3:37 PM

LBI Security Groups    

Started By  Tim
What table in the LBI meta model relates to  ERS_SECURITYGROUPS and identifies all of the users assigned to it I would like write a SQL query to identify the individuals that are assigned to a security group. Thanks, Tim
4 4885 3
by  Ruma MalhotraJump to last post
3/28/2011 6:45 PM

LBI Alternatives    

Started By  Lance Kelley
LBI works great for us.   However, now that more and more employees are looking for Crystal Reports to run, I'm concerned about increased license fees and increasing annual maintenance fees to include our entire (albeit small) team's access to LBI where we publish the reports.  We've been 'live' with Lawson S3 901, LBI, ProcessFlow, etc. on an in-house Windows environment (including MS SQL Server) for just over one year and looking back at our purchase price for the LBI licenses we currently...
6
4644 0
by  Lance KelleyJump to last post
3/1/2011 9:17 PM

Users and Access Ids Cascading Issue with dashboards, modules and links    

Started By  Ruma Malhotra
We had an issue on LBI 9.0.4. where the permissions or user ids set on a dashboard were cascading down to modules and links. In 9.0.4.1. lawson has changed this where they have given a user the option not to accept the cascadeing down of user access from dashboards, modules, links etc. They have done this by adding a line to modify the sysconfig file on framewrok services and adding 'PERMISSION_INHERITANCE' as false. Has anyone implemented this Any experiences/issues that you can share wo...
3 3370 1
by  Ruma MalhotraJump to last post
3/3/2011 9:10 PM

Setting a parameter based off User Roles.    

Started By  MCordero
I am working on a crystal report with three dynamic parameters, one of which I need to use LBI Roles to filter.   I've created structure called Company Number with a number element CompanyNum.  I then set up Group rights to different Company Numbers depending on the Company. (I've done before with Facility Name and bursting was successful, so I'm pretty sure this part is all correct).  I have since then tried a combination of customizing the Company Report Parameter to set equal to Reporting R...
1 3373 0
by  Matthew NyeJump to last post
3/2/2011 2:33 PM

Maximum number of pages of a report in LBI    

Started By  RoxanneS
Our HR department wants a Crystal report published to LBI that covers 24 months worth of data and runs about 15,000 pages.  Our consultant says we can't--or maybe it's that we shouldn't--send a report that large to LBI. Anyone else sending that large of a report to LBI  Is there a maximum number of pages for a single report or some reason why we shouldn't publish this in LBI Thanks!!
3 3143 0
by  RoxanneSJump to last post
3/7/2011 4:53 PM

Publish Backoffice Reports as CSV drillable    

Started By  KJBULLS
Hello, My organization wants to explore a way to publish Back Office reports as CSVfiles with drill around in LBI. Is that possible Has anyone ever done this Thanks for your help in advance! KJ
2 3631 1
by  Ruma MalhotraJump to last post
3/3/2011 2:03 PM

Custom Crystal Reports for LBI that use Commands(sql)    

Started By  gsusnme
In publishing a custom report that has a command (sql) and parameters, in LBI, the parameter screen displays, and after choosing parameters it goes to a screen to put in default user id and default password, (which has been populated in the setup), and when you enter it again it goes back to the parameter screen, it's looping.  It's as if the custom crystal and the command(sql) are treated separate, but never mesh back together.  Any one have any ideas of how to handle this  Or can LBI truly ha...
5 4435 1
by  gsusnmeJump to last post
3/3/2011 9:02 PM

Anyone Using non-Lawson scheduler to schedule, run, and distribute reports published in LBI    

Started By  Tim
Hi, We have a company standard enterprise job scheduler.  This product has the ability to run scripts, call URLs, call command-line commands, etc.    We would like to use this enterprise scheduler to schedule, run, and distribute LBI Crystal Reports to users. 1.  Is it possible to schedule, run, and distribute reports that are published in LBI with non-Lawson scheduling tool 2.  How would this be accomplished  Would we call something like the following URL to execute the report ...
3 4270 1
by  TimJump to last post
3/9/2011 8:59 PM

Mapping a crystal report that uses a sql command    

Started By  Ruma Malhotra
Has anyone been able to map a crystal report that uses a sql command that has the schema name hardcoded from one environment to another Th problem in this lies where the schema name is diffrent in 2 environments. Like for example the schema name is prod and test in 2 different envirormnrts and it is difficult to map theses crystal reports. On LBI when you publish these reports the datasource override will not work since the objects will not be found because of the schema name being hardcoed ...
2 3572 1
by  Ruma MalhotraJump to last post
3/9/2011 9:42 PM

LBI -Still Learning    

Started By  Deleted User
I see some versions LBI will be decommissioned - what exactly is LBI I know we use lawosn add-ins and Process flow but for reporting we have cognos, reportsafe.
3 3475 1
by  John HenleyJump to last post
3/25/2011 1:21 PM

Function to print crystal report?    

Started By  George Graham
Looking for a way to provide a link to print a crystal report instance without having to open it. I have not been able to find a way so thought I would ask this group.  Would need to be a client side print. I think I'm out of luck but thought I would check here first.
0 3788 1
3/23/2011 5:49 PM

LBI Security setup    

Started By  Ruma Malhotra
Just one week to CUE and I am wondering how different users have setup LBI security through the use of report security groups, custom groups, groups defined in LS9 security or through just simple user ids. Since I am not very smart, I am struggling to define best practices for setting up security that will be maintained through different LBI version upgrades, migrations to new hardware and LBI security reporting from the reporting tables to provide to business owners . Please don't go harvard...
7 5371 1
by  mark.cookJump to last post
3/25/2011 4:31 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 18 of 34 << < 1617181920 > >>


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