Forums
 Topics
 Replies
 Last Post
179 Topics and 618 Replies Smart Notification  179  618
RE: Deliver LBI report in...
by  Mark Petereit
11/01/2017 6:54 AM
179 618
RE: Deliver LBI report in...
by  Mark Petereit
11/01/2017 6:54 AM
Search this forum:
Search
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 5 of 9 << < 34567 > >>
Topics
 Replies
 Views
 Last Post
3 Replies and 1889 Views Anyone Using non-Lawson scheduler to schedule, run, and distribute reports published in LBI  1889  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 1889
by  TimJump to last post
03/09/2011 3:59 PM
3 Replies and 1116 Views Maximum number of pages of a report in LBI  1116  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 1116
by  RoxanneSJump to last post
03/07/2011 11:53 AM
3 Replies and 965 Views Users and Access Ids Cascading Issue with dashboards, modules and links  965  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 965
by  Ruma MalhotraJump to last post
03/03/2011 4:10 PM
2 Replies and 2164 Views ERD Files - LBI Reporting Services  2164  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 2164
by  Greg MoellerJump to last post
03/03/2011 4:08 PM
5 Replies and 2033 Views Custom Crystal Reports for LBI that use Commands(sql)  2033  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 2033
by  gsusnmeJump to last post
03/03/2011 4:02 PM
8 Replies and 5433 Views LBI/BPW implementation?  5433  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 5433
by  ErikaSJump to last post
03/03/2011 1:32 PM
4 Replies and 2359 Views Lawson back Office reports in Excel ?  2359  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 2359
by  George GrahamJump to last post
03/03/2011 9:31 AM
2 Replies and 1275 Views Publish Backoffice Reports as CSV drillable  1275  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 1275
by  Ruma MalhotraJump to last post
03/03/2011 9:03 AM
1 Replies and 1208 Views Setting a parameter based off User Roles.  1208  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 1208
by  Matthew NyeJump to last post
03/02/2011 9:33 AM
6 Replies and 2038 Views LBI Alternatives  2038  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 2038
by  Lance KelleyJump to last post
03/01/2011 4:17 PM
7 Replies and 1686 Views Using a Custom Crystal Report with my data  1686  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 1686
by  ErikaSJump to last post
02/28/2011 10:37 AM
19 Replies and 1851 Views Bursting of Notifications  1851  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 1851
by  George GrahamJump to last post
02/23/2011 7:05 AM
0 Replies and 1253 Views Crystal Report Filtering  1253  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 1253
02/07/2011 8:34 PM
3 Replies and 2114 Views MA236 criteria.  2114  3 Started by  T.Welsh Hello all, I am attempting to write an enhanced version of MA236 in Crystal XI. I aquired code on MA236 using 'bldsh' command but the exact criteria is still unclear to me. I can get within a few records of a perfect match to MA236, but I always end up a few records short and, in addition, get a few that are not in MA236. Has anyone attempted this in Crystal before If so, or even if not, does anyone have a clear set of criteria for MA236 Any help would be GREATLY appreciated. Thank...
3 2114
by  David WilliamsJump to last post
02/07/2011 5:33 AM
1 Replies and 1268 Views Added memory does not show up in reporting service  1268  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 1268
by  John HenleyJump to last post
02/02/2011 2:08 PM
1 Replies and 2037 Views Crystal 2008 export more than 65k rows to Excel 2007  2037  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 2037
by  Shane JonesJump to last post
02/02/2011 10:42 AM
1 Replies and 968 Views Sending large Excel attachments on LBI  968  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 968
by  Matthew NyeJump to last post
01/30/2011 1:36 PM
9 Replies and 4560 Views User Role Based Crystal Reports in LBI  4560  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 4560
by  ChrisSJump to last post
01/22/2011 8:04 PM
9 Replies and 1447 Views Auto-import of rights  1447  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 1447
by  Greg MoellerJump to last post
01/21/2011 4:09 PM
4 Replies and 1174 Views 2008 Server (for LBI)  1174  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 1174
by  Greg MoellerJump to last post
01/21/2011 1:17 PM
5 Replies and 2115 Views Override DSSO log-ins?  2115  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 2115
by  Matthew NyeJump to last post
01/20/2011 8:53 PM
2 Replies and 923 Views Reporting Service for 3rd party database  923  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 923
by  mark.cookJump to last post
01/20/2011 7:10 AM
2 Replies and 3196 Views LBI Dashboard  3196  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 3196
by  DonnaJump to last post
01/17/2011 6:50 PM
11 Replies and 5623 Views Crystal 2008  5623  11 Started by  Deleted User Has anyone got Crystal 2008 and the Lawson OLEDB to work together&160;
11 5623
by  DonnaJump to last post
01/14/2011 6:51 PM
5 Replies and 1474 Views Why is LBI Bursting empty Crystal Reports  1474  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 1474
by  JeanneSJump to last post
01/10/2011 4:24 PM
0 Replies and 1034 Views Convert apdistrib_date to fiscal year and period  1034  0 Started by  Deleted User Any Gurus with a handy Crystal formula to convert an apdistrib_date to fiscal year and period 
0 1034
01/06/2011 12:18 PM
6 Replies and 2321 Views Crystal GLAMOUNTS and GLTRANS  2321  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 2321
by  John HenleyJump to last post
01/03/2011 3:24 PM
5 Replies and 1188 Views Crystal Report issues  1188  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 1188
by  JonAJump to last post
12/28/2010 9:40 AM
1 Replies and 2272 Views Cascading Parameters do not return all values  2272  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 2272
by  S EckersonJump to last post
12/15/2010 3:47 PM
3 Replies and 1421 Views Crystal and LBI Drill Around  1421  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 1421
by  Greg MoellerJump to last post
12/15/2010 1:15 PM
5 Replies and 2308 Views Calculating a Time in Crystal Reports  2308  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 2308
by  JeanneSJump to last post
12/07/2010 1:55 PM
0 Replies and 1097 Views Dept Analysis Reporting  1097  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 1097
12/06/2010 11:28 AM
1 Replies and 1347 Views Figuring out table joins  1347  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 1347
by  Ruma MalhotraJump to last post
11/29/2010 3:01 PM
0 Replies and 1379 Views Missing Data in Burst Crystal Report on Multi-RAS server.  1379  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 1379
11/24/2010 1:23 PM
3 Replies and 955 Views OS support LBI  955  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 955
by  Chris MartinJump to last post
11/24/2010 12:47 PM
3 Replies and 1686 Views ClassDefNotFoundError  1686  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 1686
by  Greg MoellerJump to last post
11/18/2010 10:05 AM
3 Replies and 2309 Views LBI, Crystal & subreport  2309  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 2309
by  RoxanneSJump to last post
11/17/2010 3:49 PM
3 Replies and 2486 Views There are not any Rights on File for the requested User. (LBI bursting)  2486  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 2486
by  QuantitalystJump to last post
11/16/2010 8:37 AM
7 Replies and 5357 Views Security Reports In Lawson  5357  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 5357
by  Adam GoldsteinJump to last post
11/11/2010 3:10 PM
0 Replies and 1236 Views CR REPORT IN LBI DOES NOT STOP PROCESSING  1236  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 1236
11/11/2010 11:14 AM
0 Replies and 993 Views LBI CRASHES  993  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 993
11/11/2010 8:09 AM
2 Replies and 1376 Views Figuring out fields that join tables  1376  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 1376
by  mark.cookJump to last post
11/08/2010 7:07 AM
4 Replies and 1251 Views Scheduled report with no data.. prevent from emailing?  1251  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 1251
by  vishcomJump to last post
11/03/2010 7:19 PM
9 Replies and 1473 Views WAS 7 and LBI  1473  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 1473
by  Jimmy ChiuJump to last post
10/25/2010 10:30 AM
8 Replies and 2876 Views LBI with Crystal Reports 2008  2876  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 2876
by  CincyJump to last post
10/22/2010 8:54 AM
2 Replies and 1312 Views security hole in LBI  1312  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 1312
by  Matthew NyeJump to last post
10/21/2010 4:41 PM
11 Replies and 1624 Views Using RW as my Data Source in Crystal  1624  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 1624
by  KatfraJump to last post
10/18/2010 7:58 AM
1 Replies and 1190 Views Using ProcessFlow to publish LBI (RS) Reports  1190  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 1190
by  David WilliamsJump to last post
10/12/2010 4:28 PM
1 Replies and 1061 Views Date Parameter Formula?  1061  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 1061
by  CharJump to last post
10/12/2010 10:03 AM
3 Replies and 1935 Views LBI Security Groups VS Custom Groups  1935  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 1935
by  Ruma MalhotraJump to last post
10/08/2010 10:27 AM
5 Replies and 1268 Views Crystal 2008 server & designer  1268  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 1268
by  Greg MoellerJump to last post
10/08/2010 9:58 AM
2 Replies and 1291 Views LBI and No Icons  1291  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 1291
by  KatfraJump to last post
10/06/2010 12:40 PM
5 Replies and 1702 Views Leveraging RAS without loggin in to lbi  1702  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 1702
by  mjcindcJump to last post
10/04/2010 2:30 PM
0 Replies and 1374 Views How does one copy LBI prod to LBI test?  1374  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 1374
10/01/2010 9:54 AM
2 Replies and 2282 Views Crystal Report hyperlink- GL90  2282  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 2282
by  Carl GiffordJump to last post
09/30/2010 9:58 AM
2 Replies and 960 Views Version of PDF Created  960  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 960
by  JLJump to last post
09/30/2010 8:44 AM
9 Replies and 1805 Views Display the user ID iin report headings  1805  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 1805
by  DonnaJump to last post
09/29/2010 10:51 AM
5 Replies and 1488 Views Excel file as a datasource for Crystal in LBI  1488  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 1488
by  Deleted UserJump to last post
09/29/2010 7:48 AM
2 Replies and 10559 Views IA10 values not visible in scorecard  10559  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 10559
by  Xin LiJump to last post
09/28/2010 4:56 PM
4 Replies and 2095 Views Windows 7, Crystal 2008 and Oracle 10g  2095  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 2095
by  Ruma MalhotraJump to last post
09/28/2010 2:21 PM
5 Replies and 4611 Views hyperlink in crystal report  4611  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 4611
by  amynelsonJump to last post
09/28/2010 12:59 PM
1 Replies and 1295 Views Data source override in LBI  1295  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 1295
by  lizJump to last post
09/27/2010 4:17 PM
1 Replies and 1639 Views ACTRANS and IC Transactions  1639  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 1639
by  John HenleyJump to last post
09/24/2010 7:17 PM
0 Replies and 1096 Views Specified sort order in bar chart  1096  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 1096
09/24/2010 10:45 AM
1 Replies and 2453 Views Refresh Button On Crystal Report Viewer in RAS XI  2453  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 2453
by  Matthew NyeJump to last post
09/22/2010 5:17 PM
15 Replies and 6533 Views OLE DB substitute?  6533  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 6533
by  Russell SpreemanJump to last post
09/22/2010 1:59 PM
1 Replies and 1151 Views PATCOM report to LBI  1151  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 1151
by  Chris MartinJump to last post
09/16/2010 3:42 PM
2 Replies and 955 Views Database Overrride Issue in 11g  955  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 955
by  Ruma MalhotraJump to last post
09/15/2010 4:00 PM
10 Replies and 1386 Views Creation of New Role In RS  1386  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 1386
by  Ruma MalhotraJump to last post
09/14/2010 4:14 PM
2 Replies and 1139 Views Creation of link form one report to other report in LBI  1139  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 1139
by  mikePJump to last post
09/14/2010 9:57 AM
3 Replies and 2537 Views crystal report viewer  2537  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 2537
by  Jimmy ChiuJump to last post
09/13/2010 10:19 AM
2 Replies and 1334 Views Oracle Stored Procedure Missing  1334  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 1334
by  David VJump to last post
09/08/2010 8:47 AM
8 Replies and 3815 Views HR Dashboard  3815  8 Started by  David Williams Can anyone give me examples of items to place on a Dashboard for Human Resources Thanks
8 3815
by  M.N.ReddyJump to last post
09/01/2010 11:29 PM
2 Replies and 2588 Views LBI Crystal Reports Bursting  2588  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 2588
by  Carl.SeayJump to last post
08/30/2010 1:00 PM
4 Replies and 1456 Views LBI 9.0.4 - Framework Services security  1456  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 1456
by  Ruma MalhotraJump to last post
08/30/2010 12:12 PM
2 Replies and 1247 Views Report Parameters on Historical Instance  1247  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 1247
by  HeatherNelsonJump to last post
08/26/2010 4:11 PM
3 Replies and 1265 Views RW100 reports for previous period  1265  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 1265
by  Ruma MalhotraJump to last post
08/25/2010 2:53 PM
10 Replies and 4374 Views How to keep report format in PDF  4374  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 4374
by  RoxanneSJump to last post
08/23/2010 2:50 PM
0 Replies and 1456 Views Formula based on accrual rules/calculations  1456  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 1456
08/20/2010 11:59 AM
8 Replies and 1432 Views Query based on date  1432  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 1432
by  JonAJump to last post
08/19/2010 11:32 AM
0 Replies and 1185 Views Crystal 11/Pivot Tables and LBI  1185  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 1185
08/19/2010 11:05 AM
3 Replies and 1303 Views Connection from SN to MS Access?  1303  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 1303
by  Greg MoellerJump to last post
08/11/2010 2:35 PM
4 Replies and 1320 Views Application Links withing smart notifications.  1320  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 1320
by  Ruma MalhotraJump to last post
08/11/2010 10:51 AM
0 Replies and 1307 Views Occasional corrupt pdf attachments in email  1307  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 1307
08/06/2010 4:13 PM
1 Replies and 1078 Views Direct IOS Service for Single Sign-on  1078  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 1078
by  Matthew NyeJump to last post
08/05/2010 2:16 PM
0 Replies and 964 Views Reporting From ML  964  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 964
08/04/2010 10:07 AM
1 Replies and 4065 Views Need OLE DB Connector for Lawson OLE DB Object Services - should I reinstall LBI?  4065  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 4065
by  Chris MartinJump to last post
07/30/2010 4:27 PM
7 Replies and 2856 Views OLE DB date filter  2856  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 2856
by  John HenleyJump to last post
07/29/2010 1:43 PM
3 Replies and 1341 Views Finance Dashboard  1341  3 Started by  Joe O'Toole Can anyone provide some examples of items they have on their Finance Dashboard in LBI Thanks.
3 1341
by  Ruma MalhotraJump to last post
07/29/2010 1:31 PM
2 Replies and 1407 Views Crystal Report utilizing Account Attribute Lists  1407  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 1407
by  JeanneSJump to last post
07/28/2010 1:59 PM
1 Replies and 1391 Views Comment Code  1391  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 1391
by  John HenleyJump to last post
07/23/2010 1:40 PM
4 Replies and 27501 Views Like condition in Crystal Reports  27501  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 27501
by  FireGeek21Jump to last post
07/22/2010 2:53 PM
3 Replies and 1257 Views LBi Report Parameters don't stay set after upgrade  1257  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 1257
by  Matthew NyeJump to last post
07/21/2010 3:25 PM
4 Replies and 2309 Views add report to lawson--You do not have access to view the latest instance of this report.  2309  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 2309
by  sharonmtJump to last post
07/20/2010 10:24 AM
3 Replies and 1520 Views Time in a position  1520  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 1520
by  Ruma MalhotraJump to last post
07/19/2010 11:52 AM
6 Replies and 3486 Views Data File Text equivalent for PLM tables?  3486  6 Started by  Chris Martin Is anybody aware of Data File Text-like documentation for PLM tables
6 3486
by  Chris MartinJump to last post
07/16/2010 11:39 AM
6 Replies and 1668 Views LBI as an enterprise solution  1668  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 1668
by  Greg MoellerJump to last post
07/15/2010 3:21 PM
13 Replies and 1978 Views Using Smart Notifications To Query LDAP  1978  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 1978
by  Ruma MalhotraJump to last post
07/15/2010 10:18 AM
6 Replies and 1585 Views Looking for the SQL behind a Lawson report  1585  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 1585
by  TomwiseJump to last post
07/15/2010 6:07 AM
3 Replies and 2571 Views error  2571  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 2571
by  Matthew NyeJump to last post
07/08/2010 1:31 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 5 of 9 << < 34567 > >>


RSS Feed Available