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
3 Replies and 1695 Views DME Full Outer Join fakeout  1695  3 Started by  Darin Greetings, &160; Basics:&160; Using OLE&160;DB and accessing Lawson tables for a Crystal Report.&160; Windows, Lawson 9, CR2008 SP2.&160; From within CR I open the database expert, add command, alias the tables I need, pick the fields...then go on to the next table.&160; Total joins=4 on 5 tables, all left outer joins with ACTRANS as the 'master'. I'm trying to pull information for budget details based on activities and need to join ACBUDDTL and ACTRANS...and I need all activities from ...
3 1695
by  DarinJump to last post
11/05/2009 12:21 PM
1 Replies and 1230 Views Upgrade Question  1230  1 Started by  mark.cook We are upgrading our lawson system on a new lpar.&160; I need to update all of my reports, smartnotes and links to the new lpar/database. Does anyone have any tips or tricks on the easiest way to accomplish this task
1 1230
by  Patrick DowdJump to last post
10/31/2009 11:34 AM
0 Replies and 1624 Views Get BL Invoice data AND Comment Attachment on one Crystal Report  1624  0 Started by  Lance Kelley Issue:I need to produce a BL Invoice from Crystal Reports (CR) AND include BL comments to help explain the reason for the invoice to our customers. Using the OLE DB connector within Crystal Reports (CR) 2008, I can pull up the table info with a DME Query, and separately, I can pull up one associated BL Invoice attachment with a getattachrec Query, but I can't seem to put the two together on one report.&160; Anyone done this before BL&160;recurring invoice comments are stored in (BL30....
0 1624
10/30/2009 5:58 PM
2 Replies and 2987 Views error trying to resource data on a Crystal report  2987  2 Started by  Deleted User ado error code 0x80004005 cannot open database requested I&160;have a Crystal report that uses a SQL&160;Server stored procedure as the data source. We have modified the stored proc at times, I've changed the data source on the report and sent it for republishing. Somehow, last week, this all changed and I can no longer change the data source on the report. We checked and I&160;do have EXEC&160;permissions but I&160;still get the error. I&160;have uninstalled and reinstalled Crystal. We a...
2 2987
by  Deleted UserJump to last post
10/28/2009 9:21 AM
0 Replies and 2030 Views integrating Lawson data with Cognos data warehouse  2030  0 Started by  Deleted User We were wondering if anyone has integrated Lawson data with a data warehouse and would appreciate any information on how you did it, how it went, what you wish you'd known beforehand, vendors (good or bad), etc. Thank you in advance!
0 2030
10/26/2009 3:25 PM
0 Replies and 1560 Views IA150 Incremental Load - SSAS  1560  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 1560
10/23/2009 1:16 PM
0 Replies and 1353 Views LBI Roundtable Webinar  1353  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 1353
10/21/2009 1:04 PM
19 Replies and 7966 Views Wanting to use Crystal Reports  7966  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 7966
by  riegerjJump to last post
10/06/2009 1:30 PM
3 Replies and 1428 Views Users attached to Rights  1428  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 1428
by  Ruma MalhotraJump to last post
10/05/2009 10:21 AM
1 Replies and 1362 Views HR Index EMPSET3 Report Issue  1362  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 1362
by  John HenleyJump to last post
10/03/2009 6:07 PM
2 Replies and 1888 Views crystal training  1888  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 1888
by  muffntufJump to last post
09/28/2009 4:04 PM
1 Replies and 1163 Views ERRORS :Smart_Notification_Installation_Validator  1163  1 Started by  HD Could anyone help me take a look at my report and point me in the right way
1 1163
by  Jimmy ChiuJump to last post
09/24/2009 12:02 PM
1 Replies and 1488 Views LBI on Vmware  1488  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 1488
by  Jimmy ChiuJump to last post
09/21/2009 3:05 PM
0 Replies and 1504 Views Cash Codes  1504  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 1504
09/18/2009 12:20 PM
1 Replies and 1286 Views Indexes to access  1286  1 Started by  muffntuf Hi all, Any indexes I can use to help speed up AR and AP Distrib reports Thanks!
1 1286
by  NormJump to last post
09/18/2009 11:28 AM
3 Replies and 2422 Views Associate a APPAYMENT Invoice with GL Trans  2422  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 2422
by  muffntufJump to last post
09/17/2009 3:27 PM
1 Replies and 1468 Views What am I missing? - GL Q  1468  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 1468
by  muffntufJump to last post
09/14/2009 6:22 PM
1 Replies and 1198 Views Cons for environment and LBI in the same server?  1198  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 1198
by  Patrick DowdJump to last post
09/14/2009 4:49 PM
1 Replies and 1535 Views CRAS SP's  1535  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 1535
by  Patrick DowdJump to last post
09/10/2009 8:59 AM
3 Replies and 1412 Views User signon credentials not enabled for Enterprise Reporting Server  1412  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 1412
by  BBryantJump to last post
09/10/2009 8:45 AM
1 Replies and 1295 Views DSSO on virtual machine  1295  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 1295
by  JanisJump to last post
09/09/2009 8:48 AM
1 Replies and 1742 Views Options for big back office reports in LBI  1742  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 1742
by  kflores01Jump to last post
09/03/2009 3:19 PM
5 Replies and 2189 Views OleDB Filter Syntax  2189  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 2189
by  John HenleyJump to last post
09/02/2009 1:12 PM
4 Replies and 3638 Views Export a scheduled LBI report to excel DATA ONLY format  3638  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 3638
by  Ruma MalhotraJump to last post
09/02/2009 10:55 AM
1 Replies and 1514 Views DEVELOP A REPORT FOR PO CHANGES  1514  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 1514
by  cmarcousJump to last post
08/31/2009 10:46 AM
9 Replies and 3898 Views LBI Error when publishing Crystal Report  3898  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 3898
by  JanJump to last post
08/25/2009 2:42 PM
7 Replies and 2024 Views Data source / sql question  2024  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 2024
by  vc727Jump to last post
08/20/2009 10:23 AM
6 Replies and 3880 Views LBI Report link in Lawson Portal  3880  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 3880
by  Kate LiameroJump to last post
08/18/2009 4:01 PM
1 Replies and 1482 Views I want to burst a non-lawson text report with LBI  1482  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 1482
by  Matthew NyeJump to last post
08/18/2009 12:50 PM
4 Replies and 1510 Views Adding Links to LBI Dashboards  1510  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 1510
by  SaurabhJump to last post
08/18/2009 9:13 AM
4 Replies and 4025 Views Summarized Transactions  4025  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 4025
by  muffntufJump to last post
08/17/2009 2:17 PM
0 Replies and 1296 Views vague errors  1296  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 1296
08/17/2009 12:25 PM
1 Replies and 1584 Views Report Owner  1584  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 1584
by  Matthew NyeJump to last post
08/17/2009 7:42 AM
4 Replies and 1636 Views Section Visibility Issue with Positioning Subtotals  1636  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 1636
by  CharJump to last post
08/14/2009 8:28 AM
2 Replies and 1485 Views BR21 - how does this work?  1485  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 1485
by  muffntufJump to last post
08/13/2009 3:38 PM
1 Replies and 2165 Views Subsystems for Cash Reconciliation  2165  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 2165
by  muffntufJump to last post
08/11/2009 12:08 PM
2 Replies and 1621 Views ARDISRIB question  1621  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 1621
by  muffntufJump to last post
08/10/2009 10:03 AM
3 Replies and 2317 Views IC234 Inventory Valuation Report  2317  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 2317
by  ShawnJump to last post
08/06/2009 10:09 AM
3 Replies and 1716 Views BR is in GLtrans R_System  1716  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 1716
by  muffntufJump to last post
08/05/2009 11:30 AM
0 Replies and 1403 Views LBI Rights setup on rights management on LBI  1403  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 1403
08/04/2009 11:39 AM
6 Replies and 1832 Views Datasource not populating on LBI  1832  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 1832
by  Ruma MalhotraJump to last post
08/03/2009 3:04 PM
12 Replies and 3491 Views RW and Account Lists  3491  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 3491
by  JuliaJump to last post
08/03/2009 11:35 AM
2 Replies and 2256 Views LBI hardware upgrade  2256  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 2256
by  Matthew NyeJump to last post
08/03/2009 8:19 AM
5 Replies and 3359 Views Crystal 2008 export to excel  3359  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 3359
by  TracyOJump to last post
07/29/2009 12:57 PM
3 Replies and 5479 Views Display Portal Page in LBI Dashboard?  5479  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 5479
by  MBMJump to last post
07/29/2009 12:43 PM
2 Replies and 1765 Views Dashboards Tab Order  1765  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 1765
by  Fernando LabradaJump to last post
07/28/2009 2:15 PM
3 Replies and 2852 Views Crystal reports Viewer display window freezes  2852  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 2852
by  jnwrightJump to last post
07/27/2009 1:47 PM
15 Replies and 2495 Views LBI and SSO Install  2495  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 2495
by  jellisJump to last post
07/27/2009 9:46 AM
6 Replies and 2512 Views Custom group in 9031  2512  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 2512
by  Ruma MalhotraJump to last post
07/27/2009 8:44 AM
2 Replies and 1862 Views Project Upgrade: LBI  1862  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 1862
by  Greg MoellerJump to last post
07/25/2009 6:13 PM
1 Replies and 1658 Views Reporting services default parameters is null  1658  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 1658
by  Any ideas?Jump to last post
07/25/2009 5:59 PM
9 Replies and 4203 Views Override datasource doesn't appear to work  4203  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 4203
by  mikePJump to last post
07/24/2009 2:12 PM
1 Replies and 1286 Views Multiple rows coming back - Cartesian  1286  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 1286
by  muffntufJump to last post
07/24/2009 1:33 PM
2 Replies and 1939 Views LBI/Crystal XI Failure to Process Prompt Error with Cascading Parameters  1939  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 1939
by  Charlotte ChaseJump to last post
07/23/2009 4:03 PM
4 Replies and 2560 Views GL Trans Obj-ID  2560  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 2560
by  Brad SchauerJump to last post
07/20/2009 3:38 PM
7 Replies and 1932 Views JE Number same as GTR-JRNL-BOOK-NBR?  1932  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 1932
by  Matthew NyeJump to last post
07/20/2009 10:49 AM
2 Replies and 1784 Views Group footer spacing  1784  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 1784
by  mclJump to last post
07/13/2009 2:28 PM
4 Replies and 1915 Views Report Schedules  1915  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 1915
by  Ruma MalhotraJump to last post
07/13/2009 10:59 AM
16 Replies and 6438 Views GLTRANS join check with APDISTRIB & APINVOICE  6438  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 6438
by  muffntufJump to last post
07/10/2009 4:28 PM
2 Replies and 2452 Views GL Sub Account Validation  2452  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 2452
by  Matthew NyeJump to last post
07/10/2009 10:34 AM
1 Replies and 1571 Views LBI EFS Login Hung  1571  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 1571
by  Matthew NyeJump to last post
07/09/2009 4:33 PM
3 Replies and 1665 Views Crystal report needs to reference non-odbc data  1665  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 1665
by  muffntufJump to last post
07/09/2009 2:24 PM
6 Replies and 3973 Views Reporting Invoice Date with GL Trans  3973  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 3973
by  muffntufJump to last post
07/09/2009 12:53 PM
3 Replies and 3506 Views Crystal for Financial Reporting  3506  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 3506
by  John HenleyJump to last post
07/02/2009 10:17 AM
6 Replies and 2427 Views Need prior quarter year to date  2427  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 2427
by  Milo TsukroffJump to last post
07/01/2009 12:47 PM
7 Replies and 7435 Views SI_STARTTIME Question  7435  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 7435
by  Deleted UserJump to last post
06/30/2009 12:13 PM
1 Replies and 1327 Views oledb index and filter settings  1327  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 1327
by  Ruma MalhotraJump to last post
06/05/2009 8:42 AM
12 Replies and 3038 Views OLE db report for LBI 9031  3038  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 3038
by  Ruma MalhotraJump to last post
06/04/2009 4:42 PM
2 Replies and 1717 Views LBI and Crystal 2008 (11R3) Parameters Field  1717  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 1717
by  jellisJump to last post
06/04/2009 3:18 PM
3 Replies and 2738 Views LBI Bursting carrying through Crystal subreports  2738  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 2738
by  mark.cookJump to last post
06/01/2009 2:24 PM
3 Replies and 13209 Views Blank rows in excel export of crystal report  13209  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 13209
by  Shane JonesJump to last post
05/27/2009 10:24 PM
6 Replies and 2767 Views Hide Search Box on LBI  2767  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 2767
by  vc727Jump to last post
05/20/2009 12:10 PM
1 Replies and 2555 Views How to define parameters in a Crystal Report  2555  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 2555
by  Matthew NyeJump to last post
05/18/2009 2:58 PM
4 Replies and 1891 Views Multiple Environments and Multiple LBI Servers  1891  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 1891
by  Matthew NyeJump to last post
05/18/2009 1:37 PM
2 Replies and 1424 Views How to suppress Instance Name in a report history report list  1424  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 1424
by  JanJump to last post
05/13/2009 9:44 AM
2 Replies and 1817 Views Link to Process Flow Inbasket from Framework Services  1817  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 1817
by  vc727Jump to last post
05/12/2009 9:54 AM
1 Replies and 1941 Views Processing Limit Error hit  1941  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 1941
by  Matthew NyeJump to last post
05/11/2009 2:47 PM
2 Replies and 1993 Views Crystal Report - Group Tree in LBI displays Employee Number with commas  1993  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 1993
by  JanJump to last post
05/07/2009 12:28 PM
5 Replies and 2249 Views Crystal Report needs to have jdbc connection to more than one database  2249  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 2249
by  CharJump to last post
05/05/2009 4:00 PM
4 Replies and 1751 Views Crystal Integration Pack gone!?!?  1751  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 1751
by  Deleted UserJump to last post
04/30/2009 2:12 PM
5 Replies and 1955 Views One crystal report executing another crystal report ?  1955  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 1955
by  Matthew NyeJump to last post
04/17/2009 11:07 AM
0 Replies and 1409 Views new implementation design question  1409  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 1409
04/16/2009 2:09 PM
1 Replies and 1688 Views Rights Management Export  1688  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 1688
by  Matthew NyeJump to last post
04/15/2009 12:34 PM
0 Replies and 1368 Views Upgrade Question for LBI?  1368  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 1368
04/06/2009 9:11 AM
3 Replies and 2062 Views LBI implementation timing  2062  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 2062
by  Phil SimonJump to last post
04/03/2009 7:54 AM
1 Replies and 1799 Views Setting DataSource in Smart Notification  1799  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 1799
by  Matthew NyeJump to last post
04/01/2009 8:15 AM
1 Replies and 1956 Views LRS- Report question  1956  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 1956
by  Matthew NyeJump to last post
03/27/2009 3:41 PM
2 Replies and 1964 Views SQL to link APDISTRIB to PO line Details  1964  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 1964
by  Peter BraytonJump to last post
03/27/2009 9:27 AM
6 Replies and 2164 Views How to show better report description in dashboard  2164  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 2164
by  JanJump to last post
03/25/2009 2:10 PM
2 Replies and 5894 Views Invoice comments report  5894  2 Started by  Ruma Malhotra Has anybody tried to query the invoice comments table to create a report.
2 5894
by  Peter BraytonJump to last post
03/25/2009 8:30 AM
4 Replies and 2824 Views Easiest way to create Balance Sheet in Crystal from Lawson  2824  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 2824
by  John HenleyJump to last post
03/20/2009 2:49 PM
4 Replies and 5850 Views LBI Report Scheduling Options  5850  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 5850
by  lagapisJump to last post
03/18/2009 12:53 PM
1 Replies and 1839 Views Daylight Saving patch  1839  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 1839
by  Chris MartinJump to last post
03/13/2009 10:31 PM
3 Replies and 2901 Views Crystal Report Viewer  2901  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 2901
by  Chris MartinJump to last post
03/12/2009 10:02 PM
4 Replies and 2225 Views Relate arapplied to oeoinvoice  2225  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 2225
by  John HenleyJump to last post
03/12/2009 9:39 AM
6 Replies and 3387 Views Dashboards & Modules For New Instance of LBI  3387  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 3387
by  Lenny MurneyJump to last post
03/11/2009 5:58 PM
15 Replies and 4730 Views Publishing LBI / Crystal  4730  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 4730
by  Joe O'TooleJump to last post
03/11/2009 4:39 PM
18 Replies and 3734 Views Viewing Reports from Portal  3734  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 3734
by  jellisJump to last post
03/10/2009 5:48 PM
2 Replies and 3172 Views RNI Aging report  3172  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 3172
by  Ruma MalhotraJump to last post
03/02/2009 12:48 PM
7 Replies and 2291 Views Websphere 6.1 Fix Packs-What Version?  2291  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 2291
by  Matthew NyeJump to last post
02/27/2009 1:34 PM
15 Replies and 3788 Views More Performance from LRS  3788  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 3788
by  Greg MoellerJump to last post
02/26/2009 10:35 AM
21 Replies and 12235 Views LBI Installed  12235  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 12235
by  jellisJump to last post
02/23/2009 4:21 PM
29 Replies and 17515 Views Access Lawson tables in MS Access  17515  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 17515
by  cmarcousJump to last post
02/06/2009 7:49 PM
8 Replies and 4470 Views LBI Documentation Help  4470  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 4470
by  Matthew NyeJump to last post
02/03/2009 1:29 PM
9 Replies and 3363 Views Heirarchial reporting using RW100  3363  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 3363
by  Kim92Jump to last post
02/03/2009 9:41 AM
6 Replies and 2937 Views LBI/Crystal cascading parameters  2937  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 2937
by  Deleted UserJump to last post
01/26/2009 1:40 PM
7 Replies and 2605 Views LBI user id / password question  2605  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 2605
by  Matthew NyeJump to last post
01/22/2009 4:33 PM
3 Replies and 2055 Views LBI 9.0 Elements and Structures  2055  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 2055
by  Deleted UserJump to last post
01/22/2009 10:58 AM
6 Replies and 2447 Views LBI 9 Reporting Issue  2447  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 2447
by  Matthew NyeJump to last post
01/22/2009 10:07 AM
3 Replies and 2650 Views Row Level Security in Crystal Reports  2650  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 2650
by  John HenleyJump to last post
01/15/2009 10:29 AM
2 Replies and 2667 Views Load Balancing RAS  2667  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 2667
by  jellisJump to last post
01/13/2009 6:52 PM
2 Replies and 2377 Views Links  2377  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 2377
by  A_R_ConsltntJump to last post
01/12/2009 12:54 PM
18 Replies and 11993 Views Inital LBI Implementation Questions  11993  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 11993
by  John HenleyJump to last post
01/11/2009 7:26 PM
0 Replies and 1739 Views Reporting, Part 7: Categorizing Reports  1739  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 1739
01/10/2009 12:02 PM
4 Replies and 9292 Views Data Dictionary  9292  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 9292
by  Greg MoellerJump to last post
12/15/2008 12:25 PM
3 Replies and 2535 Views Allow Multiple values for a parameter  2535  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 2535
by  John HenleyJump to last post
12/12/2008 12:13 PM
2 Replies and 2560 Views Repoint Crystal(Using Lawson OLE-DB)  2560  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 2560
by  Deleted UserJump to last post
12/03/2008 5:03 AM
2 Replies and 2832 Views Search inside crystal reports...  2832  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 2832
by  WillJump to last post
11/28/2008 4:58 PM
0 Replies and 1975 Views Is Lawson-Analytics Architect supports Essbase ASO applications?  1975  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 1975
11/12/2008 11:14 AM
0 Replies and 2090 Views How to change Essbase Application type in Lawson program  2090  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 2090
11/12/2008 8:55 AM
2 Replies and 2223 Views How do I hide the Tools dashboards from users?  2223  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 2223
by  mmanoscaJump to last post
11/07/2008 2:46 PM
0 Replies and 2155 Views Linking to a RS Crystal report from a Smart Notification  2155  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 2155
11/05/2008 11:01 AM
2 Replies and 4524 Views DME Syntax  4524  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 4524
by  jeremy.zerrJump to last post
10/23/2008 12:58 PM
4 Replies and 4536 Views Use Perl to query DME via HTTP  4536  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 4536
by  jeremy.zerrJump to last post
10/23/2008 12:32 PM
2 Replies and 2756 Views Crystal report links error?  2756  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 2756
by  Milo TsukroffJump to last post
10/10/2008 3:49 PM
3 Replies and 3613 Views Creating a Crystl Report against an ldap export ldif file  3613  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 3613
by  k-rockJump to last post
10/07/2008 4:19 AM
3 Replies and 2915 Views Connecting to a RW report  2915  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 2915
by  John HenleyJump to last post
09/15/2008 9:39 AM
1 Replies and 2414 Views LBI and SQL 2005?  2414  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 2414
by  Matthew NyeJump to last post
09/08/2008 1:05 PM
6 Replies and 3009 Views Adjust Alert Light Bulb Color  3009  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 3009
by  kflores01Jump to last post
09/04/2008 6:52 AM
5 Replies and 3413 Views Tying activities data in ACTRANS to ARDISTRIB  3413  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 3413
by  Deleted UserJump to last post
09/03/2008 3:16 PM
10 Replies and 4118 Views Compiled Reports in CRX?  4118  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 4118
by  John HenleyJump to last post
08/30/2008 10:55 AM
1 Replies and 2320 Views Viewing Scheduled Rpts in LRS  2320  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 2320
by  Chris MartinJump to last post
08/18/2008 11:00 AM
3 Replies and 4584 Views Lawson Support for Essbase  4584  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 4584
by  k-rockJump to last post
08/11/2008 10:51 AM
2 Replies and 2606 Views DSSO with Tomcat for LBI 9.0.2???  2606  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 2606
by  John HenleyJump to last post
08/07/2008 9:47 AM
2 Replies and 2818 Views Connecting EJS (Quartz jobs) to ERS (Reports)  2818  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 2818
by  Chris MartinJump to last post
08/06/2008 1:28 PM
2 Replies and 2957 Views The SSO services tag is missing.  2957  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 2957
by  Deleted UserJump to last post
08/06/2008 1:27 PM
7 Replies and 4168 Views Exporting LBI Rights?  4168  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 4168
by  Milo TsukroffJump to last post
07/31/2008 1:48 PM
4 Replies and 4427 Views LRS/Crystal Report URLs  4427  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 4427
by  Milo TsukroffJump to last post
07/29/2008 5:02 PM
11 Replies and 6034 Views Report showing actuals and budget  6034  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 6034
by  John HenleyJump to last post
07/28/2008 10:17 AM
6 Replies and 2828 Views Reporting Question - basic outer join  2828  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 2828
by  John HenleyJump to last post
07/08/2008 3:56 PM
11 Replies and 5315 Views Archive Lawson backoffice reports in LBI  5315  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 5315
by  LorenaJump to last post
06/25/2008 2:29 PM
0 Replies and 3894 Views LBI vs. The Advisory Board's Spend Compass  3894  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 3894
06/18/2008 4:59 PM
1 Replies and 2969 Views Control M, Windows Terminal Server, and Crystal X Rpts  2969  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 2969
by  k-rockJump to last post
06/05/2008 11:23 AM
5 Replies and 3549 Views Issue with LBI login  3549  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 3549
by  Milo TsukroffJump to last post
06/02/2008 11:07 AM
3 Replies and 4256 Views LBI / SmartNotification SMTP Setting?  4256  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 4256
by  Deleted UserJump to last post
05/15/2008 8:48 PM
16 Replies and 12902 Views LBI Upgrade 9.0.2.2  12902  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 12902
by  WillJump to last post
05/14/2008 9:20 AM
2 Replies and 3864 Views Crystal Report Drill Down  3864  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 3864
by  John HenleyJump to last post
05/13/2008 10:31 AM
2 Replies and 3386 Views CE History of Report Instances not what they used to be  3386  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 3386
by  Sheila OpeliaJump to last post
05/08/2008 9:32 AM
0 Replies and 2903 Views A ReportID or Name wasn't passed  2903  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 2903
05/07/2008 12:17 PM
5 Replies and 4460 Views Use of OLEDB and other non-Lawson Data sources  4460  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 4460
by  John HenleyJump to last post
04/23/2008 3:31 PM
7 Replies and 4464 Views RW100/Crystal Reports - Upgrading to LSF 9  4464  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 4464
by  Chris MartinJump to last post
04/18/2008 8:08 AM
3 Replies and 2659 Views Report Development using Crystal  2659  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 2659
by  John HenleyJump to last post
04/08/2008 12:09 PM
1 Replies and 2580 Views Crystal, LBI and Single Metadata/Business View  2580  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 2580
by  John HenleyJump to last post
04/08/2008 11:53 AM
1 Replies and 2942 Views Report Default Permissions  2942  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 2942
by  Chris MartinJump to last post
04/03/2008 12:56 PM
14 Replies and 7617 Views Lawson Business Intelligence using Crystal & Underlying Data Architecture  7617  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 7617
by  John HenleyJump to last post
04/03/2008 7:50 AM
2 Replies and 4369 Views Lawson Business Intelligence: OLAP Questions  4369  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 4369
by  John HenleyJump to last post
04/02/2008 2:05 PM
6 Replies and 3426 Views Days Of A Month  3426  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 3426
by  CharJump to last post
04/01/2008 1:02 PM
1 Replies and 10733 Views Tomcat in Production LBI  10733  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 10733
by  Matthew NyeJump to last post
03/27/2008 1:17 PM
4 Replies and 4565 Views Employee Status - to and from  4565  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 4565
by  RyanJump to last post
03/12/2008 3:34 PM
3 Replies and 2691 Views Review Crystal Report  2691  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 2691
by  Sam SimpsonJump to last post
03/12/2008 3:14 PM
4 Replies and 6219 Views Crystal Report question - how to get check, month, quarter, and yearly totals  6219  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 6219
by  Phil SimonJump to last post
03/05/2008 9:25 AM
1 Replies and 2923 Views Differences between Crystal XI & Crystal XI R2  2923  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 2923
by  k-rockJump to last post
02/27/2008 3:14 PM
5 Replies and 2867 Views report question - different data from Portal to CRX  2867  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 2867
by  Phil SimonJump to last post
02/20/2008 6:51 PM
5 Replies and 2996 Views Transferring from where?  2996  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 2996
by  John HenleyJump to last post
02/15/2008 3:44 PM
3 Replies and 3447 Views Personal Action Report Question  3447  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 3447
by  Chris MartinJump to last post
02/15/2008 3:11 PM
4 Replies and 3810 Views LBI Upgrade to 9.0.2.2 - issues  3810  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 3810
by  Greg MoellerJump to last post
02/05/2008 3:37 PM
23 Replies and 21028 Views Date Syntax  21028  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 21028
by  Deleted UserJump to last post
01/11/2008 7:08 AM
1 Replies and 10723 Views LSF9 -n- LBI -n- high CPU  10723  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 10723
by  Greg MoellerJump to last post
01/10/2008 11:24 AM
1 Replies and 10792 Views LBI Windows Server Requirement  10792  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 10792
by  Greg MoellerJump to last post
01/09/2008 4:01 PM
6 Replies and 11775 Views Enterprise Reporting Script loading problems  11775  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 11775
by  Greg MoellerJump to last post
01/04/2008 12:45 PM
17 Replies and 14458 Views Linked subreports  14458  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 14458
by  ChrisMJump to last post
12/19/2007 12:41 AM
10 Replies and 11981 Views LBI Error  11981  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 11981
by  MarcJump to last post
12/18/2007 2:35 PM
4 Replies and 12020 Views OLEDB issue/number of reports  12020  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 12020
by  Chris MartinJump to last post
12/07/2007 4:59 PM
2 Replies and 12194 Views LRS / LBI vs. Microsoft REporting Services  12194  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 12194
by  John HenleyJump to last post
12/04/2007 2:31 PM
2 Replies and 12193 Views DSSO with LBI  12193  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 12193
by  Greg MoellerJump to last post
12/03/2007 3:16 PM
0 Replies and 10365 Views Lawson Backoffice Report Bursting  10365  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 10365
11/14/2007 9:44 AM
5 Replies and 11910 Views Suggestions on Learning SQL  11910  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 11910
by  Phil SimonJump to last post
11/07/2007 2:43 PM
0 Replies and 10452 Views Reporting Services Events  10452  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 10452
10/26/2007 12:56 PM
9 Replies and 12274 Views Query and Report Puzzle  12274  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 12274
by  Chris MartinJump to last post
09/25/2007 1:12 PM
4 Replies and 10481 Views Syntax Question  10481  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 10481
by  Chris MartinJump to last post
09/24/2007 11:48 AM
1 Replies and 15699 Views Dynamic/Cascading prompts with LBI  15699  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 15699
by  John HenleyJump to last post
09/21/2007 8:27 AM
4 Replies and 10596 Views Query to split string into two parts  10596  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 10596
by  John HenleyJump to last post
09/20/2007 10:39 AM
3 Replies and 10213 Views join City, State Zip  10213  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 10213
by  Chris MartinJump to last post
09/20/2007 10:15 AM
3 Replies and 10547 Views Repository Database  10547  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 10547
by  Chris MartinJump to last post
09/19/2007 2:44 PM
1 Replies and 10427 Views Possible Join Query Prob.  10427  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 10427
by  Chris MartinJump to last post
09/19/2007 8:45 AM
4 Replies and 10704 Views Query syntax error  10704  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 10704
by  Chris MartinJump to last post
09/14/2007 11:13 AM
3 Replies and 11858 Views ODBC Connection problem.  11858  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 11858
by  John HenleyJump to last post
09/13/2007 7:40 PM
4 Replies and 12343 Views Crystal parameters - defaulting  12343  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 12343
by  Phil SimonJump to last post
08/14/2007 2:54 PM
5 Replies and 12577 Views New tool I want to share....  12577  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 12577
by  Chris MartinJump to last post
08/14/2007 2:47 PM
1 Replies and 10759 Views ODBC views and OLEDB commands in same rpt?  10759  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 10759
by  John HenleyJump to last post
08/13/2007 2:32 PM
4 Replies and 11375 Views Crystal Parameters for QB 9.0.3  11375  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 11375
by  Phil SimonJump to last post
08/07/2007 7:29 AM
3 Replies and 11935 Views Implement LBI  11935  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 11935
by  Chris MartinJump to last post
08/06/2007 2:34 PM
4 Replies and 11985 Views PA26 - REVIEW table  11985  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 11985
by  Phil SimonJump to last post
08/06/2007 6:46 AM
1 Replies and 11005 Views changing data sources  11005  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 11005
by  John HenleyJump to last post
07/27/2007 10:06 AM
2 Replies and 11704 Views Query Builder vs. Oracle/SQL Server views  11704  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 11704
by  Phil SimonJump to last post
07/27/2007 7:45 AM
12 Replies and 14669 Views Crystal and Lawson's OLE DB  14669  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 14669
by  John HenleyJump to last post
07/26/2007 4:17 PM
0 Replies and 11000 Views general publishing tips  11000  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 11000
07/19/2007 11:42 AM
8 Replies and 11792 Views Can't see all tables  11792  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 11792
by  Phil SimonJump to last post
07/19/2007 11:37 AM
2 Replies and 10624 Views two Crystal/Add-in questions  10624  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 10624
by  Phil SimonJump to last post
07/18/2007 9:36 AM
1 Replies and 11382 Views Using ODBC to connect to LAwson through Crystal.... Will this be an issue with the upgrade to Crystal XI???  11382  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 11382
by  John HenleyJump to last post
07/17/2007 7:09 AM
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