Forums
 Topics
 Replies
 Last Post
180 Topics and 623 Replies Smart Notification  180  623
RE: Formatting of Blank D...
by  thummel1
02/07/2018 11:03 AM
180 623
RE: Formatting of Blank D...
by  thummel1
02/07/2018 11:03 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 4 of 5 << < 12345 > >>
Topics
 Replies
 Views
 Last Post
0 Replies and 1518 Views IA150 Incremental Load - SSAS  1518  0 Started by  Scott H Hi - Not sure this is the correct subforum, but I was wondering if someone could help with a question regarding the options in running and incremental data load in IA150. The options are: Build Cube: Y/N Process Cube: Y/N Fact Table Options:&160;C/I/N (obviously I here) Create All Dimensions:&160;Y/N We've run a complete load with all setting set to Y. We ran an incremental load after entering some changes in Lawson with all options set to Y and Fact Table set to I (Incremental). Proble...
0 1518
10/23/2009 1:16 PM
0 Replies and 1311 Views LBI Roundtable Webinar  1311  0 Started by  John Henley Absolute will be hosting an LBI Roundtable Webinar tomorrow (Thursday, Oct 22, 2009 1:00 PM - 3:00 PM CDT). Click here to register
0 1311
10/21/2009 1:04 PM
19 Replies and 7555 Views Wanting to use Crystal Reports  7555  19 Started by  Monica I was wondering if I can get some&160;expertise and opinion regarding using Crystal Reports. I would like to move away from creating reports using COBOL for obvious reasons. (Our company utilizes crystal reports in other departments&160;and have&160;been told we do have a crystal reports repository.) I have not used crystal reports myself so I am only familiar&160;with what I have seen at CUE this year and I am excited to move forward. I am the programmer analyst for our purchasing departme...
19 7555
by  riegerjJump to last post
10/06/2009 1:30 PM
3 Replies and 1400 Views Users attached to Rights  1400  3 Started by  Ruma Malhotra We have more than 350 rights in LBI that are present. I have written reports that tells me by which structure, which rolee are attached to which elements. However I cannot find which users are attached to which right in LBI. Has anybody found an eaier way of getting this information tia ruma.
3 1400
by  Ruma MalhotraJump to last post
10/05/2009 10:21 AM
1 Replies and 1314 Views HR Index EMPSET3 Report Issue  1314  1 Started by  mark.cook I am using the following query in OLEDB to pull data for a report of HR demographic data. I have information in a user field (user field 98), when I attach the index EMPSET3 it is pulling data from another user field. Without the index the report is pulling the proper data, just running a little longer than I would like. Has anyone seen this issue before dmeROD=PROD&FILE=EMPLOYEE&FIELD=EMP-STATUS;EMPLOYEE;FULL-NAME;FTE-TOTAL;STAND-HOURS;EXEMPT-EMP;SHIFT;SUPERVISOR;SUPERVISOR-IND;C...
1 1314
by  John HenleyJump to last post
10/03/2009 6:07 PM
2 Replies and 1866 Views crystal training  1866  2 Started by  MARCO3535 I have been asked to recommend a company- person - to help train a small group of employees &91;varied experience&93; who will going to be using the crystal reporting writing tool in conjunction to the upgrade to Lawson LSF9.0 What trainers have you used & what was your experience Appreciate any input. I currently work in the Philadelphia-S JERSEY metro area Thanks
2 1866
by  muffntufJump to last post
09/28/2009 4:04 PM
1 Replies and 1119 Views ERRORS :Smart_Notification_Installation_Validator  1119  1 Started by  HD Could anyone help me take a look at my report and point me in the right way
1 1119
by  Jimmy ChiuJump to last post
09/24/2009 12:02 PM
1 Replies and 1447 Views LBI on Vmware  1447  1 Started by  mark.cook We are looking at vritualizing our LBI machine, has anyone been successful doing a physical to virtual copy or does this require a new install and build
1 1447
by  Jimmy ChiuJump to last post
09/21/2009 3:05 PM
0 Replies and 1469 Views Cash Codes  1469  0 Started by  muffntuf Is there a better way to get the cash code (they require the report run by cash code parameter) than to join on GLTRANS.COMPANY = CBCPYCASH.COMPANY&160; I don't see any other possible join - maybe there is an in between table Thanks!
0 1469
09/18/2009 12:20 PM
1 Replies and 1253 Views Indexes to access  1253  1 Started by  muffntuf Hi all, Any indexes I can use to help speed up AR and AP Distrib reports Thanks!
1 1253
by  NormJump to last post
09/18/2009 11:28 AM
3 Replies and 2343 Views Associate a APPAYMENT Invoice with GL Trans  2343  3 Started by  muffntuf This is a hard association I am finding. I need to associate a APPAYMENT Invoice with a GLTRANS transaction(s). &160;Has anyone done this&160; If so, how do you accomplish it Thanks!
3 2343
by  muffntufJump to last post
09/17/2009 3:27 PM
1 Replies and 1439 Views What am I missing? - GL Q  1439  1 Started by  muffntuf If you want to match transactions say a summarized transaction with its corresponding payments - how do you do that If you have a summarized transaction fo $65,0000 and that is posted to the GL- it is the first line in the sequence of events.&160; There are two separate invoices that make up that $65000.&160; Invoice A is $13,000.&160; Invoice B is $52,000.&160; And the two combined make the $65k. How do you associate the Invoice with the Summarized transaction in the GL&160; Outsid...
1 1439
by  muffntufJump to last post
09/14/2009 6:22 PM
1 Replies and 1169 Views Cons for environment and LBI in the same server?  1169  1 Started by  Jimmy Chiu &160; I am in the process of preparing to install LBI. I am wondering what's the pros and cons or if it's even feasible to put LBI in the environment server &160; I&160;do notice by not putting LBI seperate, I can use SSOP instead of DSSO for user authentication. Any thought
1 1169
by  Patrick DowdJump to last post
09/14/2009 4:49 PM
1 Replies and 1477 Views CRAS SP's  1477  1 Started by  Greg Moeller All: Would like some recommendations/instructions from the group as to applying SP's to CRAS server. I'd like to install SP4 and SP5 to my SP3 XI R2 RAS service...&160; I have already applied the latest update to LBI 9032.111. Can I&160;just reinstall 111 to get the SP changes over to LBI or am I&160;sunk until the next update to reporting services comes out Thanks for any input, -Greg
1 1477
by  Patrick DowdJump to last post
09/10/2009 8:59 AM
3 Replies and 1367 Views User signon credentials not enabled for Enterprise Reporting Server  1367  3 Started by  BBryant Has anyone seen this message before To give you an idea of what is going on in our environment here, we have a new install of LSF9 (running 8.0.3 apps) and it is functioning.&160; We are trying to implement the Crystal Enterprise Reporting piece and the message in the subject appears whenever we try to access CE Reporting within the Lawson Portal.&160; Myself nor my coworker have installed this particuliar application before and have had no instructions by which to do it, we are basically ...
3 1367
by  BBryantJump to last post
09/10/2009 8:45 AM
1 Replies and 1255 Views DSSO on virtual machine  1255  1 Started by  Janis Set JAVA_HOME, LAW_JAVA_HOME, and PATH manually from command line but the installer appears to be referencing the user's home directory to validate the BC files are in place. Has anyone had any luck installing DSSO on a virtual machine&160;
1 1255
by  JanisJump to last post
09/09/2009 8:48 AM
1 Replies and 1719 Views Options for big back office reports in LBI  1719  1 Started by  Deleted User Hello, I am learning the ropes with LBI and have found this forum to be most valuable.&160; We have some VPs and Directors who insist on seeing the detail for their cost centers on back office RW100, GL291, AP275 and Crystal using the MM280.rpt as data source.&160; Some of these reports are over 1000 pages.&160; What options do I have in LBI&160;to present a large report to a user&160; I'm just learning the concepts of publications, instances, and historical reports.&160; Any i...
1 1719
by  kflores01Jump to last post
09/03/2009 3:19 PM
5 Replies and 2161 Views OleDB Filter Syntax  2161  5 Started by  Jeff I am using the Lawson Query Builder OleDB for first time and am trying to understand the syntax of the filter statement. Trying to read rows with a Major Class = 204 or 920 This format does not return any rows: POLINE.PURCH-MAJCL = 204 or 920 This format throws an error upon execution: POLINE.PURCH-MAJCL = 204 or POLINE.PURCH-MAJCL = 920 Is there documentation for this tool somewhere Any advice is appreciated. Jeff
5 2161
by  John HenleyJump to last post
09/02/2009 1:12 PM
4 Replies and 3577 Views Export a scheduled LBI report to excel DATA ONLY format  3577  4 Started by  Kate Liamero I&160; have a crystal report that is scheduled&160; in LBI&160;, exported to excel and emailed as an attachment to users.&160; The problem is that the excel file cannot be sorted by the users because of meged cells.&160; I beleive that if I could export using the export to excel data only the file could then be sorted but I don't see that option in LBI.&160; Is there a way to do this Thanks Kate
4 3577
by  Ruma MalhotraJump to last post
09/02/2009 10:55 AM
1 Replies and 1480 Views DEVELOP A REPORT FOR PO CHANGES  1480  1 Started by  cmarcous I need to develop a query selecting&160;PO number, vendor, Vendor name, user id, before and after images and PO Audit Update Date&160;where a PO Change has resulted in a net&160;increase of over $25,000 from the previous&160;PO total amount or in the case where no previous revisions are made, the original total PO amount.&160; I've attempted this with POAUDIT, PURCHORDER, PO COMPANY, & APVENMAST however there is something amiss with the joins or selection criteria.&160; Also tried uns...
1 1480
by  cmarcousJump to last post
08/31/2009 10:46 AM
9 Replies and 3832 Views LBI Error when publishing Crystal Report  3832  9 Started by  Jan I've just published a Crystal Report into Lawson LBI, and receive the following error when I view it: Invalid table number. CR Labor Utilization - Monthly {1D97554B-8470-4553-A3C3-D4B42702C5B1}.rpt The report runs fine in Crystal.
9 3832
by  JanJump to last post
08/25/2009 2:42 PM
7 Replies and 1967 Views Data source / sql question  1967  7 Started by  vc727 I am a very novice sql user who really just trys different things until it works not really knowing why. So when I was asked to create a query that gives basic employee data with a count of active dependants I created the following query that works in Toad and in the crystal designer but&160; when I publish it to LBI it doesn't recognize the datasource. is there a different way to write it so it will accomplish the same thing and be published to LBI SELECT a.employee, TRIM(a.LAST_NAME)||',...
7 1967
by  vc727Jump to last post
08/20/2009 10:23 AM
6 Replies and 3715 Views LBI Report link in Lawson Portal  3715  6 Started by  Kate Liamero Is it possible to add a bookmark to the portal to point to a report published in LBI&160; I have a couple of&160; Employee Expense reports that my travel audit group needs but I don't want to create a dashboard for just a few reports. Thanks Kate
6 3715
by  Kate LiameroJump to last post
08/18/2009 4:01 PM
1 Replies and 1435 Views I want to burst a non-lawson text report with LBI  1435  1 Started by  Mike Schlenk I&160;would like to take a large text-based report from an AR/ADT system and send it through LBI for breaking apart to different recipients much like a bursted Lawson back-office report. The catch is this report is not tagged and is from a foreign system. &160;I'm having trouble determining if Crystal Reports server can do this. &160;If so, does the one from Lawson do this I'm desparately trying to consolidate report viewing to one portal, the Lawson LBI portal.&160; Originally I was ...
1 1435
by  Matthew NyeJump to last post
08/18/2009 12:50 PM
4 Replies and 1483 Views Adding Links to LBI Dashboards  1483  4 Started by  Saurabh Hi All We have a Win2003 environment and&160; use the LBI&160;Dashboard(LSF9.0) d like to be able to add links to Batch files and other commands like (remote desktop) so that we have a single point of access. has anyone added external links which are not links to websites regards Saurabh
4 1483
by  SaurabhJump to last post
08/18/2009 9:13 AM
4 Replies and 3850 Views Summarized Transactions  3850  4 Started by  muffntuf I need a quick lesson in invoices - particularly if they have a GLTRANS&160;that says summarized transaction.&160; I need to provide the details of the summarized transaction. So if a GLTRANS&160; has system code of AP, System is AP, lets say the summarzied transaction is for $5000.00.&160; And there is an invoice number attached of 2009.&160; How can I get the $5000.00 broken down I have GLTRANS joined to APDISTRIB and find the invoice there. &160;I also have APPAYMENT attached t...
4 3850
by  muffntufJump to last post
08/17/2009 2:17 PM
0 Replies and 1276 Views vague errors  1276  0 Started by  Deleted User In our websphere install of LBI we get these vague errors Error Getting Report Data Fields Error Getting Report Data Fields Error Getting Report Data Fields Error Getting Report Data Fields What does this mean
0 1276
08/17/2009 12:25 PM
1 Replies and 1556 Views Report Owner  1556  1 Started by  Kate Liamero The person who created and published many of our LBI reports has left and she is the report owner on many of our LBI reports.&160; Is there an easy way to get a list of all of the reports she owns and do a mass reassignment to another owner rather then haveing to reassign the owner one report at a time. Thanks Kate
1 1556
by  Matthew NyeJump to last post
08/17/2009 7:42 AM
4 Replies and 1609 Views Section Visibility Issue with Positioning Subtotals  1609  4 Started by  Paul4 I apologize in advance for the long post but I want to provide as much detail as possible on the issue I am trying to resolve. &160; I am creating an income statement using crystal reports 2008 for a hospital which has 9 corpoations and is implementing Lawson 9.0. I am having a problem with the way the income statement displays that I believe relates to the way I am using conditional suppression of section footers. &160; The income statement is set up to group accounts by GLCHARTDTL.Sumry_...
4 1609
by  CharJump to last post
08/14/2009 8:28 AM
2 Replies and 1464 Views BR21 - how does this work?  1464  2 Started by  muffntuf I am hunting around for information on BR21, BR152 and BR121&160;I have isolated a GLTRANS record and the source is BR21 - which seems to be a invoice reversal or deletion But there is still the record in GLTRANS, so I am trying to track down the tables the transaction originated from.&160; I&160;have tried ARDISTRIB, APDISTRIB, AROIHDR and&160;AROITEMS. Where else can I look for the origintating transaction be or how can I trace this back to the originating invoice Thanks!
2 1464
by  muffntufJump to last post
08/13/2009 3:38 PM
1 Replies and 2118 Views Subsystems for Cash Reconciliation  2118  1 Started by  muffntuf Would I need to look at any other tables to do a reconciliation between the GLTRANS and CBCPYCASH tables besides APDISTRIB and ARDISTRIB Report Purpose is'&160; To be able to view detail from summarized GL Entries into the original subsystems for Cash Reconciliation On the ERD's I see Cash Ledger only tied to APDISTRIB and ARDISTRIB.&160; Could there be any other source table Thanks!
1 2118
by  muffntufJump to last post
08/11/2009 12:08 PM
2 Replies and 1588 Views ARDISRIB question  1588  2 Started by  muffntuf I need to pull in the invoices from ARDISTRIB to get a certain AR account with its sub accounts that do not show up in the ACHISTDTL AND ACHISTHDR because they have not gone through the process yet. I need to get an invoice date for the invoices in ARDISTRIB - I don't see how to do that through the data dictionary. Anyone done this Thanks!
2 1588
by  muffntufJump to last post
08/10/2009 10:03 AM
3 Replies and 2194 Views IC234 Inventory Valuation Report  2194  3 Started by  Shawn Hello, This is my first posting so please bear with me.&160; I have a Lawson IC234 Inventory Valuation report with a costing method of FIFO. On the report there is a column titled 'Current Cost as of Valuation Date'.&160; I&160;believe it is a calculated amount because I cannot pull any cost data into Crystal that matches the amounts on the report.&160; Does anyone know what fields and or calculations are being pulled/performed&160; Thanks
3 2194
by  ShawnJump to last post
08/06/2009 10:09 AM
3 Replies and 1680 Views BR is in GLtrans R_System  1680  3 Started by  muffntuf I can't seem to track down what BR acronyn&160;means in the GL Trans table in the R_System field.&160; Is there a table that has the description for it Thanks!
3 1680
by  muffntufJump to last post
08/05/2009 11:30 AM
0 Replies and 1372 Views LBI Rights setup on rights management on LBI  1372  0 Started by  Ruma Malhotra We are on LBI 9031. When I add a new right on the rights management&160;and click save, suddenly the screen blanks out with all fields cleared. I then have to go to maintain rights, weed through the long list of roles, find out which one I was adding click on it and then add the value. I am adding roughly about 300 roles in order to support reporting from LBP which we just implemented with this new release and I am finding it hard and tedious to go through the whole exercise in addition to addi...
0 1372
08/04/2009 11:39 AM
6 Replies and 1747 Views Datasource not populating on LBI  1747  6 Started by  Ruma Malhotra I am running reports that go against the lbp schema and belong to the same database as the other lawson tables using native oracle odbc. These reports are created using sql as a command. When I publish the report on LBI I am not able to see a datasource drop down list that I can pick from. Does anybody have any ideas as to why this is happenning and what I can go alternatively. tia.
6 1747
by  Ruma MalhotraJump to last post
08/03/2009 3:04 PM
12 Replies and 3376 Views RW and Account Lists  3376  12 Started by  Julia I am using RWROWDET&160;to recreate an RW&160;group format into a view for use within a Crystal Report.&160; In RWROWDET&160;there is a field called ACCOUNT_LIST which relates to a list of accounts.&160; Anyone know how to get the list of accounts that make up this list Thanks, Julia
12 3376
by  JuliaJump to last post
08/03/2009 11:35 AM
2 Replies and 2208 Views LBI hardware upgrade  2208  2 Started by  Deleted User Hello, We have our pilot LBI install running on a Win 2003 32 bit 4 processors with 4gig of ram.&160; The server has 20g space available.&160; WebSphere, SQL server 2005 and LBI are all running off one of the drive.&160; We do not have the expertise in house to re-install websphere or LBI.&160;&160; Any ideas on&160;what would need to change in Websphere&160;and LBI&160;to upgrade to Win 64bit OS so that we could increase the ram&160;&160;We also need to increase the&160;drive ...
2 2208
by  Matthew NyeJump to last post
08/03/2009 8:19 AM
5 Replies and 3318 Views Crystal 2008 export to excel  3318  5 Started by  TracyO We just updated our Crystal Reports from 8.5 to Crystal 2008.&160; We export several of our reports to Excel, and I am noticing that I only have two Excel options Microsoft Excel (97-2003) Microsoft Excel (97-2003) Data-only I am finding thata they do not export nicely to Excel.&160; ONce we export, we usually need to sort & manipulate the data, but when I&160;extract from Crystal Excel will not let me sort unless I highlight the entire file go into my Excel options and uncheck merge c...
5 3318
by  TracyOJump to last post
07/29/2009 12:57 PM
3 Replies and 5449 Views Display Portal Page in LBI Dashboard?  5449  3 Started by  Deleted User Does anyone know how to invoke a Design Studio Portal Page from a Dashboard Also, is it possible to display the contents of the processFlow inbasket in a dashboard. We are taking the approach that users will log directly into framework services instead of the portal and would like to have this functionality in the dashboard.
3 5449
by  MBMJump to last post
07/29/2009 12:43 PM
2 Replies and 1710 Views Dashboards Tab Order  1710  2 Started by  Fernando Labrada I think I know the answer to this, but, it is worth asking: Is there a way to control the sequence of the tabs accross the main dashboards display window. I had Tools - ESS -MSS and then I added a Reports dashboard and now I&160;have Tools - ESS - Reports -MSS. I cannot see a way to put Reports at the end where it belongs. The last time this hapenned to me, I seem to remember that there is no way to control it. Has anything changed Can I&160;control it. If so, how
2 1710
by  Fernando LabradaJump to last post
07/28/2009 2:15 PM
3 Replies and 2808 Views Crystal reports Viewer display window freezes  2808  3 Started by  Ruma Malhotra We just completed our LBI&160;upgrade from 9022 to 9031. We are having an issue where when we click a report to bring it up, we get a window that says please wait and after few minutes it freezes and when we click the x button to get out it throws the user completely out of LBI. What can be the reason. This report was coming out fine with the upgrade.
3 2808
by  jnwrightJump to last post
07/27/2009 1:47 PM
15 Replies and 2442 Views LBI and SSO Install  2442  15 Started by  jellis Hi, I am stuck with the SSO install to LBI in the SSO&160;install guide page 13 of the worksheet. DSSO base install directory..is this referring to the application directory such as EFS, ERS, or ESN The next part is on page 15- Copy the dsso.xml file (located on the DSSO machine, at DSSOBaseDirectory/law/ system/dsso.xml (UNIX, MSCM only) or DSSOBaseDirectory\law\system\dsso.xml (Windows) to the Lawson Environment machine. Is this a file that will be created by the DSSO.jar appli...
15 2442
by  jellisJump to last post
07/27/2009 9:46 AM
6 Replies and 2459 Views Custom group in 9031  2459  6 Started by  Ruma Malhotra Has anyone used the custom group feature for lbi 9031. I would like to create a custom group and add different lbi roles to this custom group. Then give a report access to this custom group. Can a custom group work for this. if not has anyone be able to acheive this thanks,
6 2459
by  Ruma MalhotraJump to last post
07/27/2009 8:44 AM
2 Replies and 1810 Views Project Upgrade: LBI  1810  2 Started by  Greg Moeller All: I am trying to upgrade LBI.&160; Currently on v9.0.1.8 on Tomcat want to go to v9.0.3.x on Websphere. Here's the situation:&160; In order to do this, we needed to buy new servers (old ones didn't meet the requirements).&160; I&160;have WAS installed, and CR, and RAS, etc. Installed LBI v9.0.1.10 into WebSphere as a new install.&160; Had our DBA copy the current prod version into the new schemas. What's the best way to go about changing all of the required server names in all of the...
2 1810
by  Greg MoellerJump to last post
07/25/2009 6:13 PM
1 Replies and 1619 Views Reporting services default parameters is null  1619  1 Started by  Any ideas? Hi, We have a custom parameter screen developed using jsp and the url is attached to the parameter selection event. During the&160;the jsp execution, the default reporting service parameters like, reportname fsuserid remurl2 is always null when queried through request.getParameter(..). Is there any additional steps which is getting missed out Thanks in advance.
1 1619
by  Any ideas?Jump to last post
07/25/2009 5:59 PM
9 Replies and 4124 Views Override datasource doesn't appear to work  4124  9 Started by  mikeP Hi all, I have a number of CR2008 reports published to LBI 9.0.3, and I&160;am testing the possibility of using the Override Datasource feature to change the report to run against&160;different data areas in DB2. These are ODBC reports that use the client access ODBC driver. &160; I created datasources in LBI as generic ODBC&160;connections, just playing cause I&160;really don't know what it wants for the database and schema settings, as we normally just specify a server and data area...
9 4124
by  mikePJump to last post
07/24/2009 2:12 PM
1 Replies and 1245 Views Multiple rows coming back - Cartesian  1245  1 Started by  muffntuf Hi, I&160;started another report to just find Invoices&160;and match&160;up to&160;GLTRANS and ACHISTHDR and ACHISTDTL. &160;The only thing I am getting from ACHISTHDR is the Invoice date. According to the data dictionary the joins should be this, but like I&160;mentioned - I am getting mutliple rows for one record even though everything is inner joins. Does anyone see something wrong with this from clause FROM LAW9_ACHISTHDR INNER JOIN (LAW9_ACHISTDTL INNER JOIN (LAW9_GLTRA...
1 1245
by  muffntufJump to last post
07/24/2009 1:33 PM
2 Replies and 1860 Views LBI/Crystal XI Failure to Process Prompt Error with Cascading Parameters  1860  2 Started by  Charlotte Chase I have a Crystal XI report with a cascading parameter. The report&160; uses a SQL&160;command rather than a stored procedure. Runs fine in Crystal, but when published in LBI the first prompt works, but I get a 'Fail to process prompting'&160;error on the second parameter.&160; If I get rid of the SQL&160;command and pull in the tables directly, both parameters work &160;in LBI, but that just kills performance.&160; Has anyone had experience with this Thx!
2 1860
by  Charlotte ChaseJump to last post
07/23/2009 4:03 PM
4 Replies and 2481 Views GL Trans Obj-ID  2481  4 Started by  muffntuf An invoice can have mulitple lines.&160; When posted to the GL&160;does each line item get posted, or the whole invoice Obj-Id is different for each line I pulled into a report. Thanks! (Yes I am a newbie!)
4 2481
by  Brad SchauerJump to last post
07/20/2009 3:38 PM
7 Replies and 1854 Views JE Number same as GTR-JRNL-BOOK-NBR?  1854  7 Started by  muffntuf In Lawson is the JE Number the same as GTR-JRNL-BOOK-NBR &160; And does the&160; JBK SEQ NBR have anything to do with it I searched and don't find any older posts. Thanks!
7 1854
by  Matthew NyeJump to last post
07/20/2009 10:49 AM
2 Replies and 1704 Views Group footer spacing  1704  2 Started by  mcl This may sound a little crazy but I cannot figure out how to do it.&160; (1)&160; I am checking some items in our legacy system against the count and amounts that have been converted to Lawson. (2)&160; No problem doing the actual comparison, I read legacy files in main report, summarize data for a group, at the group footer I call a subreport to read Lawson, share variables from Lawson-subreport back to main, and print in a second footer line if the accumulated legacy total is not equal t...
2 1704
by  mclJump to last post
07/13/2009 2:28 PM
4 Replies and 1827 Views Report Schedules  1827  4 Started by  Ruma Malhotra I am wondering if anybody has found out a way to get notified whenever a report scheduled to refresh at a particular day and time fails to refresh without going through the log files. On reporting services for maintain schedules the status of success or waiting is not the true status of whether the report refreshed but the status which defines that the handoff for reporting services to CRAS to refresh was successful or not. Also we are on version 9031 in test and 9022 on prod ans was wond...
4 1827
by  Ruma MalhotraJump to last post
07/13/2009 10:59 AM
16 Replies and 6120 Views GLTRANS join check with APDISTRIB & APINVOICE  6120  16 Started by  muffntuf Okay so I have this query pulled together, but am wondering about the results.&160; Can someone look over the joins in the query and tell me if I have them correct&160; SELECT&160;&160;&160;&160; .GLTRANS.COMPANY, .GLTRANS.ACCT_UNIT, .GLTRANS.ACCOUNT, .GLTRANS.SUB_ACCOUNT, &160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160; .GLTRANS.CURRENCY_CODE, .GLTRANS.TRAN_AMOUNT, .GLTRANS.BASE_AMOUNT, .GLTRANS.POSTING_D...
16 6120
by  muffntufJump to last post
07/10/2009 4:28 PM
2 Replies and 2390 Views GL Sub Account Validation  2390  2 Started by  Jan Does any one know of a small Lawson table that contains valid SUB-ACCT values I'm creating a Crystal Labor Utilization Report to be published into LBI.&160; In my Crystal sql, I'm trying to find a smaller Lawson table where I can&160;query for a list of valid Sub Accounts.&160;&160;I have to categorize these sub accounts using logic I'll include in the sql.&160; I could query&160;PRDISTRIB for a unique list DST-SUB-ACCTs but that table is very large.
2 2390
by  Matthew NyeJump to last post
07/10/2009 10:34 AM
1 Replies and 1520 Views LBI EFS Login Hung  1520  1 Started by  Deleted User I recently installed the LBI in my Windows 2003 Server. The server box is physically the same as the Lawson LSF/WebSphere. In other words, LSF 9.0.6, WebSphere 6.0.2.17, and LBI EFS 9.0.1.10.154 are all on the same server. DSSO is not installed because they are all in the same server. The LBI/EFS login without any problem if I specified File-based Authentication in the System Configuration Assistant. But when I changed to Lawson Single Sign-On and&160;enter SSOP for the&160;Server Name, the l...
1 1520
by  Matthew NyeJump to last post
07/09/2009 4:33 PM
3 Replies and 1634 Views Crystal report needs to reference non-odbc data  1634  3 Started by  Jan Hi I’m working on an LBI/Crystal report where two of the tables are smaller Excel files (each less than 1,000 lines).&160;I can develop the report in Crystal okay, but once I publish the report onto the LBI server, the report won’t be able to find the network location where the spreadsheets are.&160;Due to limited I.T. resources, I can’t have them create these tables in the database for me.&160;Also, there are issues with having the LBI server map to the network drive where the spreadsheets ...
3 1634
by  muffntufJump to last post
07/09/2009 2:24 PM
6 Replies and 3856 Views Reporting Invoice Date with GL Trans  3856  6 Started by  muffntuf HI, What is the best way to get Invoice Date added to a report with GLTrans&160; I have looked at APInvoice and HCHISTDTL with ACHISTHDR. They just want a basic listing of GLTrans, but with the Invoice date in the same Accounting Period. I am pretty new to this stuff. Thanks!
6 3856
by  muffntufJump to last post
07/09/2009 12:53 PM
3 Replies and 3468 Views Crystal for Financial Reporting  3468  3 Started by  Julia We have a bunch of RW reports that are data sources for Crystal.&160; Crystal is then used to write reports such as balance sheet; income statement etc with the RW&160;as the data source.&160; Modifications are a huge problem and I am proposing that we rewrite the reports in Crystal going directly to LAWSON data specifically the GLAMOUNTS, GLUNITS&160;and FBDETAIL&160;tables.&160; Most likely to have a view.&160; However I&160;have noticed that there a bunch of RW data tables in LAWSON&...
3 3468
by  John HenleyJump to last post
07/02/2009 10:17 AM
6 Replies and 2377 Views Need prior quarter year to date  2377  6 Started by  Diane G I need a report that has current balance (balance sheet accounts) and current year prior quarter balances. I cannot find a data dictionary item for the curr yr prior qtr balances. &160;
6 2377
by  Milo TsukroffJump to last post
07/01/2009 12:47 PM
7 Replies and 7275 Views SI_STARTTIME Question  7275  7 Started by  Deleted User Is there a way to make this statement exclude the time SI_STARTTIME I only want the date and no time on it. Thank you. Cindy
7 7275
by  Deleted UserJump to last post
06/30/2009 12:13 PM
1 Replies and 1295 Views oledb index and filter settings  1295  1 Started by  Ruma Malhotra I am trying to set up a range in the index or filter options for an ole db report. The range is like (field >= 600 and field =700 and field Has anybody been able to set this up on the filter or index of a table in lawson. i have tried&160; the , ; & | to give me a combination but oledb is not acceptiony any of these characters. It allows the first part but not the rest. tia. &160;
1 1295
by  Ruma MalhotraJump to last post
06/05/2009 8:42 AM
12 Replies and 3004 Views OLE db report for LBI 9031  3004  12 Started by  Ruma Malhotra We are in the process of converting a particular report from 9022 to 9031 that uses the prdistrib table and has been written in oledb. However this report is not completing refreshing and times out after 40 minutes of refreshing. if we break this report to go against a smaller set of data it completes fine. Is anybody willing to share any pointers or tips that I can use to get this report to complete refreshing. Remember this report is written in oledb and I would like to avaoid full table sca...
12 3004
by  Ruma MalhotraJump to last post
06/04/2009 4:42 PM
2 Replies and 1680 Views LBI and Crystal 2008 (11R3) Parameters Field  1680  2 Started by  jellis Hi, We recently just upgraded to the latest LBI and Crystal 2008 (11R3). I&160;have reports that I&160;have fixed so that when the report is run in Crystal Designer you get the option to modify those paramaters on the left-hand side of the screen after the report has been refreshed. The question I&160;have is how to enable this in LBI once the report has been run In theory this is possible according to a couple of co-workers who attended QUE this year and saw this functionality. Any help ...
2 1680
by  jellisJump to last post
06/04/2009 3:18 PM
3 Replies and 2697 Views LBI Bursting carrying through Crystal subreports  2697  3 Started by  jkunkle When a Crystal Report includes a subreport how can you force the LBI bursting to carry through onton the subreport
3 2697
by  mark.cookJump to last post
06/01/2009 2:24 PM
3 Replies and 12841 Views Blank rows in excel export of crystal report  12841  3 Started by  Jon Lunn Hi, I've got a few crystal reports that are set to open as excel files. however it seems to populate blank rows between the lines of data. I've reduced the line space between the rows in crystal as much as possible. has anyone got any ideas CR XI R2 SP4 LBI&160;9.0.1.8 Thanks Jon
3 12841
by  Shane JonesJump to last post
05/27/2009 10:24 PM
6 Replies and 2732 Views Hide Search Box on LBI  2732  6 Started by  vc727 Does anyone know if it is possible to hide the search box on the right hand side of the dashboard view of LBI We are moving from 8 to 9 and having both the portal search box and the LBI on the right hand side has become confusing. We never use the one in LBI and would be cleaner to just hide it.
6 2732
by  vc727Jump to last post
05/20/2009 12:10 PM
1 Replies and 2510 Views How to define parameters in a Crystal Report  2510  1 Started by  Jan I have a year-to-date labor distribution report developed in Crystal that I'm publishing to LBI.&160; The report is grouped by 1) cost center 2) employee 3) payroll quarter 4) payroll month When originally published, the user will see all data for all pay periods for all the cost centers the viewer has permissions to see.&160; I'd like the user to filter the data to just see a selected payroll quarter or a selected payroll month.&160; I've started playing around with parameters but have ...
1 2510
by  Matthew NyeJump to last post
05/18/2009 2:58 PM
4 Replies and 1855 Views Multiple Environments and Multiple LBI Servers  1855  4 Started by  jellis Hi, We are running into an interesting dilemma in that we run multiple Lawson environments (20) and multiple LBI servers to service these environments. The dilemma we have run into is that we have the same report, but that it needs to be published using different DSN's many times. Everytime the enviroment changes like right now we are going from LRS to LBI, and later from v8 to v9 of Lawson, we have to change all the DSN's etc. What I am curious of is if there is a generic driver or something ...
4 1855
by  Matthew NyeJump to last post
05/18/2009 1:37 PM
2 Replies and 1401 Views How to suppress Instance Name in a report history report list  1401  2 Started by  Jan Is there a way I can suppress the display of Instance Name in one of my dashboard report lists&160; I'd like to display only Report Name and Created Date since that makes more sense to my end users.&160; However, I'm unable to remove or even change the position of Instance Name in the list of columns to displayed&160;for this report list. I've checked through the Reporting Services and User Guide doc but don't see any way to suppress instance name, unless that ability is undocumented. &1...
2 1401
by  JanJump to last post
05/13/2009 9:44 AM
2 Replies and 1797 Views Link to Process Flow Inbasket from Framework Services  1797  2 Started by  vc727 We are working on moving from 8.0.3 to&160; lsf 9.0 I have the following url on one of our dashboards and it works fine but in the 9.0 version it comes back with the error Error retrieving work units for current task launchForm2('inbasket/inbasket.htm' top.lawsonPortal.profile.getElementsByTagName('TASK')&91;0&93;.getAttribute('id')) &160; The inbasket works fine if I click on the link in the portal menu on the left but we need the&160;dashboard link to work because the portal menu i...
2 1797
by  vc727Jump to last post
05/12/2009 9:54 AM
1 Replies and 1896 Views Processing Limit Error hit  1896  1 Started by  Jan I'm developing a Crystal Labor Distribution report.&160; I've published the report in a test area and have scheduled it to run.&160; The report completes okay, but when I view it, I get the following error ------------------ A processing limit was reached. Error in File Year to Date Labor Distribution for PNI {A4B16443-FCE1-4671-908E-98DA0E269561}.rpt: Max processing time or Max records limit reached ------------ When I scheduled the report, I set it to cache at creation time.&160; I'm no...
1 1896
by  Matthew NyeJump to last post
05/11/2009 2:47 PM
2 Replies and 1934 Views Crystal Report - Group Tree in LBI displays Employee Number with commas  1934  2 Started by  Jan Hello, I've developed a labor distribution report in crystal.&160; It's grouped by cost center, then&160;employee number beneath that.&160;&160;When I&160;view the&160;Group Tree in Crystal, the&160;employee number displays with no commas - something I tweaked&160;in the report&160;because it originally displayed with commas - since employee number is numeric. However, when I publish the Crystal report into LBI and view it, the employee number in the group tree shows up with the comma...
2 1934
by  JanJump to last post
05/07/2009 12:28 PM
5 Replies and 2217 Views Crystal Report needs to have jdbc connection to more than one database  2217  5 Started by  Jan Hello, I'm developing a Crystal report to be published into LBI.&160; The report pulls data from Lawson but also from a Kronos database.&160; I can develop the report in Crystal with both data sources just fine, but my question is - when I publish the report into LBI I currently use the 'Data Settings' tab in the LBI 'Report Settings' screen to override my report's data source.&160; Our LBI administrators have asked us to do this so they can maintain the data access user-id and password.&16...
5 2217
by  CharJump to last post
05/05/2009 4:00 PM
4 Replies and 1715 Views Crystal Integration Pack gone!?!?  1715  4 Started by  Deleted User Hello everyone.&160; I have been reading up on the Crystal Integration Pack for Enterprise Reporting for use here.&160; However, I&160;can no longer locate the file at support.lawson.com.&160; We use Crystal XI Report editor and RAS on NT servers from Lawson 9.0.0.2 using LS9. Would any of you be able to point me to where this file is available&160; According the support.lawson.com, it should be at Product Download Center --> Windows under the Enterprise P...
4 1715
by  Deleted UserJump to last post
04/30/2009 2:12 PM
5 Replies and 1915 Views One crystal report executing another crystal report ?  1915  5 Started by  Ruma Malhotra Has anybody accomplished one report executing another crystal report and passing a parameter . I know this can be done by adding an hyperlink to the report and passing a parameter. Can somebody share the excat sysntax after publishing both on lbi. &160;
5 1915
by  Matthew NyeJump to last post
04/17/2009 11:07 AM
0 Replies and 1374 Views new implementation design question  1374  0 Started by  brihyn We are nearing the finish of implementing LBI here in a brand new Lawson setup (version 9.0 for all). We've got everything working up through creating the datacube...almost. Running IA150 will create the .csv's, upload them to the ftp site, and then stop. The installer believes that the issue is that we need to setup IIS&160;on the sql cluster, add the msmdpump.dll, create the application pool, etc, and that should be the end of it. However, our DB and security teams are very much against the...
0 1374
04/16/2009 2:09 PM
1 Replies and 1645 Views Rights Management Export  1645  1 Started by  vc727 We are currently in the process of moving from 803 to 9.0 and part of that process has been to just buy a whole new server and install from scratch and convert as much as possibe. I built all of our rights management stuff manually in our current production system and want to dump it out so I can load it into the new 9.0 world. I can't seem to find instructions on how to do that just notes that say it is possible. Any suggestions would be very helpful.
1 1645
by  Matthew NyeJump to last post
04/15/2009 12:34 PM
0 Replies and 1327 Views Upgrade Question for LBI?  1327  0 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 1327
04/06/2009 9:11 AM
3 Replies and 2033 Views LBI implementation timing  2033  3 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 2033
by  Phil SimonJump to last post
04/03/2009 7:54 AM
1 Replies and 1730 Views Setting DataSource in Smart Notification  1730  1 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 1730
by  Matthew NyeJump to last post
04/01/2009 8:15 AM
1 Replies and 1902 Views LRS- Report question  1902  1 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 1902
by  Matthew NyeJump to last post
03/27/2009 3:41 PM
2 Replies and 1910 Views SQL to link APDISTRIB to PO line Details  1910  2 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 1910
by  Peter BraytonJump to last post
03/27/2009 9:27 AM
6 Replies and 2105 Views How to show better report description in dashboard  2105  6 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 2105
by  JanJump to last post
03/25/2009 2:10 PM
2 Replies and 5699 Views Invoice comments report  5699  2 Started by  Ruma Malhotra Has anybody tried to query the invoice comments table to create a report.
2 5699
by  Peter BraytonJump to last post
03/25/2009 8:30 AM
4 Replies and 2736 Views Easiest way to create Balance Sheet in Crystal from Lawson  2736  4 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 2736
by  John HenleyJump to last post
03/20/2009 2:49 PM
4 Replies and 5623 Views LBI Report Scheduling Options  5623  4 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 5623
by  lagapisJump to last post
03/18/2009 12:53 PM
1 Replies and 1697 Views Daylight Saving patch  1697  1 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 1697
by  Chris MartinJump to last post
03/13/2009 10:31 PM
3 Replies and 2832 Views Crystal Report Viewer  2832  3 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 2832
by  Chris MartinJump to last post
03/12/2009 10:02 PM
4 Replies and 2143 Views Relate arapplied to oeoinvoice  2143  4 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 2143
by  John HenleyJump to last post
03/12/2009 9:39 AM
6 Replies and 3314 Views Dashboards & Modules For New Instance of LBI  3314  6 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 3314
by  Lenny MurneyJump to last post
03/11/2009 5:58 PM
15 Replies and 4665 Views Publishing LBI / Crystal  4665  15 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 4665
by  Joe O'TooleJump to last post
03/11/2009 4:39 PM
18 Replies and 3463 Views Viewing Reports from Portal  3463  18 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 3463
by  jellisJump to last post
03/10/2009 5:48 PM
2 Replies and 3050 Views RNI Aging report  3050  2 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 3050
by  Ruma MalhotraJump to last post
03/02/2009 12:48 PM
7 Replies and 2244 Views Websphere 6.1 Fix Packs-What Version?  2244  7 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 2244
by  Matthew NyeJump to last post
02/27/2009 1:34 PM
15 Replies and 3713 Views More Performance from LRS  3713  15 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 3713
by  Greg MoellerJump to last post
02/26/2009 10:35 AM
21 Replies and 12045 Views LBI Installed  12045  21 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 12045
by  jellisJump to last post
02/23/2009 4:21 PM
29 Replies and 17171 Views Access Lawson tables in MS Access  17171  29 Started by  Petter Hi, Is there any way of accessing Lawson tables via MS Access Either via DME calls or ODBC/OLE-DB &160; Petter
29 17171
by  cmarcousJump to last post
02/06/2009 7:49 PM
8 Replies and 4301 Views LBI Documentation Help  4301  8 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 4301
by  Matthew NyeJump to last post
02/03/2009 1:29 PM
9 Replies and 3260 Views Heirarchial reporting using RW100  3260  9 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 3260
by  Kim92Jump to last post
02/03/2009 9:41 AM
6 Replies and 2878 Views LBI/Crystal cascading parameters  2878  6 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 2878
by  Deleted UserJump to last post
01/26/2009 1:40 PM
7 Replies and 2530 Views LBI user id / password question  2530  7 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 2530
by  Matthew NyeJump to last post
01/22/2009 4:33 PM
3 Replies and 1994 Views LBI 9.0 Elements and Structures  1994  3 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 1994
by  Deleted UserJump to last post
01/22/2009 10:58 AM
6 Replies and 2389 Views LBI 9 Reporting Issue  2389  6 Started by  Deleted User I created a report in development and published LBI Data Settings of a user and password we set up for all development reports. The report is in Crystal XI using a SQL Server stored procedure as the data source. This office is used to using tables as the data source. When I publish to LBI Dev the Data Settings are fine. When they publish in production, there is no user or password in the Data Settings area. How do I fix this
6 2389
by  Matthew NyeJump to last post
01/22/2009 10:07 AM
3 Replies and 2551 Views Row Level Security in Crystal Reports  2551  3 Started by  MSS Hi, I would like to have row level security in Crystal for Lawson data in HR/PR/BN modules. What Row level security means in this context is the user has access to the data entered by him and few other users. Has anyone handled this before in Crystal Reports. Any help in this regard is appreciated. Thank you. &160; &160; &160; &160; &160; &160; &160;
3 2551
by  John HenleyJump to last post
01/15/2009 10:29 AM
2 Replies and 2605 Views Load Balancing RAS  2605  2 Started by  jellis Hi, We are building a new infrastructure that will have multiple RAS servers. What I am curious is how some of you did the load balancing to these servers. Did you use a software or hardware solution. Thanks.
2 2605
by  jellisJump to last post
01/13/2009 6:52 PM
2 Replies and 2312 Views Links  2312  2 Started by  A_R_Consltnt Hello, Can someone please help as to what is the best way to link the GLTrans and FBDetail table to get resonable and correct rows The purpose is to create a report in crystal with budget and actual numbers. Thanks in advance. A.
2 2312
by  A_R_ConsltntJump to last post
01/12/2009 12:54 PM
18 Replies and 11893 Views Inital LBI Implementation Questions  11893  18 Started by  Deleted User We are currently an 803.7 Env shop with e-broadcasting and Report Designer reports. We plan on implementing LBI prior to going to LSF9. Our initial scope is to move the Report Designer reports over to Crystal and publish in LBI along with copying over our broadcasting functionality. We have an Oracle database and will be implementing with SQL Server as the Mid Tier database and Websphere. I have a couple of questions... 1) How long has it taken to implement LBI so that you are up to pre-L...
18 11893
by  John HenleyJump to last post
01/11/2009 7:26 PM
0 Replies and 1683 Views Reporting, Part 7: Categorizing Reports  1683  0 Started by  John Henley <p>In this installment of our on-going reporting series, let's turn our attention from looking at individual reporting products solutions, and instead look at your report development project. If you're like most organizations I come across, your reporting project charter is to replace an existing reporting system-be it a formal existing system, or a simply a list of user requirements if you had no previous formal system. Regardless, you need to develop and use a process that focuses on sat...
0 1683
01/10/2009 12:02 PM
4 Replies and 9058 Views Data Dictionary  9058  4 Started by  Greg Moeller Was it in this forum where I had found a data dictionary for the LBI tables&160; All 3 schemas. Even some documentation on field names, uses, etc would be good. &160; I know I found one somewhere once, but I cannot remember where it was.&160; If it was here, could I request it be sent again
4 9058
by  Greg MoellerJump to last post
12/15/2008 12:25 PM
3 Replies and 2480 Views Allow Multiple values for a parameter  2480  3 Started by  Joshua Adams How do you go about allowing the user to enter multiple values in a parameter After publishing a Crystal Report to LBI a parameter that is set to 'Allow Multiple Values' is rendered as a single text box. Is there a seperator that must be used between the multiple values If so what is this seperator
3 2480
by  John HenleyJump to last post
12/12/2008 12:13 PM
2 Replies and 2525 Views Repoint Crystal(Using Lawson OLE-DB)  2525  2 Started by  Deleted User Is there a way to repoint a Lawson OLE-DB link in Crystal from one Lawson server to another without have to redo the fields in the report&160; We are using Crystal 10.
2 2525
by  Deleted UserJump to last post
12/03/2008 5:03 AM
2 Replies and 2751 Views Search inside crystal reports...  2751  2 Started by  Shane Jones Anyone know Hopw I can select about 1000 cyrstal reports and search all of them for a string in the 'Selects', 'formulas',&160;'section experts', etc.... I&160;just don't wee how we are going to be able to open EVERY report to find a Plan code that is being changed. Any thoughts&160;&160;
2 2751
by  WillJump to last post
11/28/2008 4:58 PM
0 Replies and 1940 Views Is Lawson-Analytics Architect supports Essbase ASO applications?  1940  0 Started by  Gangadhar Hi there, Is it possible to load outline and data from Lawson GL program (IA120)&160;into Essbase ASO application Thank you for your replies in advance!
0 1940
11/12/2008 11:14 AM
0 Replies and 2035 Views How to change Essbase Application type in Lawson program  2035  0 Started by  Gangadhar Hi, I am new to this forum and Lawson. We are buliding Essbase outline and data load using Lawson IA120.&160; Now we have changed the application Essbase application type to ASO. But we CANNOT build outline or data load to ASO application thru IA120. I am trying to see if there is any option to change Essbase application type within IA120 or IA10. throwing this below error while loading to ASO app: 'No message for 1056504 in message database' Any idea or help would be appreciate...
0 2035
11/12/2008 8:55 AM
2 Replies and 2170 Views How do I hide the Tools dashboards from users?  2170  2 Started by  mmanosca Can anyone shed some light on how&160;to hide the Tools dashboard from users&160; The tab is visible but when they click on it it&160;gives&160;them an access denied error. Thanks, Mike
2 2170
by  mmanoscaJump to last post
11/07/2008 2:46 PM
0 Replies and 2098 Views Linking to a RS Crystal report from a Smart Notification  2098  0 Started by  Nick Has anyone been able to pass a parameter from a Smart Notification to a Crystal report in LBI&160; We would like to be able to populate the report's parameter (Employee ) from a related link in a SN.&160; Thanks!
0 2098
11/05/2008 11:01 AM
2 Replies and 4370 Views DME Syntax  4370  2 Started by  Petter Hello, I am a Lawson query user. When I set values for indexes, I cannot 'skip' a line in the index set. For example, I want to list all open invoices so I go to AROITEMS and use AROSET13 with my company code, process level and for a specific transaction type (invoices). However, I want to do it for all customers, I don't want to choose a customer number. If I leave customer blank, it will not filter for process level and transaction type. So I need something like a ' * ' so I get all customers...
2 4370
by  jeremy.zerrJump to last post
10/23/2008 12:58 PM
4 Replies and 4371 Views Use Perl to query DME via HTTP  4371  4 Started by  jeremy.zerr I haven't really found much information out there about how to use perl to access Lawson data through the DME's, so I figured I would share with you what I know. Sometimes, reporting calls for more powerful measures than excel can handle through the Office Add-ins, and well, I know that a scripting language like perl is more than capable through my years of prior experience doing data analysis for a semiconductor company.&160; Sometimes, 65536 data records is a limitation of Excel that elimina...
4 4371
by  jeremy.zerrJump to last post
10/23/2008 12:32 PM
2 Replies and 2692 Views Crystal report links error?  2692  2 Started by  Milo Tsukroff Can anyone help out here, or, have you seen this before&160; Our reporting department has again found problems with our Crystal Reports reports.&160; These reports are developed for LBI.&160; They suddenly find that all of the reports they check on have links that seem to have 'gone wild'.&160; Even worse, sometimes they see a field ('BUDGET_NBR') in&160;one of our two&160;custom views just disappear, or, the field shows up in the other&160;view which doesn't have that field in the first...
2 2692
by  Milo TsukroffJump to last post
10/10/2008 3:49 PM
3 Replies and 3539 Views Creating a Crystl Report against an ldap export ldif file  3539  3 Started by  Kate Liamero We have to do an audit on our Lawson Users.&160; I have an ldap export in an ldif file.&160; I then imported that in excel and wanted to create a crystal report against it.&160; My problem is the lawson security fields for Groups and roles.&160; They are multivalued fields/ arrays.&160; I want to be able to list the user and then in one column extract the list of&160; the users groups and in another column list their roles. This can probably be done right in the excel file also but I have ...
3 3539
by  k-rockJump to last post
10/07/2008 4:19 AM
3 Replies and 2853 Views Connecting to a RW report  2853  3 Started by  stcyrk I keep receiving an unknown error when trying to connect to a report.&160; I have verified the path in the query builder matches the path to the report on law\app. The error code is ADO Error: 0x80004005 Native Error: 62 &91Database Vendor Code:62&93 Anyone encounter this
3 2853
by  John HenleyJump to last post
09/15/2008 9:39 AM
1 Replies and 2378 Views LBI and SQL 2005?  2378  1 Started by  Roger French Trying to see if LBI (9.0.1.9) is compatible/certified with SQL2005. The install manuals only say SQL 2000. Just wanted to make sure of any gotchas if using SQL 2005 with LSF9.
1 2378
by  Matthew NyeJump to last post
09/08/2008 1:05 PM
6 Replies and 2949 Views Adjust Alert Light Bulb Color  2949  6 Started by  kflores01 In Lawson's Framework Services User and Administration guide (page 15) there is a display of a dashboard with alerts on the left hand side. Two of the alerts are red and one yellow. With the obvious intent, that the red alerts need immediate review. Similarly, I am interested in changing the color of a bulb from a default neutral (status_n_bulb.gif in the Status Icon field) to either green or red should the results from an alert are greater or less than particular thresholds within the alerts. T...
6 2949
by  kflores01Jump to last post
09/04/2008 6:52 AM
5 Replies and 3347 Views Tying activities data in ACTRANS to ARDISTRIB  3347  5 Started by  Deleted User Hello All, I need help with tying a given activity transaction (table ACTRANS) to it's supporting details within table ARDISTRIB.&160;&160; As the company I'm working with currently has little activity and just started a new fiscal year, my matching process currently uses a SUM query in SQL to add up the amounts on any given date and then matches by transaction date and the total from the SUM query matching the 'summarized transaction' amount from ACTRANS.&160;&160;&160; I can see this bre...
5 3347
by  Deleted UserJump to last post
09/03/2008 3:16 PM
10 Replies and 4028 Views Compiled Reports in CRX?  4028  10 Started by  Phil Simon Hello I am running CRX and we use Control M to schedule reports.&160; According to the company's website, you can create a .EXE and run it on the Windows Command prompt. The problem is (as you will see below), there's no REPORT, COMPILED REPORT functionality in CRX.&160; Evidently, this has changed.&160; 'To create a Compile Report within Crystal, go into Crystal Reports and open a report,&160; from the menu select REPORT | COMPILED REPORT.&160; The Compile Report dialog box will be disp...
10 4028
by  John HenleyJump to last post
08/30/2008 10:55 AM
1 Replies and 2287 Views Viewing Scheduled Rpts in LRS  2287  1 Started by  Phil Simon Hello.&160; We are running LRS v1 and I have a pretty basic question.&160; I know that LBI has more to offer than LRS but perhaps I am missing something.&160; Is the only way in LRS to view a previously scheduled report as follows: give user access to Tools (as an admin) and then have them view the instance&160; It doesn't appear as if you can publish the report to a dashboard and then have the end-user simply view the instance.&160; Is this by design&160; Version 1.2 &160; Document...
1 2287
by  Chris MartinJump to last post
08/18/2008 11:00 AM
3 Replies and 4497 Views Lawson Support for Essbase  4497  3 Started by  wkeller Does anyone have information related to Lawson's&160;on-going support plan for Essbase We are in the midst of upgrading to Lawson 9.0 and Essbase 7.1. as well as evaluating our company's overall BI strategy. Our IT staff has heard rumors to the effect that Lawson's Essbase strategy is to offer support for one more version of Essbase then discontinue their support in favor of LBI.&160; If so, has an announcement been made&160;concerning the date Essbase support would&160;be discontinued
3 4497
by  k-rockJump to last post
08/11/2008 10:51 AM
2 Replies and 2503 Views DSSO with Tomcat for LBI 9.0.2???  2503  2 Started by  Deleted User Hi all... Can anyone clear up the whether DSSO works with tomcat for use with LBI 9.0.2&160; Thanks in advance for your assistance Dean-O
2 2503
by  John HenleyJump to last post
08/07/2008 9:47 AM
2 Replies and 2744 Views Connecting EJS (Quartz jobs) to ERS (Reports)  2744  2 Started by  Milo Tsukroff 'I've tried and tried but nothing comes.' - B.C. I want to&160;find out this about LBI reports:&160; - &160;What ran and did they run on time&160; - How long did the reports that ran take to run&160; I can get&160;information on what ran from ERS_REPORTS.&160; The most important fields are: REPORTID, INSTANCEID,&160;CREATED, REPORTNAME.&160; This is cumulative metadata on when each report ran, equivalent to the History for&160;reports in LBI. I can get information on the schedules...
2 2744
by  Chris MartinJump to last post
08/06/2008 1:28 PM
2 Replies and 2911 Views The SSO services tag is missing.  2911  2 Started by  Deleted User On our LBI 9.0.1.6 install on Windows we keep getting this error in our Tomcat stdout.log file We use DSSO and have our portal bound to Active Directory... What is this error telling us com.lawson.lawsec.authen.httpconnection.LHCException: getLogoutUrls: The SSO services tag is missing. &160;at com.lawson.lawsec.authen.httpconnection.LawsonHttpConnection.getLogoutUrls(Unknown Source) &160;at com.lawson.lawsec.authen.httpconnection.LawsonHttpConnection.doLogout(Unknown Source) &160;at c...
2 2911
by  Deleted UserJump to last post
08/06/2008 1:27 PM
7 Replies and 4075 Views Exporting LBI Rights?  4075  7 Started by  Milo Tsukroff The new ERD's for Reporting Services (RS) and Framework Services are nice.&160; Now here's another question - how can I export LBI rights&160; (Currently on LBI 9.0.1.10).&160; &160;There appears to be no mechanism available.&160; I have access to FSADM and RSADM via Crystal, and I think I could&160;write a report that would create a rights import file, if only I knew what&160;tables & fields. My goal is to put all of the users in our Production LBI into the Test LBI.&160; Right n...
7 4075
by  Milo TsukroffJump to last post
07/31/2008 1:48 PM
4 Replies and 4324 Views LRS/Crystal Report URLs  4324  4 Started by  Phil Simon Hello Does anyone know how to either assign or find the URL to published Crystal Reports in LRS&160; The scheduling tool Control M might be able to launch CR's once published on LRS.&160; However, when I click on 'properties' of a published report, I only get the generic: &160; http://portal.lawson.com/:8383/efs/goid=id351. Thanks. &160; &160; &160;
4 4324
by  Milo TsukroffJump to last post
07/29/2008 5:02 PM
11 Replies and 5890 Views Report showing actuals and budget  5890  11 Started by  Ruma Malhotra I am supposed to create a report using crystal and not reportwriter where I am showing the actual units and budget. I am linking glunits and fbdetail. the only problem is there could be multiple budgets defined for the same period and when I link these 2 tables I am getting multiple rows. If I specify a budget no. then if tthere was an actual and no budget it does not get picked up. Has anybody tried to link these 2 tables. i am curious as to how the linking was achieved if anyone can share. T...
11 5890
by  John HenleyJump to last post
07/28/2008 10:17 AM
6 Replies and 2768 Views Reporting Question - basic outer join  2768  6 Started by  Phil Simon Hello I must be losing my mind.&160; I am attempting to write a Crystal Report against PAYMASTR in which employee information is pulled, regardless of whether they meet the 'date range' criteria&160;in the parameter. &160;SELECT 'PAYMASTR'.'NET_PAY_AMT', 'PAYMASTR'.'CHECK_DATE', 'EMPLOYEE'.'DATE_HIRED', 'EMPLOYEE'.'LAST_NAME', 'EMPLOYEE'.'FIRST_NAME', 'EMPLOYEE'.'EMP_STATUS', 'EMPLOYEE'.'EMPLOYEE' &160;FROM&160;&160; 'DB30_LAW_PROD'.'lawuser'.'EMPLOYEE' 'EMPLOYEE' LEFT OUTER JOIN 'DB3...
6 2768
by  John HenleyJump to last post
07/08/2008 3:56 PM
11 Replies and 5222 Views Archive Lawson backoffice reports in LBI  5222  11 Started by  Lorena We are migrating from Lawson AS400 to Lawson Unix and we need to find a solution to archive automatically the Lawson BackOffice reports in LBI. The AS400&160;keeps every report that the user runs. Unix is only keeping the last copy of the report. We need to have copies of some payroll reports and we do not want do it manually after each payroll. My question is:&160;Is it possible to do it automatically&160;once the Payroll job is completed If yes, how it can be&160;achieved Thanks, Lo...
11 5222
by  LorenaJump to last post
06/25/2008 2:29 PM
0 Replies and 3820 Views LBI vs. The Advisory Board's Spend Compass  3820  0 Started by  JonA Is anyone out there using The Advisory Board's Spend Compass for business intelligence How does it compare to LBI.&160; What can Spend Compass do that LBI cannot and vice versa &160; &160; J
0 3820
06/18/2008 4:59 PM
1 Replies and 2872 Views Control M, Windows Terminal Server, and Crystal X Rpts  2872  1 Started by  Phil Simon Hello Has anyone ever used the scheduling tool from BMC called control M to schedule Cyrstal Reports on a Windows Terminal Server&160; We are looking at doing this and wanted to see if anyone had any input, sites, recommendations, etc.&160; We've heard that you can do it but that it's tricky.&160; The goal here is to use one scheduling tool.&160; Also, LRS-based scheduling does not allow for contigencies; in other words, if rpt A fails, then do not run rpt B. Thanks! ps
1 2872
by  k-rockJump to last post
06/05/2008 11:23 AM
5 Replies and 3507 Views Issue with LBI login  3507  5 Started by  Ruma Malhotra We have recently upgraded to LBi version 9.0.2.2 on unix aix and websphere 6.1. When a user logins in and clicks on the LBI dashboards link it takes almost 40 seconds for all the dashboards to come up. This is an issue with all users and they would like to see the dashboard withing 2 seconds. Has anybody had any experience with this issue. Does anybody know where to look and wht we can change on our side so that the time reduces. Any help will be deeply appreciated. Thanks in advance, Ruma...
5 3507
by  Milo TsukroffJump to last post
06/02/2008 11:07 AM
3 Replies and 4170 Views LBI / SmartNotification SMTP Setting?  4170  3 Started by  Deleted User I've searched the knowledgebase and all the .properties and .xml files I can find, but couldn't find anywhere where the SMTP server is setup - I want to change it since we got a new smtp server... can anyone tell me where could it be please Thanks! Jojo
3 4170
by  Deleted UserJump to last post
05/15/2008 8:48 PM
16 Replies and 12806 Views LBI Upgrade 9.0.2.2  12806  16 Started by  jkunkle We are currently upgrading our LBI from version 9.0.1.8 to 9.0.2.2 and we are currently receiving the below error message when we try to validate our Framework Services. Has anyone seen this before or experienced any other issues with 9.0.2.2 *****Error 500: (security:3016) A Repository Error happened during initialization of the User Repository. This could be because of incorrect initialization parameters in the sysconfig.xml, or insufficient permissions in the underlying database.
16 12806
by  WillJump to last post
05/14/2008 9:20 AM
2 Replies and 3795 Views Crystal Report Drill Down  3795  2 Started by  Deleted User Hi everyone, I'm new in lawson technology and in my group we start with LBI reports, in special scorecard and Crystal Reports. Our problem present when we try to do a drill down in a Cystal Report Document, due to an IOS Services problem, but&160;we dont know wath IOS Services are, or if it installed in my enviroment, i just know than we have a movex server, workplace server and an LBI server (FS,SC,SN). if i must install some other package what package is and where&160;we found it &16...
2 3795
by  John HenleyJump to last post
05/13/2008 10:31 AM
2 Replies and 3306 Views CE History of Report Instances not what they used to be  3306  2 Started by  Sheila Opelia I have created a report and scheduled it to run every Saturday evening during non-peak processing time.&160; I am selecting the most current pay record per emplyee from PAYMASTR.&160; If that record was issued within the last pay period (1 wk), then the employee has received pay and will be HIDDEN on the report.&160; If the record is older than that, then the employee did not receive pay and will DISPLAY on the report. if {PAYMASTR.CHECK_DATE} >= DateAdd('d', -7, CurrentDate)&160;&160;&16...
2 3306
by  Sheila OpeliaJump to last post
05/08/2008 9:32 AM
0 Replies and 2841 Views A ReportID or Name wasn't passed  2841  0 Started by  Phil Simon Hello I am using CRX and LRS.&160; I have a fairly involved CR with a bunch of groupings (9) off of PAYDEDUCTN (which has about 1,000,000 records). I tried to export this report to Excel from a dashboard and I received this message: A ReportID or Name wasn't passed . I looked at the KB but couldn't find anything.&160; Any help Thank you.
0 2841
05/07/2008 12:17 PM
5 Replies and 4378 Views Use of OLEDB and other non-Lawson Data sources  4378  5 Started by  debika_sharma If you're using Lawson's OLE DB component to build reports in Crystal, can you also&160;integrate data from other databases (non-Lawson)&160;with the objects available in OLE DB&160; Basically can you join a database table from a non-Lawson database with a Lawson database table available&160;in OLE&160;DB&160;
5 4378
by  John HenleyJump to last post
04/23/2008 3:31 PM
7 Replies and 4432 Views RW100/Crystal Reports - Upgrading to LSF 9  4432  7 Started by  Chris Martin I have a new client who's current environment is 8.x and are planning to upgrade to LSF 9 in the near future. They have quite a few Crystal Reports that utilize RW100 as a data source. I'm being told by Lawson Support that for any Crystal Reports that use RW100 as a data source must be completely rewritten from scratch for LSF 9. Does anybody know of a less painful way I don't have access to their LSF 9 environment yet so I haven't been able to try and find a better way myself.
7 4432
by  Chris MartinJump to last post
04/18/2008 8:08 AM
3 Replies and 2615 Views Report Development using Crystal  2615  3 Started by  debika_sharma When using Crystal reports: &160; 1.&160; Does an advanced report developer build reports through the web or through a client/desktop tool 2.&160; Can a business user/analyst perform ad-hoc analysis and create basic reports through the web or through a client/desktop tool 3.&160; How do the answers to 1 and 2 change (if at all)&160;when you use Crystal as a part of LBI
3 2615
by  John HenleyJump to last post
04/08/2008 12:09 PM
1 Replies and 2540 Views Crystal, LBI and Single Metadata/Business View  2540  1 Started by  debika_sharma Does the current version of Crystal Reports allow a data modeler to connect to disparate data sources and create a data layer of abstraction or business view for the enterprise so that business users can access the data they need through a single metadata layer&160; If so, is this 'business view' accessible to business users through the web &160; If you license LBI, is there still a single metadata and business view I would appreciate any input/feedback&160;from anyone that has had exper...
1 2540
by  John HenleyJump to last post
04/08/2008 11:53 AM
1 Replies and 2880 Views Report Default Permissions  2880  1 Started by  Phil Simon Hello Using LRS, does anyone know how to globally change someone's rights&160; For example,&160;ten reports have been&160;published for someone and, by default, that person's rights did not allow for an export, scheduling, etc.&160; Rather than go to each of the ten reports and 'override', can I just make a change and have that propagate to each report assigned to that personThanks. ps
1 2880
by  Chris MartinJump to last post
04/03/2008 12:56 PM
14 Replies and 7419 Views Lawson Business Intelligence using Crystal & Underlying Data Architecture  7419  14 Started by  debika_sharma Based on preliminary info and demos from Lawson, Lawson Business Intelligence uses Crystal Reports for relational reporting.&160;Does Crystal go directly against the Lawson transactional tables OR against a Lawstar schema If Crystal is going directly against the Lawson transactional tables, how is Crystal reports accessing the hierarchies which are stored in Lawson lists (MX* tables) Also, how is Crystal accessing a time dimension – which table or feature is fulfilling the role...
14 7419
by  John HenleyJump to last post
04/03/2008 7:50 AM
2 Replies and 4313 Views Lawson Business Intelligence: OLAP Questions  4313  2 Started by  debika_sharma Based on preliminary info and demos from Lawson, LBI uses MSOLAP/Hyperion Essbase for multidimensional/OLAP analysis. Would the multidimensional cubes (MSOLAP) be loaded directly from the Lawson transactional tables or from the tables in the star schema Can MSOLAP export files in a relational format Can MSOLAP send data from one cube to another&160; Can multiple cubes submit data to a summary cube Can MSOLAP handle rule based allocations and adjustm...
2 4313
by  John HenleyJump to last post
04/02/2008 2:05 PM
6 Replies and 3328 Views Days Of A Month  3328  6 Started by  Ruma Malhotra If year 2007 then days in feb is 28 if year is 2008 then days is 29. does anyone know how to calculate the days in a month in a year &160; Any help is appreciated. &160; Thanks, ruma.
6 3328
by  CharJump to last post
04/01/2008 1:02 PM
1 Replies and 10672 Views Tomcat in Production LBI  10672  1 Started by  Greg Moeller We are trying to run Tomcat in our production LBI instance. In conjunction with this, we have all of our users connecting via Citrix sessions to Lawson Portal where the LBI loads as their home page. Is it possible that Tomcat perceives all of these connection requests coming from the same source IP address as a DoS attack Yes, I know Lawson isn't certified on Citrix, but that is a strategic initiative here at the non-profit hospital that I work at. Also, does anyone else...
1 10672
by  Matthew NyeJump to last post
03/27/2008 1:17 PM
4 Replies and 4418 Views Employee Status - to and from  4418  4 Started by  Deleted User I understand that the&160;employee status&160;history is stored in the HRHISTORY table- it is field 20.&160; Now the part that I'm having trouble with is getting the status to display that is the one they were BEFORE the one I am running the report for.&160; Here is my SQL so far- &160;SELECT 'HRHISTORY'.'EMPLOYEE', 'HRHISTORY'.'FLD_NBR', 'HRHISTORY'.'BEG_DATE', 'HRHISTORY'.'A_VALUE' &160;FROM&160;&160; 'PRODLAW'.'HRHISTORY' 'HRHISTORY' &160;WHERE&160; 'HRHISTORY'.'FLD_NBR'=20 AND (...
4 4418
by  RyanJump to last post
03/12/2008 3:34 PM
3 Replies and 2640 Views Review Crystal Report  2640  3 Started by  Deleted User I have a report built from the review table that I post for all the managers to see - so that they know who is coming up due for an appraisal- and it also lists the reviews that have NOT been turned in late.&160; Unfortunately- since the REVIEW table does not hold the jobcode or department field- I have to link the REVIEW table to the EMPLOYEE table to be able to get the job code and department information.&160; Does anyone know of a way to make the correct jobcode/department that they are in ...
3 2640
by  Sam SimpsonJump to last post
03/12/2008 3:14 PM
4 Replies and 6092 Views Crystal Report question - how to get check, month, quarter, and yearly totals  6092  4 Started by  Phil Simon I need to create a payroll report that pulls current, month to date, QTD, and YTD deduction totals from PAYDEDUCTN, grouped by process level and deduction code. &160; Ideally, this report would look like this &160; Process level 100 &160; Deduction &160; Federal – T000 &160; YTD 1,000,000 QTD 277,777 MTD 80,000 9/21/07 40,000 &160; Process level 200 &160; Deduction &160; Federal – T000 &160; YTD 2,000,000 QTD 577,777 MTD 180,000 9/21/07 40,000 &160; &160; ...
4 6092
by  Phil SimonJump to last post
03/05/2008 9:25 AM
1 Replies and 2870 Views Differences between Crystal XI & Crystal XI R2  2870  1 Started by  Shasidhar Vemireddy We are currently on LBI 9.0.1.10 and Oracle 9i, we are upgrading to LBI 9.0.2.2 so that i can configure SSL encryption, i am upgrading to Oracle 10g since it is&160; a requirement. However i have a question about Crystal, we are currently using Crystal XI SP3, but LBI 9.0.2.2 is compatible with Crystal XI R2, i am not familiar with the Crystal&160; product and would like to know if there are major difference such as run-time performance etc in the new Crystal XIR2 version that will be compatib...
1 2870
by  k-rockJump to last post
02/27/2008 3:14 PM
5 Replies and 2823 Views report question - different data from Portal to CRX  2823  5 Started by  Phil Simon Hello I am running CRX for LRS using SQL Server 2005. I have my a rpt written via an SQL OLEDB connection for speed. I derived a 'date' field through text on PACOMMENTS. I get all four comments lines in CR when I run it locally but only the first line when I run it via Portal on the reporting server. Anyone ever have this issue Any suggestions
5 2823
by  Phil SimonJump to last post
02/20/2008 6:51 PM
5 Replies and 2947 Views Transferring from where?  2947  5 Started by  Deleted User In Lawson- it's easy to report on where someone transfers INTO.&160; But it's another story trying to report on where they transfered FROM.&160;&160; Does anyone know any easy ways to get this information in a Crystal report&160;
5 2947
by  John HenleyJump to last post
02/15/2008 3:44 PM
3 Replies and 3388 Views Personal Action Report Question  3388  3 Started by  Deleted User I am trying to clean up one of my personal action reports- and I hoped that someone might have some advice for me on how to do this.&160; We have action codes and reason codes in our PERSACTHIS table- when someone transfers departments in our organization we do a PA and mark them as ACTION_CODE&160; = DATACHG and then EITHER REASON_01 = TRANSDEPT OR REASON_02 = TRANSDEPT. When I try to bring in BOTH of those reason codes into ONE crystal report- my results get all messed up.&160; Currently ...
3 3388
by  Chris MartinJump to last post
02/15/2008 3:11 PM
4 Replies and 3729 Views LBI Upgrade to 9.0.2.2 - issues  3729  4 Started by  Milo Tsukroff In prepping for our LBI upgrade from 9.0.1.10 to 9.0.2.2, I've identified these issues that we need to address. Without resolving these questions, I can't give The Boss an accurate install estimate. Any help people can give me would be appreciated. I'm hoping that this list of loose ends will help others who are going through this same agony. Issue Issue Description ------- --------------------------------------------------------------- 1 'Apply CTP 48291' That'...
4 3729
by  Greg MoellerJump to last post
02/05/2008 3:37 PM
23 Replies and 20975 Views Date Syntax  20975  23 Started by  Deleted User Completely new to Crystal Reporting: The field 'SCHED-DATE' in an Oracle table displays '01-Jan-2008 12:00:00 AM' When i try to run the following formula: {REVIEW.SCHED-DATE} in {Beginning Date} to {Ending Date} Diplays Zero (0) result. And I know for a fact that these records exists. I set up the parameter fields (Beginning Date & Ending Date) to 'Date'. During execution, the only accepted format is 'yyyy-mm-dd'. I've also tried ...
23 20975
by  Deleted UserJump to last post
01/11/2008 7:08 AM
1 Replies and 10671 Views LSF9 -n- LBI -n- high CPU  10671  1 Started by  Greg Moeller Hi all!! We recently updated to LSF9 technology running on a Sol 10 box. We also have LBI running on 3 windows servers in a distributed formation with Tomcat and Oracle database. Not sure if this was happening before our implementation of DSSO or if it's new, but our LBI dashboards seem to be refreshing themselves every 60 seconds whether you are doing anything with them or not. This is causing very high CPU utilization on our LSF9 box (4 SPARC CPU's and 32 GB RAM) 95 and...
1 10671
by  Greg MoellerJump to last post
01/10/2008 11:24 AM
1 Replies and 10758 Views LBI Windows Server Requirement  10758  1 Started by  Sreenivasa Komma Our company is planning LSF9 and LBI implementations. Our company standard is Webspehere on AIX but it seems LBI needs Websphere on Windows. We are trying to understand the real reason behind it. Why can't LBI work with Websphere on AIX. Any insight is much appreciated. Thanks Sreeni
1 10758
by  Greg MoellerJump to last post
01/09/2008 4:01 PM
6 Replies and 11676 Views Enterprise Reporting Script loading problems  11676  6 Started by  Deleted User Let me start out by saying that I'm not a Lawson wiz. I'm merely a user who, after having IE 7.0 loaded on my pc, can't run Enterprise Reporting. I have Windows XP. I believe we use crystal reporting. My LDS group here at my company wants to completely reimage my PC which is so painful. Here's the error I get when I try to access Enterprise Reporting: 'Error, unable to load Enterprise Reporting script (/epm/reporting.js). Enterprise Reporting has not been properly initialized...
6 11676
by  Greg MoellerJump to last post
01/04/2008 12:45 PM
17 Replies and 14373 Views Linked subreports  14373  17 Started by  ChrisM Hello Crystal XI and SQL Server 2000 I've created a linked subreport, so that the main report can collect two parameters, company group and fiscal year, from lists rather than the user typing them in. The linked subreport picks up these two parameters and then collects another three. This works a treat in Crystal and means I get the best of both worlds - server-side filtering and parameters from picklists. However, when I publish the report and attempt to run it, I get two parame...
17 14373
by  ChrisMJump to last post
12/19/2007 12:41 AM
10 Replies and 11868 Views LBI Error  11868  10 Started by  Marc Has anyone seen this error. I am having troubles creating an instance on a report and keep getting this error. The string is non-numeric. Details: errorKind The string is non-numeric. Error in File E:\TEMP\{59CDEF6F-DD88-407B-B733-9378F9645DC3}.rpt: Error in formula . 'tonumber({Convert Date to Period})' The string is non-numeric. Details: errorKind Unable to retrieve Object. The string is non-numeric. Details: errorKind The string is non-numeric. Error in File E:\TEMP\{59CD...
10 11868
by  MarcJump to last post
12/18/2007 2:35 PM
4 Replies and 11961 Views OLEDB issue/number of reports  11961  4 Started by  Phil Simon Lawson has told one of my clients that you can't deploy and run 100 or so Crystal Reports written via OLEDB throughout an organization and that all reports should be rewritten via ODBC. Has anyone heard of this All prompts (dynamic and static) don't work and Lawson claims that OLEDB is not meant to be used for such a large number of reports. Obviously, this is nowhere in the support site documentation. Thoughts Thanks.
4 11961
by  Chris MartinJump to last post
12/07/2007 4:59 PM
2 Replies and 12123 Views LRS / LBI vs. Microsoft REporting Services  12123  2 Started by  Joe O'Toole I'm looking for a reference that uses or has used both MRS and LRS/LBI. Specifically, I would like to understand how these products compliment each other, what each can do that the other cannot and where the overlap is. We're currently at V 8.03 of Env and Apps and just started to use MRS for some non Lawson reporting. We will be installing LRS 9 after we get on LSF 9 and will need to make a decision on which tool would be best to rewrite our legacy Lawson and non Lawson reports with. Thanks.
2 12123
by  John HenleyJump to last post
12/04/2007 2:31 PM
2 Replies and 12137 Views DSSO with LBI  12137  2 Started by  Deleted User I have installed the Distributed Single Sign On jar files on my LBI server. I have run the config assitant and install validator and the smoke test and everything checks out. When I try and log into efs I get the login/pw box. I enter my log in password and then I get a blue screen saying 'I don't know this came from a trusted site'. My tomcat logs on the the LBI server show nothing and neither to my webshpere logs on the server. Any help would be greatly appreciated.
2 12137
by  Greg MoellerJump to last post
12/03/2007 3:16 PM
0 Replies and 10317 Views Lawson Backoffice Report Bursting  10317  0 Started by  Joyce Reveille Is anyone familiar with bursting Lawson backoffice reports that orginate on an iSeries Has anyone added XML tags to custom reports then bursted in Reporting Services
0 10317
11/14/2007 9:44 AM
5 Replies and 11849 Views Suggestions on Learning SQL  11849  5 Started by  Kate Liamero John, We use crystal XI against an oracle 10g database to publish reports to LBI Dashboards, and I am SQL impaired. I guess if I have to teach myself some basics I should be looking at an Oracle based SQL. Do you have any suggestions Any good book Ideas I know some of the reports can take forever to run. Thanks Kate
5 11849
by  Phil SimonJump to last post
11/07/2007 2:43 PM
0 Replies and 10395 Views Reporting Services Events  10395  0 Started by  jjcyeshua Hi! i would like to ask anyone who have worked with RS to may be help me understand RS Events. Specifically Parameter Selection. I have read the documentation but i'm still lost. Is there anyone out there who has sample, or have worked with RS Events.. I would really appreciate it you guys could enlighten me about this... Thank you..
0 10395
10/26/2007 12:56 PM
9 Replies and 12170 Views Query and Report Puzzle  12170  9 Started by  Deleted User Thanks in advance for any clues! I am from scratch (not DME due to using ODBC) writing a query in Crystal Reports. Below I have 2 tables (Employee & PRDISTRIB). What this is to report is payroll deductions by deduction. So within PRDISTRIB (and there might be a better Lawson table) I have a record for each single deduction (e.g. Check 502 for Mary Brown will have maybe 6 records or more, $10 Dental, $25 Health, $5 Uniform, etc.). So with this query and my corresponding report I get the e...
9 12170
by  Chris MartinJump to last post
09/25/2007 1:12 PM
4 Replies and 10411 Views Syntax Question  10411  4 Started by  Deleted User I have a query below that is erroring that the 'FROM' is not in the correct place... any clues.... Thanks! SELECT EMPLOYEE.EMPLOYEE, EMPLOYEE.FICA_NBR, EMPLOYEE.LAST_NAME, EMPLOYEE.ADDR1, EMPLOYEE.CITY, EMPLOYEE.ADDR2, EMPLOYEE.DEPARTMENT, EMPLOYEE.TERM_DATE, substr(DEPARTMENT,4,2), EMPLOYEE.ZIP, trim(employee.city) || ', ' || trim(employee.state) || ' ' || trim(employee.zip) as city_st_zip...
4 10411
by  Chris MartinJump to last post
09/24/2007 11:48 AM
1 Replies and 15621 Views Dynamic/Cascading prompts with LBI  15621  1 Started by  Phil Simon HRHISTORY: There are 1,400,000 records in this table and CRXI via OLEDB command is taking forever. Date parameters haven't helped too much. I would suspect that the ODBC route would be much easier but Lawson's told me that the dynamic/cascading prompts are only failsafe with OLEDB. Any suggestions here Thanks.
1 15621
by  John HenleyJump to last post
09/21/2007 8:27 AM
4 Replies and 10551 Views Query to split string into two parts  10551  4 Started by  Deleted User I am trying to split a number into two parts and wondering if anyone has a suggested syntax (e.g. 107511 split into 107 and 511 and then alias each with the 'AS' keyword.) Thanks! Chris Martin posted this when I was trying two join 3 fields into one (I'm kinda doing the reverse now): trim(last_name) || ', ' || trim(first_name) || ' ' || case when trim(middle_init) is null then trim(middle_init) else trim(middle_init) || '.' end
4 10551
by  John HenleyJump to last post
09/20/2007 10:39 AM
3 Replies and 10130 Views join City, State Zip  10130  3 Started by  Deleted User I've used Chris' method to join First M. Last Names together (trim(last_name) || ', ' || trim(first_name) || ' ' || case when trim(middle_init) is null then trim(middle_init) else trim(middle_init) || '.' end) and was wondering if the same would work to join 'City, State Zip' and keep the single spaces in. Thanks!
3 10130
by  Chris MartinJump to last post
09/20/2007 10:15 AM
3 Replies and 10482 Views Repository Database  10482  3 Started by  Deleted User Does anyone have a recommendation for the setup of the Repository Database used with LBI. Our Lawson databases exist on a remote Sun Solaris box seperate from the Lawson application box. Do we have to use Oracle as our repository database Does it have to be on the same box as the Lawson database Or, could we use SQL Server as the repository database and the OLAP Analysis and place it on the LBI box
3 10482
by  Chris MartinJump to last post
09/19/2007 2:44 PM
1 Replies and 10387 Views Possible Join Query Prob.  10387  1 Started by  Deleted User Thanks in advance... I have this query below, which was working fine till I added 'DEPTCODE.DEPARTMENT, DEPTCODE.NAME' and included 'DEPTCODE' in the FROM clause... this was to pick up the department name associated with the employee... I'm guessing I need an additional JOIN clause (nested) SELECT EMPLOYEE.EMPLOYEE, EMPLOYEE.LAST_NAME, EMPLOYEE.DEPARTMENT, EMPLOYEE.POSITION, EMPLOYEE.FIRST_NAME, DEPTCODE.DEPARTMENT, DEPTCODE.NAME, PAYDEDUCTN.EMPLOYEE, PAYDEDUCTN.CHECK_ID, PAYDEDUCTN.WAGE...
1 10387
by  Chris MartinJump to last post
09/19/2007 8:45 AM
4 Replies and 10668 Views Query syntax error  10668  4 Started by  Deleted User Thanks in advance... I have a manually written query I'm testing to join 3 name fields into one field. Here's what I have which needs to output in a format like 'Doe, John M.': SELECT EMPLOYEE.EMPLOYEE, (&91EMPLOYEE.LAST_NAME&93 & ', ' & &91EMPLOYEE.FIRST_NAME&93 & &91EMPLOYEE.MIDDLE_INIT&93 &'.') AS FULLNAME, FROM EMPLOYEE I get an Oracle 936 'missing operation' message. Any clues
4 10668
by  Chris MartinJump to last post
09/14/2007 11:13 AM
3 Replies and 11784 Views ODBC Connection problem.  11784  3 Started by  jjcyeshua Hello.. I need help. I am having problem creating sql expression). When i tried creating an sql command, it works perfectly, but when i just create sql expressions thats when i get the error message.. Also when I use sql command to pull all the data that I need, the report runs very..very..very slow…. Please help… Thanks Error in compiling SQL Expression: Database Connector Error: '42000:&91Microsoft&93&91ODBC SQL Server Driver&93&91SQL Server&93Incorrect syntax near the keyword ...
3 11784
by  John HenleyJump to last post
09/13/2007 7:40 PM
4 Replies and 12261 Views Crystal parameters - defaulting  12261  4 Started by  Phil Simon Hello I was wondering if anyone figured out how to do this. I have a parameter at the command level for PRTIME that will limit the records pulled, since that table gets to be big. TR-DATE = To compare paychecks, I have another command set to PRTIME with the same parameters: TR-DATE = Ideally, someone can put in parameter 1 = 7/1/07 and parameter s 7/15/07 so you can compare both paychecks. However, OLEDB's command builder isn't liking adding the...
4 12261
by  Phil SimonJump to last post
08/14/2007 2:54 PM
5 Replies and 12501 Views New tool I want to share....  12501  5 Started by  Shane Jones Report Bursting..... I have a bunch of Crystal Reports that I wanted to be able to group by manager and send automatically (by email) to 200 different managers. However, I have always needed to print the report and interoffice mail it. I found a tool called PDF-eXplode that allows me put a simple tag in the header and it will send the report to the managers by email... all from one report I have done a couple simple tests and they worked - tomorrow I am sending my first produc...
5 12501
by  Chris MartinJump to last post
08/14/2007 2:47 PM
1 Replies and 10711 Views ODBC views and OLEDB commands in same rpt?  10711  1 Started by  Phil Simon Hello CRXI OLEDB 9.0.3 I doubt that the answer is 'yes', but can you create views in SQL Server 2005 and link them on the same report to OLEDB commands If you do this, then are there any visibility issues with the data Thanks. ps
1 10711
by  John HenleyJump to last post
08/13/2007 2:32 PM
4 Replies and 11309 Views Crystal Parameters for QB 9.0.3  11309  4 Started by  Phil Simon Hello I saw the KB article on Crystal Parameters called: Passing parameters from Crystal to OLE DB Object Services Description: How do I pass a Crystal Parameter to an OLE DB Object Services DME query **** A few things here: Note: Date fields and certain conditional fields cannot be used. *** I was able to add a date prompt and it worked like a charm. Is this simply a matter of Lawson's documentation not being updated ...
4 11309
by  Phil SimonJump to last post
08/07/2007 7:29 AM
3 Replies and 11874 Views Implement LBI  11874  3 Started by  Deleted User We would like to know how much is involved in implementing the LBI module. We would do this minus the process flow for starters. Can anyone offer insight on the complexity involved Did you utilize outside consultants or Lawson for the implementation
3 11874
by  Chris MartinJump to last post
08/06/2007 2:34 PM
4 Replies and 11939 Views PA26 - REVIEW table  11939  4 Started by  Deleted User We are Lawson 8.03, Oracle. Recently we applied CTP 45859, and program PA702 - Updates Next Review dates, and Scheduled dates. However, I have a lot of 01/01/1700 dates showing up in the Next Review, and Last Review date fields. Obviously this impacts the several Joint Commision reports that I have, so I am wondering is ther a way in Crystal that I can get the best sequenced record fromt hat REVIEW table Ex: Employee 359323 has 3 records on the table. First one is blank on N...
4 11939
by  Phil SimonJump to last post
08/06/2007 6:46 AM
1 Replies and 10949 Views changing data sources  10949  1 Started by  Phil Simon Hello All It doesn't appear that Lawson will let you do this easily. I have a CRXI rpt via an OLEDB command in Query Builder linked to a TEST product line. I want to switch it to an ODBC connection to a different product line, obviously without the command. Changing the data source in CR doesn't seem to let me do this. It's not a big deal but I'm curious to see if any of you have been able to figure that one out. Thanks.
1 10949
by  John HenleyJump to last post
07/27/2007 10:06 AM
2 Replies and 11662 Views Query Builder vs. Oracle/SQL Server views  11662  2 Started by  Phil Simon Hello I was wondering if anyone cared to share his/her thoughts on using Query Builder vs. Views. I know that QB has the built-in Lawson security but am wondering if reporting performance will suffer as more than a handful of tables are added for Crystal Reports (deployed via LBI). In some cases, the way that the data is stored in different tables (PRSAGDTL, for example) isn't ideal for the way that 'normal' end-users look at it. Using SQL server to create a view in the dB wouldn't by ...
2 11662
by  Phil SimonJump to last post
07/27/2007 7:45 AM
12 Replies and 14510 Views Crystal and Lawson's OLE DB  14510  12 Started by  Bob Beverley I'm able to generate reports in Crystal using the Lawson Connector (not by choice, but it's the way the client wants me to connect). Couple of issues: 1. When I first run the report I am prompted that the table isn't recognized and I have to respond 'No' to 'do you want to remove the table from the report'. However, the report runs successfully. Why is it that Crystal doesn't think it's a valid table 2. When I view the SQL (Database/Show SQL Query) I get just a list of the tables w...
12 14510
by  John HenleyJump to last post
07/26/2007 4:17 PM
0 Replies and 10952 Views general publishing tips  10952  0 Started by  Phil Simon Hello Can anyone provide experiences with publishing (in LBI) using ODBC vs. OLEDB I am finding that I'm getting some different results based on the type of conenction used in CRXI developing the report. Part of me thinks that this shouldn't matter but I've seen some discrepancies even in CR using ODBC vs. OLEB. Is LBI agnostic or pro-OLEDB Thanks. ps
0 10952
07/19/2007 11:42 AM
8 Replies and 11674 Views Can't see all tables  11674  8 Started by  Fernando Labrada Crystal XI using Oracle ODBC driver. When I create a new ODBC connection to a Lawson environment and I select a data area within that environment, only the tables that start from AC to MM (including all the L_) show up. Anything past MM does not. If I use the same ODBC connection and use Access instead of Crystal, I can see all the tables beyond those that start with MM. Has anyone else had this issue
8 11674
by  Phil SimonJump to last post
07/19/2007 11:37 AM
2 Replies and 10592 Views two Crystal/Add-in questions  10592  2 Started by  Phil Simon Hello I seem to recall that you can point previously-created .dme's to different product lines so you don't have to recreate them. Any idea about how to do this Also, I also vaguely recall that you can create a .dme and use that as the basis for a Crystal report. We're running Crystal XI off of LSF on SQL Server 2005. For some reason, I thought that you could cut and paste it but can't for the life of me remember how to do that. Thanks.
2 10592
by  Phil SimonJump to last post
07/18/2007 9:36 AM
1 Replies and 11303 Views Using ODBC to connect to LAwson through Crystal.... Will this be an issue with the upgrade to Crystal XI???  11303  1 Started by  Shane Jones I use ODBC to connect to LAwson through Crystal.... Will this be an issue with the upgrade to Crystal XI
1 11303
by  John HenleyJump to last post
07/17/2007 7:09 AM
5 Replies and 11285 Views general reporting question  11285  5 Started by  Phil Simon I really enjoyed the series on reporting. Let me make sure that I understand XI's limitations with Lawson's OLEDB connector. While you get the benefit of security, you have the disadvantage of reporting on only 'Lawson-approved' relationships). As a result, more complex reports aren't possible without some creativity. You wrote about the benefits of doing Crystal Reports based on SQL queries. For this to work through Crystal Enterprise for light users (i.e., not hard core developers on t...
5 11285
by  Phil SimonJump to last post
07/12/2007 2:36 PM
3 Replies and 10756 Views Crystal and Lawson  10756  3 Started by  Deleted User We are currently using version 8.0.3 Applications, 8.0.29 Environment and Crystal Enterprise 8.5. We will be upgrading soon and I am trying to find out if anyone knows what versons of Crystal are compatible with the Lawson 8.0.3 Environment. We will be moving to the Lawson 8.0.3 environment later this summer, with a move to 9.0.0 sometime next year. So that is two Environment upgrades and I am only looking to make one upgrade of Crystal to the highest version available that is compatible with...
3 10756
by  John HenleyJump to last post
05/24/2007 12:18 PM
0 Replies and 11020 Views Framework and LRS Validation Problems  11020  0 Started by  Larry Taylor I installed Framework Services 1.2 and the install validator passes all tests with flying colors. Next, I installed Reporting Services, ran the install validation process and again, every passes with flying colors. I've Registered Reporting Services/Framework Services, and again, no problems. I can publish any type of report that I want and during the publication process, the report loads and displays just fine. The problem that I am experiencing is that when I mount a published report on a dash...
0 11020
05/11/2007 1:07 PM
0 Replies and 10825 Views Mandatory Education Reports  10825  0 Started by  Deleted User Lawson 8.03 I wrote a report using PATRNHIST, EMPLOYEE to capture the Employee Training/Course history. There are a few Mandatory Courses that encompass several Course Numbers - For example: BLS Course is select {PATRNHIST.COURSE} case '2C00000001': ToText({PATRNHIST.DATE_COMPLETED}, 'M/dd/yyyy') Case '2C00000002': ToText({PATRNHIST.DATE_COMPLETED}, 'M/dd/yyyy') case'2C00000003': ToText({PATRNHIST.DATE_COMPLETED}, 'M/dd/y...
0 10825
03/21/2007 11:13 AM
7 Replies and 12685 Views LBI/LRS and Crystal Report using ODBC Driver  12685  7 Started by  Kate Liamero We have crystal reports designed using data direct ODBC driver to oracle database 10G. The datasource that we are using to design the reports are also setup on our LBI/LRS servers exactly the same way. We have PROD TEST and DEV environments. PROD and TEST are remote installs with the db, apps and lbi/lrs residing on 3 different servers. DEV is all on one box. DB and APP boxes are Unix/Sun. LBI/LRS Windows Version 9 for everything. We are saving the login information with the ...
7 12685
by  John HenleyJump to last post
03/12/2007 7:53 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 4 of 5 << < 12345 > >>


RSS Feed Available