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 3 of 5 << < 12345 > >>
Topics
 Replies
 Views
 Last Post
12 Replies and 2464 Views Automatically database connection  2464  12 Started by  wintergreen When refresh data on the report for the first time, LBI will prompt the screen to ask user to enter ID and password to connect database. How to make it without asking user ID and password to connect to database I have enter the ID and password under the data settings screen in the report administration and also tried to create a datasource but nothing work I used SQL OLEDB connection. Any idea Thanks
12 2464
by  Matthew NyeJump to last post
04/11/2011 10:06 AM
2 Replies and 1199 Views Limit on the Number of rows to burst in smart notifications  1199  2 Started by  Ruma Malhotra Is there a maximum limit on the number of rows smart notes can burst For eg I am trying to write a smart notes that has more than 5500 rows of data and would like smart notes to burst each row. Has anybody experienced this issue What was your solution
2 1199
by  Ruma MalhotraJump to last post
04/09/2011 10:58 AM
2 Replies and 1776 Views DME substitute- RW?  1776  2 Started by  Nabil Hello Gurus, So we know very well that in order to create custom crystal report that use user level security, OleDB is an option. We also know that OleDb is really really sllllowwwww So, are there any other alternatives to this painful reality Can there be OleDb reports written with a language other then DME How about SQLOLEDB Thanks much,
2 1776
by  mikePJump to last post
04/08/2011 2:44 PM
1 Replies and 1289 Views Datasource for LTM?  1289  1 Started by  George Graham Anyone set up one of these yet within Reporting Services
1 1289
by  NabilJump to last post
04/08/2011 9:14 AM
23 Replies and 12990 Views LBI tables and/or data dictionary  12990  23 Started by  Greg Moeller Does anyone know if a data dictionary exists for the 3 schemas that LBI installs&160; We are specifically interested in the Reporting Services schema, but Framework Services, and SmartNotes would also be helpful. Field names, sizes, descriptions, links to other tables, whatever exists out there. Thanks much, -Greg Moeller
23 12990
by  Greg MoellerJump to last post
04/07/2011 12:01 PM
8 Replies and 2103 Views Automatic device import  2103  8 Started by  Greg Moeller I have been tasked with finding a way to automate the import of delivery devices for both Reporting Services and Smart Notifications. I can get a file created and it will work going through the 'wizard', but am wondering if there is a way that I can automate or script this This would cut down on errors, save time, save confusion.  ie someone changes their name, their email address changes too.  If we could figure out how to automate the import to both update and create new devices...
8 2103
by  mark.cookJump to last post
04/07/2011 9:47 AM
1 Replies and 1860 Views Here we go GURUS!! Automate on demand report scheduling  1860  1 Started by  George Graham OK - trying to be very creative with this. Have reports that are not on-demand reports, but can't be scheduled at the same interval each period. Instead of allowing a group of users access to schedule a report to execute the thought was that we could come up with a java hack of some kind to give them the option to 'kick off' the report to run as a scheduled instance. I know that I can create a link on a dashboard (or on an icon next to a report link) with something like the following and it w...
1 1860
by  George GrahamJump to last post
04/05/2011 4:08 PM
0 Replies and 1185 Views Control characters in ers_reportdatasources  1185  0 Started by  Greg Dey While trying to troubleshoot a problem with publishing reports in 9.0.4.1 LBI, I noticed that all the records in ers_reportdatasources have a 'square' after the value in reportdatasource. Looks like maybe control characters  I am using TOAD to view the data. Our database is Oracle 10g. Does anyone else have this issue
0 1185
04/01/2011 10:49 AM
4 Replies and 2472 Views LBI Security Groups  2472  4 Started by  Tim What table in the LBI meta model relates to  ERS_SECURITYGROUPS and identifies all of the users assigned to it I would like write a SQL query to identify the individuals that are assigned to a security group. Thanks, Tim  
4 2472
by  Ruma MalhotraJump to last post
03/28/2011 2:45 PM
7 Replies and 3208 Views LBI Security setup  3208  7 Started by  Ruma Malhotra Just one week to CUE and I am wondering how different users have setup LBI security through the use of report security groups, custom groups, groups defined in LS9 security or through just simple user ids. Since I am not very smart, I am struggling to define best practices for setting up security that will be maintained through different LBI version upgrades, migrations to new hardware and LBI security reporting from the reporting tables to provide to business owners . Please don't go ha...
7 3208
by  mark.cookJump to last post
03/25/2011 12:31 PM
3 Replies and 1506 Views LBI -Still Learning  1506  3 Started by  Deleted User I see some versions LBI will be decommissioned - what exactly is LBI I know we use lawosn add-ins and Process flow but for reporting we have cognos, reportsafe.
3 1506
by  John HenleyJump to last post
03/25/2011 9:21 AM
2 Replies and 3075 Views Crystal Effective Date Reporting  3075  2 Started by  John Henley Here's a a technique for creating effective date reports from Lawson data. In particular, this is useful for reporting from HR history data, where you want a report to reflect the value of a piece of data at a given point in time, not its current value. For example, you might want to a report listing your employees their employee status as of a given date. Read Crystal Effective Date Reporting.
2 3075
by  NabilJump to last post
03/24/2011 2:30 PM
0 Replies and 1389 Views Function to print crystal report?  1389  0 Started by  George Graham Looking for a way to provide a link to print a crystal report instance without having to open it. I have not been able to find a way so thought I would ask this group.  Would need to be a client side print. I think I'm out of luck but thought I would check here first.
0 1389
03/23/2011 1:49 PM
2 Replies and 1753 Views Mapping a crystal report that uses a sql command  1753  2 Started by  Ruma Malhotra Has anyone been able to map a crystal report that uses a sql command that has the schema name hardcoded from one environment to another Th problem in this lies where the schema name is diffrent in 2 environments. Like for example the schema name is prod and test in 2 different envirormnrts and it is difficult to map theses crystal reports. On LBI when you publish these reports the datasource override will not work since the objects will not be found because of the schema name being hardcoed ...
2 1753
by  Ruma MalhotraJump to last post
03/09/2011 4:42 PM
3 Replies and 2124 Views Anyone Using non-Lawson scheduler to schedule, run, and distribute reports published in LBI  2124  3 Started by  Tim Hi, We have a company standard enterprise job scheduler.  This product has the ability to run scripts, call URLs, call command-line commands, etc.    We would like to use this enterprise scheduler to schedule, run, and distribute LBI Crystal Reports to users. 1.  Is it possible to schedule, run, and distribute reports that are published in LBI with non-Lawson scheduling tool 2.  How would this be accomplished  Would we call something like the followi...
3 2124
by  TimJump to last post
03/09/2011 3:59 PM
3 Replies and 1278 Views Maximum number of pages of a report in LBI  1278  3 Started by  RoxanneS Our HR department wants a Crystal report published to LBI that covers 24 months worth of data and runs about 15,000 pages.  Our consultant says we can't--or maybe it's that we shouldn't--send a report that large to LBI. Anyone else sending that large of a report to LBI  Is there a maximum number of pages for a single report or some reason why we shouldn't publish this in LBI Thanks!!
3 1278
by  RoxanneSJump to last post
03/07/2011 11:53 AM
3 Replies and 1138 Views Users and Access Ids Cascading Issue with dashboards, modules and links  1138  3 Started by  Ruma Malhotra We had an issue on LBI 9.0.4. where the permissions or user ids set on a dashboard were cascading down to modules and links. In 9.0.4.1. lawson has changed this where they have given a user the option not to accept the cascadeing down of user access from dashboards, modules, links etc. They have done this by adding a line to modify the sysconfig file on framewrok services and adding 'PERMISSION_INHERITANCE' as false. Has anyone implemented this Any experiences/issues that you can share wo...
3 1138
by  Ruma MalhotraJump to last post
03/03/2011 4:10 PM
2 Replies and 2361 Views ERD Files - LBI Reporting Services  2361  2 Started by  JeanneS Is there any documentation for the ERD files What does the PK before the field SECURITYGROUP ID represent on the ERS_SECURITYGROUPS table I need to create a crystal report that lists the members in LBI security groups. The ERS_SECURITYGROUPS table gives me the names of the tables but not the member names. Any suggestions as to how to get the member names Thanks.
2 2361
by  Greg MoellerJump to last post
03/03/2011 4:08 PM
5 Replies and 2304 Views Custom Crystal Reports for LBI that use Commands(sql)  2304  5 Started by  gsusnme In publishing a custom report that has a command (sql) and parameters, in LBI, the parameter screen displays, and after choosing parameters it goes to a screen to put in default user id and default password, (which has been populated in the setup), and when you enter it again it goes back to the parameter screen, it's looping.  It's as if the custom crystal and the command(sql) are treated separate, but never mesh back together.  Any one have any idea...
5 2304
by  gsusnmeJump to last post
03/03/2011 4:02 PM
8 Replies and 5887 Views LBI/BPW implementation?  5887  8 Started by  Jeff House Executives are seriously looking at combining reports from Lawson, time clocks, patient billing, nursing scheduling, and patient data systems. Based on a some internal knowledge and a little research, it appears LBI combined with BPW seems the answer. If my brief research is correct, BPW is quite new for S3 customers. If you currently use LBI for pulling in data from multiple systems, what type of full time resources do you have What's your ideal amount Anyone have BPW up and running Any ...
8 5887
by  ErikaSJump to last post
03/03/2011 1:32 PM
4 Replies and 2872 Views Lawson back Office reports in Excel ?  2872  4 Started by  Ruma Malhotra Usually publishing back office reports allows users to download only in pdf. &160; Has anybody found a way to download backoffice reports in excel format We have a number of RW100 backoffice reports that are published that can be downloaded in pdf format.I am investigating ways of downloading in excel. Tia. &160;
4 2872
by  George GrahamJump to last post
03/03/2011 9:31 AM
2 Replies and 1457 Views Publish Backoffice Reports as CSV drillable  1457  2 Started by  KJBULLS Hello, My organization wants to explore a way to publish Back Office reports as CSVfiles with drill around in LBI. Is that possible Has anyone ever done this Thanks for your help in advance! KJ
2 1457
by  Ruma MalhotraJump to last post
03/03/2011 9:03 AM
1 Replies and 1446 Views Setting a parameter based off User Roles.  1446  1 Started by  MCordero I am working on a crystal report with three dynamic parameters, one of which I need to use LBI Roles to filter.   I've created structure called Company Number with a number element CompanyNum.  I then set up Group rights to different Company Numbers depending on the Company. (I've done before with Facility Name and bursting was successful, so I'm pretty sure this part is all correct).  I have since then tried a combination of customizing the Co...
1 1446
by  Matthew NyeJump to last post
03/02/2011 9:33 AM
6 Replies and 2246 Views LBI Alternatives  2246  6 Started by  Lance Kelley LBI works great for us.   However, now that more and more employees are looking for Crystal Reports to run, I'm concerned about increased license fees and increasing annual maintenance fees to include our entire (albeit small) team's access to LBI where we publish the reports.  We've been 'live' with Lawson S3 901, LBI, ProcessFlow, etc. on an in-house Windows environment (including MS SQL Server) for just over one year and looking back at our purchase pric...
6 2246
by  Lance KelleyJump to last post
03/01/2011 4:17 PM
7 Replies and 1920 Views Using a Custom Crystal Report with my data  1920  7 Started by  ErikaS Hello, I'm very new to Crystal Reporting and the Lawson OLEDB connection. Another one of Lawson's clients gave me a Crystal Report file that they have customized for their reporting needs. How would I use that report with  my data through the OLEDB connection I see their formula fields and I see something that looks like they created with the Query Builder...can I/will I be able to view what they created in Query Builder I'm sorry if I'm not using the right terminology. ...
7 1920
by  ErikaSJump to last post
02/28/2011 10:37 AM
19 Replies and 2037 Views Bursting of Notifications  2037  19 Started by  Ruma Malhotra I have a row of data which captures the operator who put in that data into the system as well as the director who needs to approve the data, is there a way to burst this notification in such a way that it bursts by the director as well as the operator so that the director and the operator gets the same data using a single notification. I cannot define a delivery device for the operator since I do not know on a daily basis who keyed in that peice of data. Since in the bursting step there i...
19 2037
by  George GrahamJump to last post
02/23/2011 7:05 AM
0 Replies and 1467 Views Crystal Report Filtering  1467  0 Started by  Matt T Hey all, We are trying to setup a filter for one of our reports and we can't seem to get it to work.  We have data at different levels (Company, Territory, Region, State, Area, Zone).  We're trying to set it up so people have the ability to see what's in their area and everything under it (i.e., Zone users only see Zone data, State users see State, Area, and Zone, etc.).  Has anyone done something like this before and can provide us with help or tips on how t...
0 1467
02/07/2011 8:34 PM
1 Replies and 1471 Views Added memory does not show up in reporting service  1471  1 Started by  Deleted User I'm not sure this is the correct forum.  Our LBI server was increased from 2g to 4g ram but the 'About Reporting Services' screen still shows the old memory settings.  Any ideas
1 1471
by  John HenleyJump to last post
02/02/2011 2:08 PM
1 Replies and 2266 Views Crystal 2008 export more than 65k rows to Excel 2007  2266  1 Started by  Deleted User Has anyone been sucessful at exporting more than 65k rows of data from Crystal 2008 to an Excel 2007 format  The work around is to save as .csv and then open the file in Excel 2007.  I'm curious if anyone has found Crystal 2008.dll updates which export large record sets directly into Excel 2007 
1 2266
by  Shane JonesJump to last post
02/02/2011 10:42 AM
1 Replies and 1196 Views Sending large Excel attachments on LBI  1196  1 Started by  Deleted User When using Crystal 2008 ODBC reports and RAS 2008 some large excel attachments never make it to the user inbox in e-mail.  The Websphere logs show 'e-mail sent'.  The same report with a .PDF format will arrive in the end user's mail system inbox.  Has anyone experienced this LBI issue before 
1 1196
by  Matthew NyeJump to last post
01/30/2011 1:36 PM
9 Replies and 4848 Views User Role Based Crystal Reports in LBI  4848  9 Started by  ChrisS We here in HR have over 100 canned reports that are being ran throughout the month (Weekly, Bi-Weekly, 1st of the Month, 5th of the Month, etc.). Previously, these reports were generated in Crystal(20) and Access(80). We'd like to move them to the Dashboard, but I'm very confused on the contraints an end user (ie. Leadership) would have. We'd like to enable Leadership to run the Crystal Reports directly from the Dashboard and have the option to export to whatever file format they wish. ...
9 4848
by  ChrisSJump to last post
01/22/2011 8:04 PM
9 Replies and 1643 Views Auto-import of rights  1643  9 Started by  Greg Moeller Is there some way to script the import of rights I can create a file with what I need to import, but don't want to go through the wizard on a daily basis. Everyone here should have at least one right imported automatically and with our ever-changing workforce, it would be nice to auto-load at least this one (or two) rights. Any ideas
9 1643
by  Greg MoellerJump to last post
01/21/2011 4:09 PM
4 Replies and 1332 Views 2008 Server (for LBI)  1332  4 Started by  Greg Moeller Does anyone have any summary/detailed steps for installing WAS 7, LBI, DSSO, etc on a 2008 Server that they would be willing to share
4 1332
by  Greg MoellerJump to last post
01/21/2011 1:17 PM
5 Replies and 2368 Views Override DSSO log-ins?  2368  5 Started by  Nick We have a Crystal Report with Drill-Arounds built in along with a few Smart Notifications on a manager level dashboard.&160; However, most of the managers that access the dashboard do not have a user ID with true access to Lawson applications (they are self-service IDs for ESS).&160; Our management is concerned&160;with licensing issues and costs, and do not want to build individual&160;application/authentication users, and instead want to use a generic user that has already been set-up. LB...
5 2368
by  Matthew NyeJump to last post
01/20/2011 8:53 PM
2 Replies and 1140 Views Reporting Service for 3rd party database  1140  2 Started by  wintergreen We have reporting services on the framework.  We want to be able to publish other database(not Lawson) crystal reports through LBI.  Do I need to create another reporting sevices on the framework  Or I can use the same one but how to separate these 2 database reports
2 1140
by  mark.cookJump to last post
01/20/2011 7:10 AM
2 Replies and 3559 Views LBI Dashboard  3559  2 Started by  Donna I just added a tab to our dashboard. I then set up specific users in the set access utility.  I can see the users in set access but the user who was going to test the dashboard, contents and reports cannot see the tab. I am sure I overlooked something simple. 
2 3559
by  DonnaJump to last post
01/17/2011 6:50 PM
11 Replies and 5860 Views Crystal 2008  5860  11 Started by  Deleted User Has anyone got Crystal 2008 and the Lawson OLEDB to work together&160;
11 5860
by  DonnaJump to last post
01/14/2011 6:51 PM
5 Replies and 1670 Views Why is LBI Bursting empty Crystal Reports  1670  5 Started by  David V We have reports that are being bursted with only header information.  When you open the report there is a zero record count.  How do we keep them from bursting Note:  The report data source is an Oracle Stored Procedure that runs for an Acct-Unit Range.  The rport is then bursted by Acct-Unit.  But I also include one extra record in the file that has a statistic that is used in the calculations.  But the users do not have access to that record in the bursting ri...
5 1670
by  JeanneSJump to last post
01/10/2011 4:24 PM
0 Replies and 1230 Views Convert apdistrib_date to fiscal year and period  1230  0 Started by  Deleted User Any Gurus with a handy Crystal formula to convert an apdistrib_date to fiscal year and period 
0 1230
01/06/2011 12:18 PM
6 Replies and 2610 Views Crystal GLAMOUNTS and GLTRANS  2610  6 Started by  Deleted User I'm writing a Crystal ODBC report that represents data available on GL90 (ex Co, AU, Acct, FY, Period, beg bal, posted, and ending balance).  The report also shows JE detail.  Has anyone had sucess writing a Crystal report with both GLAMOUNTS and GLTRANS  Let me know if I can pick your brain. Did you use a main report for GLAMOUNTS and a subreport for GLTRANS  My db is humoungous so I need to pass the selection parameters into the select statment.  Did you write a m...
6 2610
by  John HenleyJump to last post
01/03/2011 3:24 PM
5 Replies and 1345 Views Crystal Report issues  1345  5 Started by  dipu Hi all, I have a crystal report with two commands and it returns the correct data. Now I need to add one more filed to the report to show the displayed employee is a manager or not. Employee number is there in Employee table and Supervisor table. If the emoployee number is there in Supervisor.employee filed then it has to display as Yes(Manager) or No for the employee.employee in the report. Could you please help me on this
5 1345
by  JonAJump to last post
12/28/2010 9:40 AM
1 Replies and 2447 Views Cascading Parameters do not return all values  2447  1 Started by  Carl Gifford I have create a Activity Summary report in Crystal which goes against a large amount of data. I am trying to use dynamic cascading parameters in LBI but I am not getting all the data values for the firs parameter (Company). In Crystal reports, all the data values are displayed; however when the report is published in LBI Reporting Services, not all of the values for the first parameter are being displayed. We changed the registry setting, MaxRowsetRecords, on the LBI server to be 1,000,000...
1 2447
by  S EckersonJump to last post
12/15/2010 3:47 PM
3 Replies and 1579 Views Crystal and LBI Drill Around  1579  3 Started by  Katfra I have a crystal report i loaded on my dashboard in LBI.  I'm trying to test it before moving into production and think i may have missed something.  I want my user to be able to see the report and drill around on it.  Is there something that needs to be done to allow for this function
3 1579
by  Greg MoellerJump to last post
12/15/2010 1:15 PM
5 Replies and 2600 Views Calculating a Time in Crystal Reports  2600  5 Started by  JeanneS How do you calculate a time when the value is stored as a number  For example, I want to calculate the time difference between WHSHLDTL.UPDATE_TIME and WHSHIPLINE.UPDATE_TIME.  Both fields are stored as a number.  Thanks in advance!
5 2600
by  JeanneSJump to last post
12/07/2010 1:55 PM
0 Replies and 1288 Views Dept Analysis Reporting  1288  0 Started by  mark.cook I am looking to replace an Access Database solution with LBI to provide departmental reports for Finance. I can easily replicate the income statement style reports being pulled from the database. I was wondering if anyone has a good way to add vaiance analysis back from Managers. For instance if I am 20 over budget in salaries, I want managers to respond as to why.  How are others doing this process Thanks for you assistance
0 1288
12/06/2010 11:28 AM
1 Replies and 1731 Views Figuring out table joins  1731  1 Started by  dukeslater Trying to replicate Crystal report that uses Object Services but using a command object instead. Here's the ado code: dmeROD=WEBUSER.PRODLINE&FILE=PORECLINE&FIELD=DESCRIPTION;ENT-REC-QTY;ENT-REC-UOM;ITEM;MANUF-ID;MANUF-NBR;MMDIST.ACCOUNT;MMDIST.ACCT-UNIT;POLINE.ENT-UNIT-CST;POLINE.EXTENDED-AMT;POLINE.VEN-ITEM;REC-DATE;VENDOR;VENDOR.VENDOR-VNAME;VEN-ITEM;POLINE.QUANTITY&SELECT=MMDIST.ACCT-UNIT3E3D441000026MMDIST.ACCT-UNIT3C3D441999926REC-DATE3E3D012f012f08&OTM=1&O...
1 1731
by  Ruma MalhotraJump to last post
11/29/2010 3:01 PM
0 Replies and 1557 Views Missing Data in Burst Crystal Report on Multi-RAS server.  1557  0 Started by  Charlotte Chase We have a report that returns 350K rows. The report is published as both a burst and non-burst report. For users who have wide-open bursting rights, the burst report returns an incomplete data set in our production environment, even though the bursting tree is correct and all companies and accounting units display (random detail lines for various accounts are missing, not a field we burst on). The report works fine in our test environment as both a burst and non-burst report. Our test box...
0 1557
11/24/2010 1:23 PM
3 Replies and 1153 Views OS support LBI  1153  3 Started by  Greg Moeller I know a while back, the LBI install doc used to say VM instances supported for development only.  Does anyone here know if that has changed since I cannot find any reference to yes or no for VM support in production. Thanks in advance, -Greg
3 1153
by  Chris MartinJump to last post
11/24/2010 12:47 PM
3 Replies and 1919 Views ClassDefNotFoundError  1919  3 Started by  Greg Moeller I am getting the following in my systemout.log file for LBI after switching the authentication source to DSSO on a new server install for LBI. webapp        E com.ibm.ws.webcontainer.webapp.WebApp logError SRVE0293E: &91;Servlet Error&93;-&91;com/lawson/lawsec/authen/LawsonAuthentication&93;: java.lang.NoClassDefFoundError: com/lawson/lawsec/authen/LawsonAuthentication     at com.lawson.efs.security.authenticationprovider.SSOAuthenticationP...
3 1919
by  Greg MoellerJump to last post
11/18/2010 10:05 AM
3 Replies and 2634 Views LBI, Crystal & subreport  2634  3 Started by  RoxanneS Using Crystal 2008 and have a report with a subreport. When I open it up in Crystal, looks fine. I publish the report to LBI (9.0.4.0.192) and enter the parameters, then I get an error message back 'Failed to retrieve data from the database'. I tried deleting the subreport and publishing that to LBI and it works fine. Does LBI have some kind of issues with Crystal subreports The strange thing is, the users approved the report/subreport in LBI in October; so it worked then when it w...
3 2634
by  RoxanneSJump to last post
11/17/2010 3:49 PM
3 Replies and 2783 Views There are not any Rights on File for the requested User. (LBI bursting)  2783  3 Started by  Quantitalyst Trying to get started with Bursting of an RW100. Carefully set up Elements, Structure, and Rights; but get above error. Things to note: 1) Just trying to set up with 'users', not groups or roles 2) Users are 'officers' 3) Checked off all permissions 4) Lawson KnowledgeBase Intellisenses my error, but there are no articles for it. That seems stupid Thanks, Mark
3 2783
by  QuantitalystJump to last post
11/16/2010 8:37 AM
7 Replies and 5874 Views Security Reports In Lawson  5874  7 Started by  Ruma Malhotra Is there a way to get by systemcode , the ids attached, their security class and the actions for every form in Lawson under the system code as a report. Has anyone been able to write or get a custom report and are willing to share
7 5874
by  Adam GoldsteinJump to last post
11/11/2010 3:10 PM
0 Replies and 1383 Views CR REPORT IN LBI DOES NOT STOP PROCESSING  1383  0 Started by  sharona We run CR2008 in the LBI. I have a report which is time consuming, when the user gets impatient and shuts the report down via the parameters page X in upper right hand corner or they ctrl alt del to terminate the program. our reports run from an ISERIES ACCESS ODBC DRIVER to and AS400 SYSTEM. when the report is terminated the process on the server keeps running. something isnt terminating between the ODBC and the AS400. Has anyone experienced this prior  any fixes, any proper way ...
0 1383
11/11/2010 11:14 AM
0 Replies and 1130 Views LBI CRASHES  1130  0 Started by  sharona I have a Lawson LBI portal that users run crystal reports in. The only thing on that server is the LBI. intermittently the users will run a report and then the LBI doesnt work. check the server we have a VISUAL C RUNTIME ERROR VISUAL DEBUG STUDIO.  We then have to reboot the server. any ideas what would be causing this, or a fix
0 1130
11/11/2010 8:09 AM
2 Replies and 1542 Views Figuring out fields that join tables  1542  2 Started by  Zeke Does a magic bullet exist for figuring out the fields that join tables together in Lawson  I am familiar with the ERDs available on this site, dbdoc, and derfldrpt, but what about the actual fields that need to be related together to retrieve unique results I assume the answer is just to figure it out yourself or learn how to read the output from dbdoc better, but I wanted to make sure we weren't missing something obvious.
2 1542
by  mark.cookJump to last post
11/08/2010 7:07 AM
4 Replies and 1406 Views Scheduled report with no data.. prevent from emailing?  1406  4 Started by  Jeroen Thanks for taking the time to read this we're pretty new at Lawson in general (pre go-live stage), and I am appointed as the 'LBI man', so far so good, but I'm facing a constant challenge: We have several Crystal Reports now, and some of them are scheduled in LRS to be delivered through email. The nag is: when there is no data on the report (either because of bursting, or because the underlying query just turns up empty) there will still be an email, containing a .pdf file with...wel...
4 1406
by  vishcomJump to last post
11/03/2010 7:19 PM
9 Replies and 1657 Views WAS 7 and LBI  1657  9 Started by  Greg Moeller When installing WAS 7 from scratch for LBI install, is there a need to install a separate JDK, or is the one that comes with WAS7 enough  I can't seem to find out.
9 1657
by  Jimmy ChiuJump to last post
10/25/2010 10:30 AM
8 Replies and 3239 Views LBI with Crystal Reports 2008  3239  8 Started by  TracyO I understand that Lawson is currently not supporting Crystal 2008 wiht LBI.&160; Is anyone running that combination currently&160; IF so have there been any issues Or does anyone one know where to find the differences between Crystal XI &&160;Crystal 2008 We are currently on Crystal 8.5 and will be starting to install LBI in Q2, so I&160;would like ot&160;have my Crystal updated and ready prior to that. Thanks for any&160;suggestion. Tracy&160;
8 3239
by  CincyJump to last post
10/22/2010 8:54 AM
2 Replies and 1512 Views security hole in LBI  1512  2 Started by  Jimmy Chiu I just logged this hole with Lawson. Hopefully they will fix it soon. Anyway, here is the security hole. Ie: http://server:port/efs/ConfigurationAssistant No login check, nothing, and you can make changes.
2 1512
by  Matthew NyeJump to last post
10/21/2010 4:41 PM
11 Replies and 1783 Views Using RW as my Data Source in Crystal  1783  11 Started by  Katfra Hello, I'm trying to create a report in Crystal using an RW Report i've already created. However, i was given some literature stating before doing this that i need to eliminate my totals and use my totals as headings. So with this being said, do i need to copy my current report and create it backwards. Net income as being my first line followed by my other totals I'm not sure how to go about this the right way. My intention going foward is to build the reports right out of crytal bu...
11 1783
by  KatfraJump to last post
10/18/2010 7:58 AM
1 Replies and 1353 Views Using ProcessFlow to publish LBI (RS) Reports  1353  1 Started by  WRB Apparently at CUE someone showed how to publishe Reporting Services reports via Process Flow.  I can't find any information on this does anyone have some info on this they would not mind sharing. Thanks
1 1353
by  David WilliamsJump to last post
10/12/2010 4:28 PM
1 Replies and 1245 Views Date Parameter Formula?  1245  1 Started by  MCordero I'm fairly new to LBI and what I would like to do is set up a drop down of pre defined date parameter formulas such as Year to Date, Last Month, Previous 6 Months, as well as Date Ranges instead of the user having to select the start and end dates.  I know it can be done within crystal, but can it be done through LBI  If so, how would this be accomplished  I've tried just hard coding 1/1/2010 as a date in a drop down list but haven't been able to get it to ...
1 1245
by  CharJump to last post
10/12/2010 10:03 AM
3 Replies and 2142 Views LBI Security Groups VS Custom Groups  2142  3 Started by  Kristy Can someone please explain the difference between these two types of groups and which one is better to use and why Doing some maintenance on our LBI&160;reports and dashboards and trying to decide which ones to set up. &160; &160;
3 2142
by  Ruma MalhotraJump to last post
10/08/2010 10:27 AM
5 Replies and 1427 Views Crystal 2008 server & designer  1427  5 Started by  Greg Moeller My friends: I am trying to get XI R3 (AKA 2008) on to our test server. I have no problem applying both along side XI R2 SPx. My question comes in when I have downloaded XI R3 SP3 cumulative from Lawson, it says 'Another version of this program is already installed, this installation cannot continue...' Is there a certain order that you need to apply these in From the readings I've already done, XI R2 and XI R3 can co-exist. Anyone be able to confirm or deny that Thanks much, -Gre...
5 1427
by  Greg MoellerJump to last post
10/08/2010 9:58 AM
2 Replies and 1510 Views LBI and No Icons  1510  2 Started by  Katfra I'm currently using LBI&160;in the test environment and have come across a problem.&160; I have an 'x' in all the icons which would show me: Print, Export, Next Page, Prev Page, etc... I was told by my IT&160;department that it's a compatibility with IE8 but was at my user group this week and was told there is a fix and should be compatible.&160; I was wondering if anyone has had this problem and if so, what can i do&160; &160; Thanks, Frank
2 1510
by  KatfraJump to last post
10/06/2010 12:40 PM
5 Replies and 2068 Views Leveraging RAS without loggin in to lbi  2068  5 Started by  mjcindc This might be a little off topic, but let's see what you all think. We've got a data collection website that really has nothing to do with Lawson. Since we already have staff with SQL, Crystal Reports and LBI skills, I'd like to figure out how to leverage them and LBI or just the RAS service to provide reports to users of the non-lawson system without them having to log in to LBI. They don't have user names for LBI and the business owners of this other system are not very keen on making users...
5 2068
by  mjcindcJump to last post
10/04/2010 2:30 PM
0 Replies and 1573 Views How does one copy LBI prod to LBI test?  1573  0 Started by  Deleted User We have two LBI&160;instances(9.0.2.2.127) on seperate servers using WebSphere (6.1.0.17).&160; We have two seperate databases too.&160; We have DSSO set up too.&160; I want to keep these two in sync.&160; How does one do that I have tried copying the sql tables and the data folders, but run into DSSO errors on the test instance of LBI. &160;
0 1573
10/01/2010 9:54 AM
2 Replies and 2707 Views Crystal Report hyperlink- GL90  2707  2 Started by  Carl Gifford I am trying to create a hyperlink from a Crystal Report to GL90 (Transaction Analysis). I have been able to successfully write the hyperlink with the exception of being able to pass the Fiscal Year, Beginning and Ending Periods. following is the string I am using: 'https://laprd1.sharp.com:4443/lawson/portal/index.htmtarget=_blank_PDL=P90&_TKN=GL90.1&_HK='&{GL90Drill} THE HK is based upon a formula is Crystal: GL90Drill which concatentates the Company, AU, Account, SubAccount, Fis...
2 2707
by  Carl GiffordJump to last post
09/30/2010 9:58 AM
2 Replies and 1135 Views Version of PDF Created  1135  2 Started by  JL Our Lawson (9.0.x) environment creates a 1.3 version of Adobe 4.x PDF. Is there anyway to upgrade that pdf generater to something that will generate a newer version Thanks in advanced.
2 1135
by  JLJump to last post
09/30/2010 8:44 AM
9 Replies and 2012 Views Display the user ID iin report headings  2012  9 Started by  mikeP Does anyone know a way to display the user's Lawson acount name in reports run from an LBI server This can be handy in a report heading when you're trying to determine the origins of a printed page at a later date. There a CR function called CurrentCEUserName, but it only works with Crystal Enterprise, which our provider doesn't have. I was hoping someone else may have developed a workaround for this. Thanks, Mike .
9 2012
by  DonnaJump to last post
09/29/2010 10:51 AM
5 Replies and 1666 Views Excel file as a datasource for Crystal in LBI  1666  5 Started by  Deleted User We have several CXI reports that use Excel as a datasource (From a network share) and I have been approached to see if there is a way for me to get them into LBI. I have been attempting to get it to work, to no avail. The reports work fine when they are run in Crystal, but once I upload the rpt to LBI, I get the following error: Error Failed to load database information. Error in File C:\WINDOWS\TEMP\PE LBI Test 01 {1FCAF25D-D167-41B6-93B1-E92A1D6B7B2D}.rpt: Failed to load database inform...
5 1666
by  Deleted UserJump to last post
09/29/2010 7:48 AM
2 Replies and 10749 Views IA10 values not visible in scorecard  10749  2 Started by  Bob Beverley I'm using MS Analytic Services. I have YTD member names in GLDM.5 (and Qtr YTD in GLDM.6) but those elements are not available in my cube - neither in Analysis Manager nor in Scorecard. I get my current period and current qtr elements, but nothing for YTD. GSC hasn't been any help to this point. We've analyzed IA150 and these vales appear to be handled by some java scripting (which is way out of my league) but we're not seeing any issues there. I'm wondering if somehow ytd values just are...
2 10749
by  Xin LiJump to last post
09/28/2010 4:56 PM
4 Replies and 2289 Views Windows 7, Crystal 2008 and Oracle 10g  2289  4 Started by  Donna I am looking for advice from other Lawson consultants or clients who are using Windows 7 and develop Crystal Reports. My laptop died forcing me to buy a new one and could not get another Windows operating system. I have been developing reports in Crystal 2008 for 2 years using Windows Vista with no issues. Prior to that I have been developing Crystal Reports since 1997 with many versions of Crystal and Windows. I am on a client assignment using Crystal 2008 and Oracle 10g. I did some res...
4 2289
by  Ruma MalhotraJump to last post
09/28/2010 2:21 PM
5 Replies and 4976 Views hyperlink in crystal report  4976  5 Started by  Xin Li We have LBI report that has heperlink for user drillaround. Unfortunately it open the link in current I.E Window instead in a new I.E. window that is not desirable. Does anyone know how to force hyperlink in crystal report to display on a new I.E. window
5 4976
by  amynelsonJump to last post
09/28/2010 12:59 PM
1 Replies and 1486 Views Data source override in LBI  1486  1 Started by  Troy We are trying to create a datasource in LBI that will connect to a non-Lawson database that is on a server outside our network. We have been able to create a NAT'd IP for the server and connect to it with Crystal, but we get errors or a login prompt when we try to do it in LBI unless we change the Data Source to the Nat'd IP before it is published. The issue is the client does not have access to the server to change the Data Source themselves after publishing. They can't use the NAT when publ...
1 1486
by  lizJump to last post
09/27/2010 4:17 PM
1 Replies and 1835 Views ACTRANS and IC Transactions  1835  1 Started by  Carl Gifford We are trying to create a Crystal report that will inlcude the IC (Inventory Control) details for transactions posted to ACTRANS. It does not appear that there is any link (object ID, etc) from ACTRANS to ICTRANS so we have been trying to link to MMDIST. The trouble is the the indexes on MMDIST do not inlcude AC items and the other indexes have items that are not inlcuded in the ACTRANS table. If we do not use the indexes, the performance is terrible (as MMDIST is a huge table) A...
1 1835
by  John HenleyJump to last post
09/24/2010 7:17 PM
0 Replies and 1250 Views Specified sort order in bar chart  1250  0 Started by  JonA I'm trying to force my stacked bar chart to display the data in a specified order but it's not behaving. Attached is a screen capture of my graph and the group sort order settings.
0 1250
09/24/2010 10:45 AM
1 Replies and 2692 Views Refresh Button On Crystal Report Viewer in RAS XI  2692  1 Started by  John Cunningham Is there a way to disable the refresh button on the crystal Report viewer launched from LBI Reporting Services
1 2692
by  Matthew NyeJump to last post
09/22/2010 5:17 PM
15 Replies and 7023 Views OLE DB substitute?  7023  15 Started by  Russell Spreeman My organization wants to use Lawson Report Writer reports as the data source for Crystal Reports - which I have read about doing here and in the Lawson Knowledge Base. However we don't have Lawson LBI and they no longer sell the OLE DB connector as a separate item. If I go into Crystal Reports I see that I can add an OLE DB connector for Lawson but it does not give me any way to specify the Report Writer reports as a data source - only tables and such. Is there a way to duplicate what the Law...
15 7023
by  Russell SpreemanJump to last post
09/22/2010 1:59 PM
1 Replies and 1323 Views PATCOM report to LBI  1323  1 Started by  Xin Li Does anyone managed to publish any PATCOM relatedd report to LBI We would love to hear from you. PATCOM has its own propriety database and no ODBC driver for it. I wonder whether anyone come up with any creative way to publish PATCOM related report to LBI.
1 1323
by  Chris MartinJump to last post
09/16/2010 3:42 PM
2 Replies and 1093 Views Database Overrride Issue in 11g  1093  2 Started by  Ruma Malhotra Has anybody seen issues with the database override function with Oracle 11g and LBI 9.0.4. We have a number of odbc reports that were published and now with the oracle 11g upgrade from Oracle 10gR2 they have stpeed refreshing. Basically the database override function is not working when the reports point to the new DSN on the reporting services page and we are seeing this only on our upgrade to 11gR2. Has anybody experienced this
2 1093
by  Ruma MalhotraJump to last post
09/15/2010 4:00 PM
10 Replies and 1542 Views Creation of New Role In RS  1542  10 Started by  Ruma Malhotra Is there a way to create a role in reporting services that has access to all departments but excludes 2 departments. All users can access all reports for all departments except for those 2 that have been restricted.
10 1542
by  Ruma MalhotraJump to last post
09/14/2010 4:14 PM
2 Replies and 1357 Views Creation of link form one report to other report in LBI  1357  2 Started by  Naresh hello All, I have two crystal reports published in LBI. One is summary level report another is detail level report. Client is asking for link from summary level report to detail level report. I made attempts to use options 'Report part drill down' and 'Another report object' in Hyperlinks tab of formt editor in crystal reports 2008 and not succeeded. Any help would be appreciated.
2 1357
by  mikePJump to last post
09/14/2010 9:57 AM
3 Replies and 2922 Views crystal report viewer  2922  3 Started by  sharona I have crystal reports in the LBI. When the report is run it goes to the crystal viewer. when you select print it gives the option to export to pdf file. when export is chosen i get DOWNLOAD ACTIVE X prompt from the web. it then requires the user, after it is installed, to re run the report. how can this be fixed change permissions
3 2922
by  Jimmy ChiuJump to last post
09/13/2010 10:19 AM
2 Replies and 1548 Views Oracle Stored Procedure Missing  1548  2 Started by  David V I have written several Oracle stored procedures for our production and test Lawson DB. When I connect via ODBC within Crystal, I see the Stored Procedure in production, but I can not see the ones in Test. Any ideas why I am not able to see them in test
2 1548
by  David VJump to last post
09/08/2010 8:47 AM
8 Replies and 4078 Views HR Dashboard  4078  8 Started by  David Williams Can anyone give me examples of items to place on a Dashboard for Human Resources Thanks
8 4078
by  M.N.ReddyJump to last post
09/01/2010 11:29 PM
2 Replies and 2843 Views LBI Crystal Reports Bursting  2843  2 Started by  Carl.Seay Hello, I'm trying to burst a report to supervisors based on the departments they cover. In Reporting Services Administration, I've been able to set this up by using Import Rights, linking the supervisors user name to a specific department. Since supervisors change and employees change departments, is it posible to automate the process of uploading user rights with a CSV file Thanks in advance for any input, Carl Seay
2 2843
by  Carl.SeayJump to last post
08/30/2010 1:00 PM
4 Replies and 1605 Views LBI 9.0.4 - Framework Services security  1605  4 Started by  Ruma Malhotra In Version 904 any LBi roles defined at the dashboard levels is cascading down to the modules and indiviual links on the modules when any new role is added to the dashboards and saved. We have different levels of security set up for different modules and even links on the module. As an example if we have the HR dashboard, we may have all of the roles defined but we have modules where we have compensation, termination and not everybody on the HR dashboard should have access to these modules...
4 1605
by  Ruma MalhotraJump to last post
08/30/2010 12:12 PM
2 Replies and 1391 Views Report Parameters on Historical Instance  1391  2 Started by  Carl Gifford Is it possible to have report parameters that are selected by the report user to limit the output for the dispplayed report from a historical instance. For instance, if we have a termination report for the entire company that is scheduled to run every Monday, is possible to add a parameter (e.g department) that the user would be prompted for the further filter/select data from the historical instance If so, how would this be accomplished
2 1391
by  HeatherNelsonJump to last post
08/26/2010 4:11 PM
3 Replies and 1438 Views RW100 reports for previous period  1438  3 Started by  Joan Is there a way to force an RW100 report to run for a previous period without having to manually input the period number We publish the rw100 reports in LBI and have to manually run them for the previous period after the period is closed and I am trying to automate the process. Thanks
3 1438
by  Ruma MalhotraJump to last post
08/25/2010 2:53 PM
10 Replies and 4969 Views How to keep report format in PDF  4969  10 Started by  RoxanneS Has anyone had problems keeping the formating of your report when exporting it to PDF and figured out the solution My Finance department has requested their reports be a specific font (Arial), fontsize, margins and fixed dollar sign. I coded the Crystal to their exact specs and when I print it directly from Crystal, it is just what they are looking for. However, when I export it to a PDF format, the fontsize shrinks, the margins change and the dollar sign floats. My manager insists that I fi...
10 4969
by  RoxanneSJump to last post
08/23/2010 2:50 PM
0 Replies and 1625 Views Formula based on accrual rules/calculations  1625  0 Started by  Jen Hello, I am using Crystal to write our annual Benefit Statement. One of the sections is related to 'Paid Time Off.' An example is 'Based on your xx years of service you accrue xx hours per year.' We have one for Holidays to...and we have several employee groups who earn a different number of holidays. I want to be able to use Lawson fields/tables to create this formula (showing how much they accrue per year) but I don't know how to do this. The employee/plan/structure gr...
0 1625
08/20/2010 11:59 AM
8 Replies and 1642 Views Query based on date  1642  8 Started by  JonA Can I create a query that will pull data based on a date calculation I want to pull monthly purchase order information but only for 1 year back from the current date. So I can schedule the report to run at the end of each month and not have to change the date range every time. Something like <current date> - 365.
8 1642
by  JonAJump to last post
08/19/2010 11:32 AM
0 Replies and 1379 Views Crystal 11/Pivot Tables and LBI  1379  0 Started by  Lisa Stewart 1) Can you use Crystal XI to create Pivot tables 2) If you can create Pivot tables in Crystal can you use LBI to Burst the table
0 1379
08/19/2010 11:05 AM
3 Replies and 1545 Views Connection from SN to MS Access?  1545  3 Started by  Greg Moeller Anyone done a connection (data source) from Smart Notifications to a MS Access DB Could you provide me examples of what should be populated in the fields on data source creation Thanks in advance, -Greg
3 1545
by  Greg MoellerJump to last post
08/11/2010 2:35 PM
4 Replies and 1510 Views Application Links withing smart notifications.  1510  4 Started by  Ruma Malhotra I am trying to define a link to AP10 in smart notifications. Everything works fine. When I get the email alert and I am trying to click on the field to go to the application form in this case AP10, I get an error : 'The link to the Lawson form AP10.1 has not been defined.' How can I resolve this
4 1510
by  Ruma MalhotraJump to last post
08/11/2010 10:51 AM
0 Replies and 1475 Views Occasional corrupt pdf attachments in email  1475  0 Started by  Greg Moeller Is anyone else occasionally having an LBI report delivered to a users delivery device as an attachment that they cannot open because of 'Adobe Reader could not open <insert-report-file-name.pdf> because it is either not a supported file type or because the file has been damaged (for example, it was sent as an email attachment and wasn't correctly decoded). This has been plaguing our users occasionally just about since we came up on LBI. Anyone have any suggestions as to how to solve ...
0 1475
08/06/2010 4:13 PM
1 Replies and 1228 Views Direct IOS Service for Single Sign-on  1228  1 Started by  JohnO I need to setup SSO for an LBI 9.0.4.1 install with LSF 9.0.1.5. I see that now we have to create a direct IOS service to do this. The documents state that the Websphere service needs to run as a named user. Has anyone done this before I have 3 total service one for the Node Agent one for the Cell manager and one for the application server. Do I need to set this account for all 3 When I try this the services start and then stop. I am running Websphere 7.0.0.9.
1 1228
by  Matthew NyeJump to last post
08/05/2010 2:16 PM
0 Replies and 1128 Views Reporting From ML  1128  0 Started by  Char I have a client implementing ML and I've written a few dozen GL reports for them. It appears I'd simply replace the GL Tables with ML tables for MLAmounts and MLTrans. I don't have an operational database yet and I'm trying to scope the effort so if anyone can confirm that, I'd appreciate it. Thanks!
0 1128
08/04/2010 10:07 AM
1 Replies and 4640 Views Need OLE DB Connector for Lawson OLE DB Object Services - should I reinstall LBI?  4640  1 Started by  Ganesh R Hi We've a requirement to use 'OLE DB Connector for Lawson OLE DB Object Services' along with LBI for Reporting Services. Appreciate, if someone can throw some light on how we can get this driver installed using Lawson support site. Thanks.
1 4640
by  Chris MartinJump to last post
07/30/2010 4:27 PM
7 Replies and 3132 Views OLE DB date filter  3132  7 Started by  Nabil Hello all, I need to place a filter in my Command using OLE DB Query builder for the following: BENEFIT.STOP-DATE equal date(1800,1,1) or actually: BENEFIT.STOP-DATE is Null Does anyone know the syntax for Query builder to have this criteria I want to report to only output records with a null BEN-STOP-DATE... Thank you much,
7 3132
by  John HenleyJump to last post
07/29/2010 1:43 PM
3 Replies and 1531 Views Finance Dashboard  1531  3 Started by  Joe O'Toole Can anyone provide some examples of items they have on their Finance Dashboard in LBI Thanks.
3 1531
by  Ruma MalhotraJump to last post
07/29/2010 1:31 PM
2 Replies and 1554 Views Crystal Report utilizing Account Attribute Lists  1554  2 Started by  JeanneS Has anyone created a Crystal Report using Account Attribute Lists I want to use the GLAMOUNTS table but don't know how to join the account attributes to this table.
2 1554
by  JeanneSJump to last post
07/28/2010 1:59 PM
1 Replies and 1755 Views Comment Code  1755  1 Started by  Kevin Hagan I am working on creating a report that extracts various information on the PO based on the comment code. The code can be attached at the header or the line level. While I can see information on the comment code on table STCOMMCODE(PO). Unfortunetly this table has no links to a specific PO. in looking in various table like POLINE or PURCHORDER I have hade no luck in tracking the field to a specific table. Has anyone out there had any luck tracking down the table the comment code resides in...
1 1755
by  John HenleyJump to last post
07/23/2010 1:40 PM
4 Replies and 31392 Views Like condition in Crystal Reports  31392  4 Started by  Nabil Hi everyone, I'm trying to filter a job description to include only people with certain stings. For example: If Employee A job title includes 'Manager' then include it Usually Job title fields would contain a long description like 'AS0 HR Manager 2 Loc' I'm only interested in the 'Manager' part. I tried using like '' but that didn't work. Regards,
4 31392
by  FireGeek21Jump to last post
07/22/2010 2:53 PM
3 Replies and 1443 Views LBi Report Parameters don't stay set after upgrade  1443  3 Started by  Duane We did an LBI upgrade, amking copies of the LawsonFS, LawsonRS and LawsonSN SQL Server databases, installed LBI 90110154 which matched our current production LBI version, then upgraded to 9.0.3.2. We also migrated our Lawson Documents and Archive files from the current prod server to our new server. We pointed LBI to our new 9.0.1 Lawson apps product line database. We expected these reports to come up with the parameters we had set in our current production. We can go in and make the correct sel...
3 1443
by  Matthew NyeJump to last post
07/21/2010 3:25 PM
4 Replies and 2579 Views add report to lawson--You do not have access to view the latest instance of this report.  2579  4 Started by  sharonmt i have a report which i added to the lbi. i can run the report when i log in as the admin, no problem. when i log in as a specific group i get this error message You do not have access to view the latest instance of this report. the sharing on the report is set up to view all and i even added the group to the view users. do you think it may be a permission thing on the backend package
4 2579
by  sharonmtJump to last post
07/20/2010 10:24 AM
3 Replies and 1692 Views Time in a position  1692  3 Started by  charliewilliam Hi All, I have a request to calculate the length of time an employee has been in his/her position. I need to consider promotions, demotions, new hires. I am not sure which table(s) to start with... Could someone point me in the right direction Thanks in advance, CW
3 1692
by  Ruma MalhotraJump to last post
07/19/2010 11:52 AM
6 Replies and 3858 Views Data File Text equivalent for PLM tables?  3858  6 Started by  Chris Martin Is anybody aware of Data File Text-like documentation for PLM tables
6 3858
by  Chris MartinJump to last post
07/16/2010 11:39 AM
6 Replies and 1827 Views LBI as an enterprise solution  1827  6 Started by  David Williams Does anyone use LBI as their enterprise reporting repository I know Lawson sells it this way but does anyone use it for Cerner, McKesson or EPIC reporting as well Thanks
6 1827
by  Greg MoellerJump to last post
07/15/2010 3:21 PM
13 Replies and 2197 Views Using Smart Notifications To Query LDAP  2197  13 Started by  Ruma Malhotra I am using smart notifications to query LDAP and am able to get data. However I need certain fields in a container and I am not able to write the right syntax to query LDAP to get data for only certain fields. Has anyone able to get this to work and can share the exact syntax for those queries. I believe there are also certain oracle commands to query LDAP but I cannot get any to work and I am sure that the syntax is not right. Has anyone got this to work and willing to share the queries as w...
13 2197
by  Ruma MalhotraJump to last post
07/15/2010 10:18 AM
6 Replies and 1851 Views Looking for the SQL behind a Lawson report  1851  6 Started by  Wade-T Hello, I need to write a Crystal report that is similar to the AP265 but with some adjustments. I was wondering where you could find the SQL behind the existing Lawson report to use as my begining point. Is this how you would start Thank you, Wade
6 1851
by  TomwiseJump to last post
07/15/2010 6:07 AM
3 Replies and 2832 Views error  2832  3 Started by  sharonmt have a report which runs in crystal i run the report, it prompts for my stored proc parameters when it gets to the parameters that are in the report which are dynamic i get this error com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: Missing parameter values.---- Error code:-2147217394 Error code name:missingParameterValueError
3 2832
by  Matthew NyeJump to last post
07/08/2010 1:31 PM
6 Replies and 2306 Views crystal parameters  2306  6 Started by  sharonmt I am a crystal advanced user(using since 1987 every version) i have an issue with 2008 and the parameters it appears that i have to use dynamic paramters, but concerned there will be rpt maintennace when not useing a lookup table to retrieve the values(datasets are sql stored procedures) i would like to be able to use a static parameter where i can use and ALL option or the user can enter a value or multiple with the dynamic parameters i can only use what is from the database values an...
6 2306
by  sharonmtJump to last post
07/08/2010 12:28 PM
2 Replies and 1188 Views word PROD in smart notes content  1188  2 Started by  Ruma Malhotra Has anybody encountered an issue where smart notes content on the email is coming out with only the word 'PROD' in it
2 1188
by  Ruma MalhotraJump to last post
07/07/2010 1:01 PM
1 Replies and 1149 Views RW Report Data not showing in Cyrstal  1149  1 Started by  Katfra I used a RW100 report i created and moved it over to crystal. However, i'm missing 2 lines that are on my RW report so my numbers don't tie out. If i go to the specific data field and browse the data, i can see the data i'm missing. I've tried going to the select expert to specify that data but nothing comes up. Did i do somethign wrong or is something switched to prevent that data from showing
1 1149
by  sharonmtJump to last post
07/07/2010 12:54 PM
7 Replies and 2160 Views Crystal Security  2160  7 Started by  Kelly H Does anyone know of any way to lock down Crystal Security so that the end user can only see the departments they have access to in Lawson Or a way to give the end user view only access within Crystal Then we could write the reports with the limits behind the scenes and have them refresh them only. Thanks!!!
7 2160
by  Ruma MalhotraJump to last post
06/17/2010 8:30 AM
1 Replies and 1125 Views Multiple Output Files From one report  1125  1 Started by  David V I need to create a report in crystal that will read a file with many invoices in it. I then need to create a report for each invoice, that will be it's own file. For example, read 20 invoice. Create 20 files with 1 invoice each. Thanks...
1 1125
by  Matthew NyeJump to last post
06/16/2010 2:10 PM
2 Replies and 1429 Views Supply Chain Help  1429  2 Started by  Michael7 I have been working with LBI for the past year and a half developing and mainting HR specific reports. We are looking to expand into supply chain. I am completely new to supply chain, so I do not know the data structure or the key metrics related to this division. I was hoping I can find some help here. Maybe see some example reports related to materials management, purchasing, buyers, inventory, etc. Any help is greatly appreciated.
2 1429
by  Michael7Jump to last post
06/11/2010 12:53 PM
3 Replies and 2025 Views Publishing Excel/Word Files in LBI Dashboard  2025  3 Started by  Saurabh Hi All We have a set of Excel files refreshed every week by a job. I would like to place a link to those file in the Dashboard. Is this possible or does the LBI dashboard only allow either a 'web address' link or a published Crystal Report This is on LSf9.0.0.4 on Windows 2003 with SQL2005 backend Thanks Saurabh
3 2025
by  Matthew NyeJump to last post
06/10/2010 11:09 PM
2 Replies and 1215 Views Updates made system down  1215  2 Started by  Chitta Hi All, I am newbie to LBI, as we faced ERROR500 while brusting reports with details option, we advised for FSupdate to 9.0.3.1.151 and RS 9.0.3.1.156. But after updates the LBI install validator itself not working'page cannot find' error, and LBI application also the same error, but In WAS, FS,SN,RS every thing working fine, can any one help me where to look Regs, Chitta
2 1215
by  ChittaJump to last post
06/10/2010 5:34 AM
2 Replies and 1511 Views Need a report that shows previous pay rate  1511  2 Started by  Deleted User I am building a report that shows current pay rates, effective date, reason for the change, as well as the previous rate. I have everything except the previous rate working, and I keep hitting the wall. My logic has been to use a nthLargest=2 on the PRRATEHIST.BEG_DATE field. To pull the previous pay rate I then use the formula: if {PRRATEHIST.BEG_DATE} = NthLargest (2, {PRRATEHIST.BEG_DATE}, {EMPLOYEE.EMPLOYEE}) then {Pay Rate} Even though the {NthLargest (2, {PRRATEHI...
2 1511
by  Shane JonesJump to last post
06/02/2010 3:47 PM
12 Replies and 1903 Views Filter by Current User's Group  1903  12 Started by  MCordero Our company is very new to Lawson (9.0.1.5..still currently not live), and I've been looking at Crystal Reports 2008 through LBI. Most of our reports need to be filtered based off what facility the current user is a part of. How do I go about pulling user's Facility Group and pass it as a parameter Or, I suppose I should as a more general question of how do I pull a user's 'anything' to pass as a parameter
12 1903
by  MCorderoJump to last post
05/28/2010 9:56 AM
8 Replies and 1746 Views ACHISTDTL linked to PURCHORDER  1746  8 Started by  TracyO We are trying to create a Crystal report to create more meaningful invoices to our locations. The GL120/121 does not give enough details. I want to be able to somehow tie back to the PO line Descriptions. I am not sure if these are the correct files, but I see the information I need on ACHISTDTL for hte BR side and I have linked the PURCHORDER, POLINE & MMDIST tables to get what I need on that side. I am looking for the bridge to get me from one to the other. Has anyone created a report to ...
8 1746
by  TracyOJump to last post
05/20/2010 2:41 PM
20 Replies and 3698 Views Open an Image from a Crystal Report  3698  20 Started by  TracyO I have been asked to add a link to a Crystal report that will open up the image from Webnow.&160; The link would need to use informaion from the line of the report that you want to see the image for.&160; Has anyone done this or know where I can find information on how to do it.&160; I don't even know where to begin, so any help on where to find out the 'how to' would be greatly appreciated. Thanks
20 3698
by  TracyOJump to last post
05/18/2010 10:26 AM
2 Replies and 2479 Views Report to calculate PTO, Sick leave hours for taken by an employee  2479  2 Started by  Ruma Malhotra I am trying to create a report for all employees for their PTO hours, sick leave etc but for a month. Since this report should show me all the pto time taken by the employee for a months and all payroll tables store hours by pay period end date I would like to find out if anybody has created anything like this. This would mean that the pay period end date may fall on the first of the next month but have hours that belonged to the last 2 weeks of the previous month. Is there a formula that i...
2 2479
by  Ruma MalhotraJump to last post
05/14/2010 1:23 PM
5 Replies and 2535 Views Dashboard to publish crystal reports other than LBI  2535  5 Started by  Thomas Varughese Hi, Can some one recommend a solution that can be used to publish crystal reports other than LBI We have third party software that needs some crystal report development and these users should not be a Lawson user. We need to publish the reports to some kind of dashboard for the users to generate the reports. Any ideas and suggestions most appreciated. Thanks, Thomas.
5 2535
by  John HenleyJump to last post
05/14/2010 6:37 AM
7 Replies and 4646 Views DME query issues  4646  7 Started by  dipu how can I get the maximum check date while creating a query in Lawson Query Builder, where I have informations about employee, employee status, process level, company and paymastr only. Please help.
7 4646
by  Shane JonesJump to last post
05/10/2010 10:35 PM
4 Replies and 1349 Views Samrt Notification for Parent & Child  1349  4 Started by  Ruma Malhotra I am creating a smart notification which works like a parent-child but both parent and child are derived from 2 different infosets instead of the same. The parent notification is delivered and the child is not delivered as the case would be. I am trying to schedule both the parent and child infosets to update and wondering whether they should be scheduled at the same time or whether the child before the parent. The logic for this is if the parent and child infosets update on the same ...
4 1349
by  Ruma MalhotraJump to last post
05/10/2010 11:24 AM
5 Replies and 4106 Views PO Comments  4106  5 Started by  Kevin Hagan I am working on a report and looking to pull in the comments added from the PO20 screen. Originally I thought that they would be stored in either L_HPCR or L_DPCR but that turned out not to be the case. I am hoping that someone can point me to the table these comments are stored in.
5 4106
by  Kevin HaganJump to last post
05/06/2010 10:29 AM
2 Replies and 1142 Views Count/Sum Question  1142  2 Started by  FireGeek21 I have an id field in which the same id may exist multiple times for an employee. I have another field whose values are true or false. How can I count the number of true/falses for each unique id
2 1142
by  FireGeek21Jump to last post
04/28/2010 3:48 PM
6 Replies and 1983 Views DSSO upgrade to 9.0.1.5  1983  6 Started by  Chitta Hi, I am planing to upgrade our Lawson LSF 9.0.1.2 to 9.0.1.5, being the part of it, i have to upgrade LBI as well, but i have no idea where to download DSSO 9.0.1.5, i cannot found in Products download page in LGS. can any one please provide me the steps and for upgrade DSSO
6 1983
by  Matthew NyeJump to last post
04/28/2010 7:27 AM
1 Replies and 1169 Views Issues in Crystal Report  1169  1 Started by  dipu How can I get the max value of check-date in lawson 9 with crystal reports9. I created a report how ever it is not showing the correct value. Please help. The condition I need is the max( check-date)<= currentdate - 90
1 1169
by  CharJump to last post
04/28/2010 6:47 AM
2 Replies and 1083 Views Crystal Report Issue  1083  2 Started by  dipu I have created a crystal report with two oledb commands. After refreshing the report lot of duplicate data is coming. How can I remove those duplicate data from the report please help.When used these commands in seperate reports I got correct data without duplicates. The join I have taken is left outer join.
2 1083
by  Matthew NyeJump to last post
04/23/2010 2:12 AM
4 Replies and 2106 Views Capture User ID  2106  4 Started by  David V Is there a way to capture the user name and display it on the report And does anyone know how to capture rules info for a user. So I need a report that lists the current user and the rules that exist for that user. Example: Current User - ABC Rule - Company Values - 1,2,3,4
4 2106
by  Jimmy ChiuJump to last post
04/21/2010 12:18 AM
0 Replies and 1408 Views MSCM signatures on report  1408  0 Started by  mark.cook I have a request for data from MSCM to show deliveries, show it was delivered to and also the signatures that were captured. I can gather all the needed data, I see the bitmap field for the signature but want to convert that to the signature to show on a report. Has anyone done this that can share some thoughts on how to code this
0 1408
04/14/2010 11:24 AM
3 Replies and 1548 Views Copy to Test ???  1548  3 Started by  Ken Carley Okay, so we have been up and running on LBI for a little while now and things seem stable. Of course we don't want to just leave it that way, so we are looking into what needs to be done to make a Copy of PROD in TEST. We started looking at creating the backoffice jobs and republishing all the Crystal reports too and that just seems silly. Does anyone have a repeatable process that we should follow or did I miss something in the Lawson knowledgebase.. Thanks for your help/time, Ken
3 1548
by  Matthew NyeJump to last post
04/14/2010 11:21 AM
2 Replies and 1175 Views Group Tree - Hide Field  1175  2 Started by  David V I have an income statement type of report that runs by dept. But I have to use a stat from a different dept to do calculations. I am able to hide the values on the report, but it still shows up in the group tree. Is there a way to remove it or hide the value
2 1175
by  David VJump to last post
04/13/2010 12:59 PM
6 Replies and 1575 Views Crystal Report Issue  1575  6 Started by  JeanneS I have a crystal report that uses an union query to pull the actual and budget amounts from the GLAMOUNTS and FBDETAIL. The query lists the amounts all on the same row as shown below (12 debit fields and 12 credit fields). FY AU Account debitperiod1 creditperiod1 debitperiod2 creditperiod2 debitperiod3 etc. I want to list my data as shown below where the net amount is the total of the debit and credit for each period and the period is 1, 2, 3 etc: FY AU Account Net Amount Period ...
6 1575
by  JeanneSJump to last post
04/10/2010 8:14 PM
3 Replies and 3583 Views Multiple ODBC data sources on LBI server  3583  3 Started by  Nick I might be being a little naive, but can multiple ODBC datasource DNSs be loaded on the LBI server for Crystal We have four product lines, each set-up to accept ODBC (I can run reports from the designer) and would like to be able to run them through LBI as well. Nick
3 3583
by  mikePJump to last post
03/31/2010 9:04 AM
4 Replies and 2080 Views New to Crystal  2080  4 Started by  Katfra Hello, I have some very basic questions so please bear with me.&160;&160; I had crystal training for Lawson in March of last year and after returning, I&160;had learned a lot but my company was going through some changes which required me to direct my attention to other pressing issues.&160; So, basically i have forgotten the core of what i need to know.&160; First, I'm using Crystal Reports XI along with Lawson Query Builder.&160; We discussed Lawson query builder breifly on the last da...
4 2080
by  KatfraJump to last post
03/31/2010 8:17 AM
7 Replies and 1927 Views Problem Publishing GL291  1927  7 Started by  dcaiani I had a request to publish GL291 (Trial Balance) onto an LBI dashboard.&160; So when I went through the publishing steps, I selected back office reports, the product line, the job name, etc.&160; I published the report and&160;ran it a second time.&160; When I try to view the report its shows up as a blank screen.&160; Has anyone published a GL291 or other non-rw100 back office report&160; Any suggestions, tips, pointers
7 1927
by  dcaianiJump to last post
03/30/2010 11:46 AM
1 Replies and 1211 Views SmartNotes Outlook Appointments  1211  1 Started by  Deleted User Is there any way in Smart Notes to send Outlook appointments
1 1211
by  Matthew NyeJump to last post
03/26/2010 10:50 PM
3 Replies and 1181 Views Crystal to Object Services Association  1181  3 Started by  dukeslater My boss delivered a working Crystal report (created with v.10), and&160;I can refresh it fine using the 4.1.14 version of Object Services (I don't know why we can't use the current version, but I know it doesn't work in our environment). On the boss's pc, whenyou&160;right click on the command object in Crystal and select 'Edit Command', the query opens in the Object Services query builder. However, when I do the same on my pc &160;(using v.11 of Crystal) it just opens the standard Crystal t...
3 1181
by  Chris MartinJump to last post
03/22/2010 12:06 PM
2 Replies and 1180 Views Crystal Formula Report  1180  2 Started by  David V Is there a way to print a list of the formula that you are using in your report. I need to show a user a list of my formulas as well as the formula itself. &160; Thanks, David
2 1180
by  David VJump to last post
03/19/2010 11:36 AM
3 Replies and 1389 Views Reporting Service Upgrade from 9.0.1.10.154 to 9.0.2..0.464  1389  3 Started by  Deleted User I recently upgrade the LBI in my test environment from 9.0.1.10.154 to 9.0.2.0.464. Everything seems fine except when doing the Reporting Serivce upgrade. The old JNDI name for 9.0.1.10.154 was set&160; to jdbc/LawsonRS901 and new JNDI was set to jdbc/LawsonRS. In Step 3 of the Reporting Service validation, I clicked the upgrade, and get the following error message: The proces of configurating the Reporing Services system settings was successful, but the process of upgrading the 9.0.2 instance...
3 1389
by  Chris MartinJump to last post
03/17/2010 10:37 AM
12 Replies and 2178 Views OnDemand linked subreport in Crystal question  2178  12 Started by  Jan I&160;have a design dilemma with my Crystal report.&160; I have two subreports that I've put onto the detail line as on-demand reports.&160; I like the way this looks but since the on-demand report doesn't run in LBI until the user clicks on the link, they are asked to enter their odbc userid/password to call the data up.&160; Is there anyway to include this subreport as an on-demand item on the detail, but get around forcing the user to enter a userid/password &160;
12 2178
by  JanJump to last post
03/16/2010 3:50 PM
8 Replies and 1804 Views Smart Notes/Frame Work Services Authentication  1804  8 Started by  Deleted User I started with just wanting to install Smart Notes but found out that in the newer addition of Smart Notes Framework service is now required. In looking through how to setup authentication in Framework services and I ran across this.&160; '..DSSO is only required on application servers that do not run the Lawson Environment. For example, if you run LBI under the same WebSphere application server instance as the Lawson Environment and applications, you do not install DSSO. Instead, in the LBI y...
8 1804
by  Deleted UserJump to last post
03/16/2010 3:26 PM
2 Replies and 1140 Views Crystal Group Tree Nbr Format  1140  2 Started by  David V On my crystal report Group Tree the Company number is 1000, but when I&160;publish it in LBI&160;the format changes to 1,000.
2 1140
by  John HenleyJump to last post
03/16/2010 3:08 PM
11 Replies and 1508 Views Crystal Rounding Issue  1508  11 Started by  David V Sorry if this is dumb question.&160;&160; I have a report that captures the total of a group of accounts, It then groups the accounts together and reports the total.&160; I am suppressing the decimals when showing the totals.&160; When I display the Grand Total, the totals do not equal the previous Displayed totals.&160; It shows the summary total which is different because of rounding.&160; Any ideas how to get around this Example:&160; Capturing Account totals for 500000 - 599999. Ac...
11 1508
by  Chris MartinJump to last post
03/11/2010 10:08 AM
3 Replies and 2056 Views Income Statement Account subtotal group table???  2056  3 Started by  Gary I need to create a report based on the GL293 Income Statement that is based on AC Activities rather GL Accounting Units.&160;&160;The GL293&160;subtotals Accounts by Income Statement&160;groups/classes (i.e. Gross Sales, Net Sales, COGS, Gross Profit, etc.).&160; Can anyone help me with what table&160;has Income Statement Account subtotal types for this report&160; THANKS!!!!!!
3 2056
by  CharJump to last post
03/10/2010 10:29 AM
4 Replies and 1260 Views Report Access and Users that have left the organization  1260  4 Started by  Ruma Malhotra There are a number of reports published on LBI that have indiviual user-ids attached to the report when the report is published on reporting services.We are on version 9.0.3.1.Some of these users have left the organization and we have setup synchronization to be done every morning with the option of Remove Expired Users and Roles checked. What I am finding out&160; is that this removes the users and roles for each report on the dashboard link but not when the report is originally published on ...
4 1260
by  Ruma MalhotraJump to last post
03/10/2010 10:21 AM
4 Replies and 1550 Views Exporting and importing Rights From Rights management  1550  4 Started by  Ruma Malhotra We are getting ready to do a setup of all rights in the production environment on our several testing environments to start various testing. In order for me to accomplish this I am planning to do an export or dump of all rights from production create a csv and then import it into the testing environments. &160; in the reporting services manauals there are procesdures that explain the importing peice and the csv file that contains the rights but no information on how to extract all the rights...
4 1550
by  Ruma MalhotraJump to last post
03/10/2010 10:15 AM
2 Replies and 4928 Views Adam and LBI  4928  2 Started by  Ruma Malhotra We have created users in the sec admin tool that have been added to LBI. While using the synchronize tool on LBI I get an error which basically is asking us to increase the page size on ADAM. However when we do this we running into this error: ldap policy: show values *** Error: ldap_search of ldapAdminLimits failed with 0x20(32 (No Such Object). Ldap extended error message is 0000208D: NameErr: DSID-031521D2, problem 2001 (N O_OBJECT), data 0, best match of: 'CN=Configuration,CN={1EB8...
2 4928
by  Ruma MalhotraJump to last post
03/10/2010 10:13 AM
5 Replies and 3318 Views WinHttpRequest Error  3318  5 Started by  David Williams When trying to connect to Lawson as the datasource in a Crystal report using Lawson OLE-DB connector we're getting an error. ADO Error Code: 0x800072ee7 WinHttp.WinHttpRequest Server name or address could not be found. I thought I've seen this before but can't remember the fix to it.
5 3318
by  David WilliamsJump to last post
03/09/2010 8:21 PM
4 Replies and 1504 Views Smart Notes Install  1504  4 Started by  Deleted User I did get version 9.0.4 from Lawson.&160; I am attempting to do a new install on Websphere 6.1.&160; This is so we can get ride of an older server etc.&160;&160; The latest issue on the install is that I can get the installvalidator.jsp to work however in loging in I am getting this error: JSPG0036E: Failed to find resource /lsn/SmartNotifications.jsp &160;
4 1504
by  Matthew NyeJump to last post
03/08/2010 11:36 AM
3 Replies and 2519 Views LBI – Report usage tracking  2519  3 Started by  Thomas Varughese Can anyone suggest how to write reports on Reports usage tracking We have several reports published to LBI and would like to know who and when the reports were run…. Since LBI don’t store the user-id and the run date as variables, we are not able to update these to a table….Did any one of you ventured into this situation &160; Thanks, &160; Thomas.
3 2519
by  Matthew NyeJump to last post
03/05/2010 10:25 PM
9 Replies and 2148 Views LBI data source related error  2148  9 Started by  Gus Chan I am new to LBI, and I am getting an LBI Data Source Related error in the sales tab.&160; The error is&160;'&160;Query (1, 31) The 'HIERARCHY' function cannot accept a null member as the argument.' Somebody please help.&160; Thanks
9 2148
by  Gus ChanJump to last post
03/05/2010 1:11 PM
0 Replies and 1998 Views Crystal Report for Actual vs. Budget by Quarter  1998  0 Started by  JeanneS I have created a crystal report for actual vs. budget using an union command with the FBDETAIL and GLAMOUNTS tables.&160; I am able to calculate the quarter totals for both actual and budgets by Accounting Unit.&160; The quarter totals are listed on the same line.&160; I want to combine all of the quarters into one amount column by quarter with seperate columns for the actual and budget so I can create a graph by quarter showing both actual and budget. Any suggestions on how to do this&160...
0 1998
03/04/2010 7:08 PM
5 Replies and 2694 Views Smart Notes install.  2694  5 Started by  Deleted User &160; I would like to move our development Smart Notes install to another server and during the install I have gotten the following error.&160; Has anyone seen this type of error before&160; I googled it and it seems like I am pulling in two different defitions for the Formatter.&160; JSPG0049E: /admin/installvalidator.jsp failed to compile : JSPG0091E: An error occurred at line: 894 in the file: /admin/installvalidator.jsp JSPG0093E: Generated servlet error from file: /admin/installva...
5 2694
by  Deleted UserJump to last post
02/26/2010 9:11 AM
3 Replies and 2174 Views Reporting LBI Statistics  2174  3 Started by  jellis Hi, I am looking for some thoughts or input on tracking user info in LBI. Specifically I&160;am looking for a way to keep track of userid, IP, and report ran information from users who go out to LBI from Portal or come straight into LBI. SSO is enabled and LBI&160;is version 9.0.3.2.116/117. Thanks, James
3 2174
by  Matthew NyeJump to last post
02/24/2010 8:41 PM
0 Replies and 1290 Views LBI Dashboard and Smart Office  1290  0 Started by  North1 Has anyone run LBI&160;Dasboards from SmartOffice
0 1290
02/23/2010 9:28 AM
0 Replies and 1720 Views Pass parameters into LBI report  1720  0 Started by  Deleted User I wanted to see if it's possible to pass parameters from a lawson screen into an LBI report Users would like the PO Print report integrated into the PO20 screen in Lawson.&160;&160; I was thinking that I could write a script with Design Studio and get the PO Number, Revision, etc off the screen and pass them into the LBI report, and open the report in a seperate window. &160; Does anyone know if this is possible&160; I'm not that familiar with LBI but have done something similar with Orac...
0 1720
02/18/2010 10:13 PM
4 Replies and 1302 Views Portal report as Data Source for LBI Crystal report  1302  4 Started by  Illvatar We have some users who have access to LBI but not to Portal, so we have several Portal reports that we read into Crystal and output in LBI, usually in Excel format.&160; One report that I am trying to do this with is the Payment Voucher Interface Error Report (YP520).&160; This report has two logical sections to is, depending on the types of errors encountered.&160; The report populates 0, 1, or both sections, depending on the errors encountered, if any. My problem is that I need to be able ...
4 1302
by  IllvatarJump to last post
02/05/2010 2:27 PM
2 Replies and 2455 Views Linking GLTrans table with APDISTRIB  2455  2 Started by  JL Cabrera Can anyone help me with the relationship between the gltrans table and the apdistrib&160; I need to join both tables for reporting purposes.&160; Thanks in advance for the help. &160;
2 2455
by  John CostaJump to last post
02/05/2010 8:13 AM
0 Replies and 1119 Views Scorecard Combine/Totals  1119  0 Started by  mark.cook I am fairly new to scorecard. I have a Employee Turnover data cube that I produce views for Managers. I have a request to combine several AU's turnover and get a total. These AU's don't have any other combination (manager, au heirarchy, etc) that I can use the select all to get a grand total. Basically &160;I am trying to combine these AU's turnover on 1 view in scorecard and get a grand total.&160; It seems like this is an easy fix just need some direction. &160; Thank you
0 1119
02/04/2010 12:55 PM
2 Replies and 1146 Views Scheduled Reports and Report Filters  1146  2 Started by  Charlotte Chase Is there any way to have a dynamic Report Filter on a scheduled report, i.e. such that the scheduled report runs for a large dataset, but the user is prompted to supply&160;an&160;additional&160;record filter parameter It looks like the schedule requires a value to be supplied for the record filter, as well as the Crystal parameters. I'm trying to avoid having to create more complex bursting rights for some of our scheduled reports/or publish a million different iterations of the same repor...
2 1146
by  mark.cookJump to last post
02/01/2010 7:45 PM
6 Replies and 1982 Views Error on Published Crystal Report  1982  6 Started by  BradF I was wondering if anyone has run into the below error.&160; The person is using the URL from a published report. Thanks, Brad Error Failed to retrieve data ...
6 1982
by  BradFJump to last post
02/01/2010 3:53 PM
0 Replies and 1348 Views AR Payment Tracking  1348  0 Started by  Ruth I am developing a crystal report that recognizes income when the funds are received.&160; We have AR payments that we received and applied.&160; How can I track each of these payments down to the individual invoice distribution lines they have paid
0 1348
01/29/2010 4:12 PM
1 Replies and 1136 Views Scheduling Crystal outside of LBI  1136  1 Started by  Joe O'Toole Due to&160;limitations with the LBI scheduler we're looking for an alternative. We need the ability to run&160;a given Crystal report with&160;multiple parameters and&160;publish pdf output to a static location. It could either be one large reprt that is bursted or multiple invocations as long as the end result has each report going to it's desired location on disk. Is anyone scheduling their reports outside of LBI with a product that can do this I've heard this functionality may exist in B...
1 1136
by  CharJump to last post
01/28/2010 11:19 AM
1 Replies and 1099 Views Module Colors in a single dashboard  1099  1 Started by  Ruma Malhotra We have one dashboard that is being shared by 2 different responsible parties. They would like all of their reports on the same dashboard but want to visually differentaite one module from another with the use of different module colors. When you choose modules and edit dashboard there is a dropdown for the color and this color applies to all of the modules within that dashboard. But how can I change 2 modules to be of 2 different colors on the same dashboard has anyone been able to acheive th...
1 1099
by  Chris MartinJump to last post
01/27/2010 10:51 AM
4 Replies and 1613 Views LBI report information in a report  1613  4 Started by  Greg Moeller All: I have been tasked with creating a report containing the LBI&160;report number, LBI Report name, LBI report owner, LBI report schedule, and LBI&160;Report Users. I can pull the first three out of the ERS_REPORT table, but where would I&160;find the schedule and report users Thinking a Y/N&160;flag would suffice for the schedule, but the users may want Weekly, Daily, time it runs, etc. The report users-&160;&160; Where do I go for those, and how do I link the tables appropriatel...
4 1613
by  Greg MoellerJump to last post
01/26/2010 3:36 PM
4 Replies and 1756 Views Upgrade From 9.0.3.1 to 9.0.4 LBI Issue  1756  4 Started by  Ruma Malhotra We upgraded just recently on one of our test system from LBI 9031 to 904 and found that framework services did not keep the permissions for each of the dashboards and modules after the upgrade. Has anybody run into this issue What was your solution
4 1756
by  Ruma MalhotraJump to last post
01/26/2010 1:12 PM
2 Replies and 2551 Views LBI and device import  2551  2 Started by  Greg Moeller Say, does anyone have any (recent) experience uploading/importing devices to LBI&160;reporting services&160; The reason I&160;ask, is that I'm trying to conform my csv file to what we initially uploaded years ago, and it won't import. Have the file specs now changed&160; We are on LBI v 9.0.3.2.116 and originally when the files I&160;have were successfully uploaded we were on maybe v 8.0.1 Lawson's documentation leaves a little to be desired in this subject. Any help would be appre...
2 2551
by  Greg MoellerJump to last post
01/26/2010 12:56 PM
1 Replies and 1471 Views LBI rollout to Power Designers  1471  1 Started by  mark.cook We are in the process of completing our LBI dev server with the intent of allowing a small group of power designers to build reports, SN, Dashboards in DEV. If you have rolled this out to a group like this, other than a standard promotion process, what are the big gotcha's that you can share.
1 1471
by  Milo TsukroffJump to last post
01/26/2010 10:33 AM
8 Replies and 1460 Views I want to install my own Crystal server on top of LBI  1460  8 Started by  Mike Schlenk We're currently using LBI for Lawson report distribution only (e-broadcasting replacement).&160; We did not buy enterprise reporting or any Crystal from Lawson. I have non-Lawson needs for Crystal server. &160;I'd like to install it in a way that LBI&160;still knows it's there and can publish an rpt.&160; This is an effort to provide one reporting portal (use LBI) for Lawson and non-Lawson reports. Has anyone done this&160;&160;Lawson is very 'stand-offish' unless we buy the whole repor...
8 1460
by  CharJump to last post
01/13/2010 2:59 PM
2 Replies and 1403 Views Crystal 2008 and Oracle Stored Procedures performance.  1403  2 Started by  Charlotte Chase Crystal 2008 and Oracle Stored Procedures performance. I am benchmarking a report that uses the native Oracle driver and an Oracle stored procedure with a ref_cursor on a Crystal 2008 report. The performance is horrible when compared to using a SQL command directly in the report. Anyone have experience with this Is there a way to use a bulk collect rather than the ref_cursor to improve performance
2 1403
by  Charlotte ChaseJump to last post
01/13/2010 2:57 PM
1 Replies and 1790 Views Scorecard  1790  1 Started by  jellis Hi All, I have had LBI 9.0.3.2 implemented for awhile now and need to finish up with Scorecard. I&160;have installed the application, setup analysis services and the data loader, but I&160;am either not understanding or not finding Cubebuilder v9.x or is this functionality located in IA150 Any pointers would be much appreciated. James
1 1790
by  Ruma MalhotraJump to last post
01/12/2010 4:18 PM
3 Replies and 3171 Views How to create unapplied cash report for Lawson M3 database  3171  3 Started by  Naresh i have experience with crystal but not with M3 database. I have LBI, M3 database(Oracle) and crystal. I also have smart office client installed to access M3 and its programs. User wants to see the Unapplied cash report of customers which doesn't include deposits by the customers. &160; What tables, fields, and conditions i should use to get this report Any help would be appreciated... And , I&160;have been reading lot about Lawson Apllication reports and Lawson Back office reports what...
3 3171
by  Rob ConradJump to last post
01/08/2010 2:18 AM
3 Replies and 1790 Views How to schedule crystal reports in LBI?  1790  3 Started by  Ada Hi, I'm having problem with my scheduling. Have no instance on server whatsoever. My crystal report contains subreports. In crystal designer, I can preview the report including both main report and subreport content. I can also view the latest instance or with data refresh after report published.But when I create a schedule with parameter value assigned and bursting option structure defined. There isn't any instance bursted on my server. Did I missing anything when schedule Any ideas Than...
3 1790
by  Ruma MalhotraJump to last post
01/07/2010 5:05 PM
2 Replies and 1424 Views Drop Menu options  1424  2 Started by  ram32bo Can the drop menu on the top right hand corner that enables users to 'Refresh' or 'Log Out 'UserID'' be changed Is it possible to remove the 'Log Out' function from this menu I don't know why, but when a user attempts to log out from there, nothing happens. I need to figure out a way to either make this work or remove the option. Please advise.
2 1424
by  Arvin OjalesJump to last post
01/06/2010 10:02 AM
11 Replies and 1953 Views LBI Monitoring  1953  11 Started by  Jan HI - this question kind of piggy-backs on the recent LBI monitoring question. I publish a series of Lawson Back Office reports that I burst at view time on company/cost center.&160; Most users have rights to a single company/cost center - but a handful have rights to all company/cost centers.&160; When these users try to view the report, the bursting success is sporadic.&160; This Monday, we attempted to view one of these reports (with the user who can view all company/cost centers).&160; W...
11 1953
by  Chris MartinJump to last post
01/05/2010 2:31 PM
2 Replies and 1740 Views Tools to monitor LBI health  1740  2 Started by  Xin Li Anybody out there ever implement any tools to montior LBI health We had some issues at one point scheduled reports did not run due to LBI failed to connect to backend SQL Server database. It would be nice to catch this kind of error before my users do. &160;
2 1740
by  Kirk ComptonJump to last post
01/04/2010 7:31 AM
3 Replies and 3194 Views LBI Session Timeout  3194  3 Started by  ram32bo I am new at being an app. admin for LBI. Currently, we have our timeout set at 30 mins, but my concern is that information can be left on the screen and doesn't actually go back to the log in screen after the timeout. What needs to be done to have LBI timeout and send the screen back to the log in screen so no information is left on the screen &160;
3 3194
by  ram32boJump to last post
12/31/2009 11:09 AM
1 Replies and 1205 Views Connecting APVENMAST to APHOLDCODE  1205  1 Started by  Kim92 Does anyone have the proper joins in Crystal for linking the APVENMAST and the APHOLDCODE&160; I&160;have attempted multiple scenarios and nothing seems to be working.&160; Thank you.
1 1205
by  mark.cookJump to last post
12/24/2009 9:08 AM
2 Replies and 1172 Views Dashboard item, mark a check box as complete?  1172  2 Started by  Deleted User Hello.&160; Has anyone been able to apply a check box feature, to left of an item, on the module list within a Dashboard&160; So as the user goes through the list of modules in the Dashboard, a check box can be checked off indicating that one has been done, etc.&160; Thank you, any guidance is greatly appreciated.
2 1172
by  Deleted UserJump to last post
12/22/2009 3:36 PM
2 Replies and 1293 Views Crystal Report - Help  1293  2 Started by  arod I need help. I have never used Crystal before and I need to create service awards report. We currently have one in place, but the last time I ran it, it gave me incorrect data. So...I thought I would create one myself...I don't know how.&160; I have managed to learn the basics but nothing else afterwards.Service awards are for the 1st quarter of 2010 for service years as follows: &160;5 years, 10, 15, 20, 25, 30, 35, 40, 45, and 50 years of service. How do I go about doing this I have been ...
2 1293
by  NareshJump to last post
12/16/2009 6:13 AM
1 Replies and 1269 Views ADO Error  1269  1 Started by  Nabil When I&160;attempt to log in the server&160;using OLE DB&160;to create a report, I get and ADO error: 0x80072ee7 Does anybody know how to work around this issue
1 1269
by  NareshJump to last post
12/15/2009 2:51 PM
3 Replies and 3797 Views PA100 report  3797  3 Started by  Ruma Malhotra Has anybody been able to create the PA100 report straight from the Lawson tables. Our HR dept runs the PA100 everyday to update personnel actions. The PR dept needs this report but in a different format and sorted not by employee but in a different way. The problem in creating this report is changes to an employees record is stored as current on HR11 or the employee table and the previous value is tored in the HR history table. For every personnel action which may be about 70-100 changes each p...
3 3797
by  NareshJump to last post
12/15/2009 2:45 PM
0 Replies and 1853 Views User Fields and Crystal Reports  1853  0 Started by  Shane Jones I have been asked about this a few times recently and wanted to share what we did to make user fields easier in Crystal Reports:&160;&160; If course, the field_name field should be your field names...&160; We added the following as a database view: SELECT&160;&160;&160;&160; COMPANY, EMPLOYEE, &160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160;&160; (SELECT&160;&160;&160;&160; ufv.A_FIELD ...
0 1853
12/09/2009 7:21 PM
5 Replies and 1621 Views Multiple Instances of RAS on a single server ?  1621  5 Started by  Ruma Malhotra We are looking to upgrade to LBI 9.0.4 and lookin at the multiple instances of RAS on the same server install. Has anyone implemented this. If so can you find performance, response and throughput increases tia, Ruma.
5 1621
by  Ruma MalhotraJump to last post
12/09/2009 2:17 PM
1 Replies and 1297 Views Linking two Crystal Reports  1297  1 Started by  Nick We have two reports that are currently set up as a main report (listing employees) and a subreport (a form with detailed information for a specific employee) that is linked on the EMPLOYEE.EMPLOYEE field.&160; The issue is that while the main report needs to be in Landscape, the subreport form needs to be Portrait.&160; Apparently Crystal can't handle having the two reports in different orientations. I am trying to instead have them as two separate reports, linked together via the EMPLOYEE.EM...
1 1297
by  Matthew NyeJump to last post
12/04/2009 7:59 AM
1 Replies and 1455 Views Add Parameters to Lawson Report  1455  1 Started by  Nabil Is it possible to add parameters to a Lawson Back Office Report using LBI I noticed I wasn't able to see 'Add a Parameter' when I published my report in .lxr format Thanks
1 1455
by  Chris MartinJump to last post
12/03/2009 3:39 PM
7 Replies and 1568 Views Windows 2003 Vs Windows 2008?  1568  7 Started by  Ruma Malhotra Our LBI server has windows 2003 as the os. We are looking to upgrade from LBI 903 to LBI 904. At the same time we are looking to upgrade to windows 2008 from windows 2003. Has anybody have this configuration. Any experiences you can share
7 1568
by  Ruma MalhotraJump to last post
12/03/2009 1:08 PM
3 Replies and 10827 Views Crystal Report set to null by each parameter???  10827  3 Started by  Deleted User Can anyone tell me what 'set to null' on the parameter screen is or does We run Crystal reports from Lawson's dashboard and this 'appears' to serve no purpose and is distracting but I haven't been able to find it any of our books or in my research. I would like to remove it. Any help would be greatly appreciated!!
3 10827
by  Deleted UserJump to last post
11/20/2009 1:30 PM
2 Replies and 1940 Views What tables does MM280 pull from? Trying to match the data in a report.  1940  2 Started by  willz06jw Hi and thanks for your help, I am trying to pull information from the Lawson database that will give me a departmental expense report exactly like MM280.&160; I am using Crystal reports to turn the information into a series of nice looking graphs.&160; I have to use the accounting-unit to group my data. Unfortunately, I cannot make my data pull equal what MM280 shows.&160; My management is not too pleased about this I am currently pulling using two tables: the POLINE table (using PURCHORDE...
2 1940
by  John CrudeleJump to last post
11/19/2009 8:06 AM
10 Replies and 1892 Views InfoSet Wizard not Autocreating from a stored procedure  1892  10 Started by  Thomas Harlan Hola! I'm trying to set up an InfoSet to drive a SmartNote, but the query I'm starting with is based on a SQL&160;2000 stored procedure (in McKesson MM, actually) that uses a slew of temp tables and IF/logic - and all of that is confusing the InfoSet wizard. When I&160;try and auto-create the InfoSet, I&160;get this error: ADMINUI1010: ... The statement did not return a result set The query runs fine in Toad or Query Analyzer; so obviously rows *are* coming back... just not in a way that ...
10 1892
by  Matthew NyeJump to last post
11/12/2009 1:26 PM
2 Replies and 1887 Views lbi Report Instances  1887  2 Started by  Deleted User Can you go back and update an instance for the period that an adjustment was made in.&160;&160;&160; Our users had to go back to june and july periods and make adjustments.&160; Now they want&160; the June instance and the July instance to reflect the changes in the Crystal reports.&160; These reports are&160;created &160;from the tables&160; through&160; Crystal and we scheduled them to run when the period is closed on LBI.&160; &160; These reports are not&160; OnDemand.&160;
2 1887
by  Jeff LimJump to last post
11/12/2009 1:14 PM
4 Replies and 1705 Views Datbase connector error  1705  4 Started by  Troy Hello, I am working with a client who we recently&160;migrated and also upgraded from lsf8 to lsf9.&160; They are running Enterprise CMC version&160;11.5.10.1263 connecting via OLE DB version 9.0.4.&160; We are getting lots of cases stating that some of their bigger reports have come to a crawl since upgrading to lsf9.&160; These reports are running 10-12 hours in some cases and timing out.&160; They tried increasing 'Connect Timeout' just to see if it will finish, but no luck.&160; I&...
4 1705
by  TroyJump to last post
11/09/2009 1:06 PM
3 Replies and 2574 Views Design Studio URL opening Crystal with Parameters  2574  3 Started by  David Williams I'm trying to open an LBI&160;Crystal Report by launching a URL within Design Studio. I thought I understood how to pass the parameters within this URL but I can't get it to work. This is what I used: /efs/FSRemotefsid=RS:RS-ERS:186&POCODE=code&PONUMBER=10&PORELEASE=0 The correct report opens but the parameters aren't being accepted.
3 2574
by  David WilliamsJump to last post
11/05/2009 1:32 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 3 of 5 << < 12345 > >>


RSS Feed Available