Forums
 Topics
 Replies
 Last Post
179 Topics and 618 Replies Smart Notification  179  618
RE: Deliver LBI report in...
by  Mark Petereit
11/01/2017 6:54 AM
179 618
RE: Deliver LBI report in...
by  Mark Petereit
11/01/2017 6:54 AM
Search this forum:
Search
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 9 << < 56789
Topics
 Replies
 Views
 Last Post
1 Replies and 11381 Views XTRA: parameters  11381  1 Started by  Deleted User Scenario: I am trying to build a Report in Crystal XI from a Lawson report. Customer runs a Lawson Report, I pick up the data using a 'xtra:... ' Lawson Query that the user has provided. Once the report is successfully developed, the customer would like to run the same report against similar Lawson Reports which may use a different Department etc. To accomplish that I would like to create a parameter which allows the user to choose which values are used in the 'xtra' command for the following...
1 11381
by  Matthew NyeJump to last post
09/27/2006 4:25 PM
4 Replies and 11091 Views Training requirements  11091  4 Started by  Deleted User I have a report developed that is showing the each course (PATRNHIST) as a column, and the employee's as a row. Now, each column(course) per employee is listing (or, not) the Completion date per course. Question, with this layout - How can I include the Status field (PATRNHIST.COMPLETE_STATS) in a new column right after the complete date, and be sure that this 'F' (code for complete) is for that particular course
4 11091
by  Deleted UserJump to last post
09/22/2006 12:47 PM
1 Replies and 11722 Views BOE XI FTP's in binary instead of ASCII  11722  1 Started by  Carlotta McCormick Has anyone ever tried to run a Crystal Report on Lawson's Oracle tables through Business Objects Enterprise XI, and then tried to use BOE XI to auto-FTP the file back to Lawson I'm trying to use this process to create an interface file, but the file gets transferred back to Lawson in binary (EBCDIC) format and it needs to be ASCII. I can't find anything on BO's website, and I've had a ticket open with them for over a month, with no luck on their end. They reference Data Integrator to fix the...
1 11722
by  JesseJump to last post
08/30/2006 12:02 PM
4 Replies and 12156 Views ..custom report/parameter pages in LBI 9..  12156  4 Started by  Jesse We are currently upgrading our LRS environment from LRS to LBI 9. Our LRS environment was on Windows 2000 with Tomcat as the HTTPd. Our LBI environment is on Windows 2003 with WebSphere as the HTTPd. In LRS we used custom report pages to provide a user with parameters that are then fed into Crystal reports upon run-time. The custom page was a .JSP that would call a SQL Server DB residing on the same box as LRS to query for parameters. The user would then click submit, and the report ran with the...
4 12156
by  JesseJump to last post
08/30/2006 10:06 AM
3 Replies and 11013 Views Formula Field  11013  3 Started by  Deleted User Hey John - or anyone! I am using a formula field to display 'N/A' text on a bad date in lawson review - but thought I had it set to give me the Nth Largest of a review Date. It doesn't. Here is the formula: if{REVIEW.ACTUAL_DATE} = CDateTime (1700, 01, 01, 00, 00, 00) then totext ('N/A') else totext({REVIEW.ACTUAL_DATE},'MM/dd/yyyy') It returns good data, and adds that feature for the 'N/A' but I noticed on quite a few employee's that it does not give the most recent dat...
3 11013
by  John HenleyJump to last post
08/17/2006 2:54 PM
2 Replies and 11555 Views LBI Configuration  11555  2 Started by  Deleted User Has anyone found any good background information on LBI configuration Lawson help tells us how to configure services but not what they are, what they are used for, how they work etc. When things go wrong, it's hard to debug without background knowledge. For example, we've created attributes and grouped reports into lists. Now we are trying to attach a report list to a dashboard module. If we just paste the list's URL, the user is prompted to login. We are supposed to be able to c...
2 11555
by  Deleted UserJump to last post
08/15/2006 9:44 AM
5 Replies and 11398 Views Printing just summary from Crystal  11398  5 Started by  Deleted User I have a report that summarizes every employee's PRTIME transactions - comes out to 263,000 records. The problem is, I suppress the detail and just want to print the Grouped Sums...every time I try to export to .CSV it brings all the detail...Help! Thanks!
5 11398
by  Matthew NyeJump to last post
08/14/2006 3:34 PM
3 Replies and 11151 Views Command in Crystal  11151  3 Started by  Deleted User I am currently developing an Employee Review report - linking 3 tables (EMPLOYEE, PAEMPLOYEE, & REVIEW) now I want to add a command to just provide an Employees most recent Last Review - does this look correct Also, will adding a command along with tables that are linked - jeopardize the report at all Here is the command: SELECT REVIEW.EMPLOYEE, REVIEW.ACTUAL_DATE, FROM LAWSON.REVIEW REVIEW, WHERE REVIEW.ACTUAL_DATE = (SELECT MAX(REVIEW.ACTUAL_DATE) ...
3 11151
by  John HenleyJump to last post
08/10/2006 11:04 AM
5 Replies and 11927 Views Pasting Query to Add Command  11927  5 Started by  Deleted User I tried adding this command: SELECT 'employee.company', 'employee.employee', 'employee.last_name', 'employee.first_name', 'employee.middle_init', 'employee.emp_status', 'hrhistory.beg_date', 'hrhistory.date_stamp', 'persacthst.action_code', 'hrhistory.a_value as historical_job_code', 'hrhistory.seq_nbr', 'jobcode.description as historical_job_description' FROM 'hrhistory', 'persacthst', 'employee', 'jobcode' WHERE 'hrhistory.act_obj_id' = 'persacthst.obj_id' AND 'hrhistory.compa...
5 11927
by  Deleted UserJump to last post
08/02/2006 9:11 AM
6 Replies and 17297 Views Report for Lawson HR User Fields/Field Codes (PADICT)  17297  6 Started by  John Henley Sometimes it's necessary to see what field number(s) are used internally Lawson HR for which fields (including user defined fields) in order to know which FLD_NBR to select from HRHISTORY. This information is stored in PADICT. Here are two reports I use to lookup the field numbers, one for standard fields, the other for user-defined fields. You will need to 'Set Datasource Location' in Crystal to point these reports to your database.
6 17297
by  John HenleyJump to last post
07/19/2006 9:32 AM
1 Replies and 11909 Views Multiple Data Sources for report  11909  1 Started by  Deleted User Hello there! Currently we use PMM for our MM/Purchasing Suites, and Lawson for GL. As it stands we are generating 5 monthly reports that show (1)Receipt Accruals - PMM, (2)Invoice Distribution - PMM, (3)Issues Summary(stock items) - PMM, (4)GL Transactions - Lawson, & (5)Reconciliation. These five go the acct user as a .CSV which is then uploaded to Access, and finally displayed in Excel using embedded Macros and Formula. There are 5 tabs, and each sheet represents the above mentione...
1 11909
by  John HenleyJump to last post
07/16/2006 8:27 PM
1 Replies and 11536 Views Reporting environment question  11536  1 Started by  Deleted User Im am using a host of tools (Report Writer, Crystal, Access) to report data against Lawson HR and Financials. However, as I get more and more complex requests, I find myself massaging the data alot in the MS Access enviroment to meet some of my reporting requirements. Id like to understand how other practitioners have their reporting environments setup. Do you use Lawson's data mart solutions Or have you built a custom DW What are the challenges you still face with your solution ...
1 11536
by  Chris MartinJump to last post
07/08/2006 4:53 PM
1 Replies and 11462 Views Lawson LRS Server Can't see instance of report  11462  1 Started by  Kate Liamero We are creating instances of large financial reports and pointing the dashboard links to the latest instance of the report and getting the following error: com.crystaldecisions.report.web.viewer.CrystalReportViewer Error in file d:\LawsonDocuments\{74611693-5D8F-4A43-A680-65960C5F0859}.rpt:The request could not be submitted for background processing. Does anyone have any idea Thanks Kate Liamero
1 11462
by  John HenleyJump to last post
02/14/2006 4:41 PM
2 Replies and 12306 Views For the Love of Chr..t  12306  2 Started by  Deleted User We are being told that LAWSON must come out and install Ent. CR on our server. WHY this seems fairly straightforward. &91Note sarcasm with 'straightforward' and Lawson in the same post&93 Is there any exp. of someone who puts ECR on a server box and runs it against Lawson. I'll worry about the security intertwining later {read - next productline build} Thanks...
2 12306
by  Deleted UserJump to last post
01/27/2006 10:55 AM
2 Replies and 12252 Views from where i can find activity name  12252  2 Started by  Deleted User i am using table mmdist table for details.But as it having only activity code and accounting_category code.,But i also wants activity name and accounting category name also in my report. Inwhich table i canget them and how i can relate them to mmdist
2 12252
by  John HenleyJump to last post
12/14/2005 5:45 PM
0 Replies and 12743 Views Lawson Business Intelligence 9.0  12743  0 Started by  Jason Beard Has anyone downloaded and installed this yet Does it give the users a friendlier interface for applying 'VTS'. I took the example .jsp/.js files and modified them to use web user attributes to determine which data a user can see in a report, but it would be nice for the end users to administer this similar to the current version of Report Broadcasting. Thanks Jason
0 12743
11/18/2005 3:01 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 9 << < 56789


RSS Feed Available