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:
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 4 of 9 << < 23456 > >>
 Last Post
10 Replies and 2243 Views LBI/crystal issue  2243  10 Started by  tstanley I keep getting the following message ran running a crystal report from LBI. Can anyone tell me how to resolve this error. Thank you. Error message: SystemErr R The table 'v' could not be found.
10 2243
by  Matthew NyeJump to last post
05/24/2012 7:05 AM
5 Replies and 4520 Views Locating DB Tables/Fields  4520  5 Started by  dukeslater Somewhat new to Lawson, and so far I've been able to find all the fields needed for reporting (Crystal - native connection to Oracle). But now I'm having some trouble locating these two fields: IC12 - Expense account IC12 - Purchase From Location TIA for any help you can provide, specific to this problem or for locating db fields in general.
5 4520
by  dukeslaterJump to last post
05/17/2012 3:18 PM
3 Replies and 1793 Views Developing a rolling 12 month P&L in RW  1793  3 Started by  Whitney Johnson Has anyone developed or can you tell me if I can create in RW a rolling 12 month P&L for finance only showing the Actual amount column for each month The report would need to run for the current month, but then show the previous actual amounts for the other 11 months. Thanks, Whitney
3 1793
by  Whitney JohnsonJump to last post
05/15/2012 2:23 PM
8 Replies and 4378 Views Lawson printing  4378  8 Started by  JimMNH For the time being we have asked users to open LBI reports as PDF and then print them. We would like to setup Lawson printing of these reports but this requires the setup and maintenance of printers, drivers, and user access to printers on the server itself. Since we have a hosted Lawson environment this is not trivial. I was wondering what sorts of solutions administrators in this community have utilized for printing of LBI reports that offers the easist setup/access for their user base
8 4378
by  Ruma MalhotraJump to last post
05/11/2012 11:32 AM
3 Replies and 1874 Views Crystal Reports broken after 9.0.1 upgrade  1874  3 Started by  JonA We upgraded from to at the end of March and since then I've noticed several of my Crystal reports are not pulling the same data as they were before. For instance, I have a Contract Spend report that pulls from PURCHORDER, POLINE, MMDIST and MAINVDTL. I only want supply expense data so I'm filtering the data so the report only shows PO line info for certain accounts. The problem is that no inventory lines are in the report now. I think it has something to do with the fact that...
3 1874
by  JonAJump to last post
05/07/2012 12:57 PM
12 Replies and 3339 Views LBI login and dashboard loading getting slower all the time...  3339  12 Started by  mjcindc I know this is a terrible description of my problem, but I'm a database guy not an engineer.&160; I don't really know our environment all that well.&160; I am, however, responsible for LBI&160;reports and our LBI&160;site is getting slower by the day.&160; The app server and db server are not showing any extradinary resource usage and I'm really not sure what suggestions I can make to our engineer.&160; He's a bit less concerned than I am.&160; It can take 30-40 seconds between clicking t...
12 3339
by  Chris MartinJump to last post
05/04/2012 7:36 AM
1 Replies and 1231 Views A link to change parameters for all reports on a tab?  1231  1 Started by  MCordero I have a dashboard tab with 5 different reports, all with the same parameter, Location. I heard it was possible to have a single link that updates all reports in the tab with a new location instead of having to fill out the parameter in each report.separately. Has anyone done this that can point me in the right direction on how to accomplish this Also, what about a list of links in one module that could change the report that is viewed in a second module
1 1231
by  Matthew NyeJump to last post
05/02/2012 3:17 PM
10 Replies and 1630 Views Schedule report users *Share* ??  1630  10 Started by  Greg Moeller Does anyone have a report of the report users that are attached to the schedules that they would be willing to share I'm being asked to develop one, and I really don't have the time. I've got one that has the main report users, (and I'd be willing to share that) but not one that ties the report to the schedule to the report users on the schedule. Anyone Thanks much, -Greg
10 1630
by  Greg MoellerJump to last post
05/02/2012 2:52 PM
1 Replies and 1531 Views LBI text datasource question  1531  1 Started by  thanef I have a Crystal report that uses a text data source housed on my LBI server. It runs successfully in Crystal on my LBI server but I can not create the correct data source in LBI Report Services. Has anyone done this There is not a text type data source to choose from in LBI. Thanks.
1 1531
by  Greg MoellerJump to last post
04/30/2012 8:31 PM
15 Replies and 4249 Views Setting LBI timeout params  4249  15 Started by  jeff-lbi I have seen the postings on modifying the LBI timeout params for session and portal, etc However, I have yet to discover where this is done In the LBI app itself or a table value or on the hosting server, etc
15 4249
by  Greg MoellerJump to last post
04/27/2012 11:16 AM
7 Replies and 3188 Views Export a scheduled LBI report to excel DATA ONLY format  3188  7 Started by  jeff-lbi There are only options for CSV, xls, pdf, etc. I do not see an option for DATA ONLY excel. How can this be accomplished on the scheduled LBI reports (It IS an option on the on demand report configurations, but not scheduled. Why And is there a work around
7 3188
by  jeff-lbiJump to last post
04/26/2012 12:58 PM
5 Replies and 1586 Views Scheduled report no longer runs after new report user added  1586  5 Started by  jeff-lbi Has anyone encountered this I assume we are missing some other change that must be done after a new Report user is added to a Scheduled delivery for a report. Here is the scenario : (Note that any user we're adding in this scenario DOES have an email device set up, etc, etc) 1) Set up a schedule for a report, set the effective start date, etc, etc and a couple of users. It runs fine, no problems, all the users get their email. 2) The next day we add 1 new user to the schedule (wh...
5 1586
by  jeff-lbiJump to last post
04/26/2012 12:26 PM
1 Replies and 1419 Views Login to LBI Using Domain Account  1419  1 Started by  Layne We are using a domain account called LBICrystalReports to attempt to login a LBI Crystal Report. Going into MY REPORTS and editing the Data Settings \ Default User ID, we add the account using the following format for the Default User ID: GCSD\lbicrystalreports. GCSD is our domain. It will not work and the SQL log error shows that the report is attemping to login using SQL Server Authentificaiton even though the account is a domain account. The permission in SQL Server is sufficient for th...
1 1419
by  Matthew NyeJump to last post
04/11/2012 3:19 PM
6 Replies and 1774 Views Dashboard Tabs - making multiple rows  1774  6 Started by  dcaiani Last year at CUE I saw a customer presentation (I wish I could remember who it was) and they had more dashboard tabs than would fit in a single row. They were able to make multiple rows of dashboard tabs rather than have to click on the 'additional tabs' arrow or use the drop down to view the additional dashboard. Does anyone know how to do this
6 1774
by  Xin LiJump to last post
04/02/2012 3:36 PM
6 Replies and 1734 Views Report Tooltip in underlying data table?  1734  6 Started by  David Levine Hello, The report Tooltip - the report description that appears as you hover your mouse cursor over the report name is derived from the 'Description' text box in the 'Main' tab, when selecting 'Edit...' from the report. Does anyone know where this description can be found in the underlying table structure By the way, I've determined that it's NOT rsuserprd.ers_reports.description - this is the report description derived from Tools-->Reporting Services Report Administration-->...
6 1734
by  Chris MartinJump to last post
03/30/2012 11:56 AM
1 Replies and 1822 Views LBI bursting rights  1822  1 Started by  imty Hello Group, We have a clinic user group with bursting rights in LBI. Some of the financial reports are currently being burst based on the user's assigned to the clinic user group. We have created a Crystal payroll report and would like to create a payroll user group. Right now we have say center 1001001 that has two users attached to it. Now for payroll only one of the user's would have access to the report. If we attach the payroll report to the payroll user group would that control or over...
1 1822
by  Matthew NyeJump to last post
03/22/2012 10:27 AM
2 Replies and 2517 Views HRHISTORY table compare date rows  2517  2 Started by  Sarah How do I use the HRHISTORY table to look at the most recent (fld nbr 51)ADJ_HIRE_DT - (fld nbr 27)LAST TERM DT and if it's less than 365 days take the (fld nbr 26)PREVIOUS SENIORITY DT and add those days to the PREV SENIORITY DT to identify what the employees TRUE SENIORITY DT should be. Example: Employee is rehired with an adj_hire_dt = 02/19/2012. Their previous term date = 02/22/2011 so 02/19/2012-02/22/2011=362 days Their previous seniority date = 03/09/2001362=03/06/2002. I've been...
2 2517
by  SarahJump to last post
03/19/2012 2:20 PM
1 Replies and 1331 Views REPORT server.  1331  1 Started by  MARCO3535 Two of the our crystal users opened up standard crystal reports as they have run (as report refresh) many times in the past, Usually, it will open up to the proper environment, (oldproduction1) and prompt them for a password. This time, however, when they refresh for current data, instead of being prompted for a login in they are being asked to chose what server the report should point to. So they have to point to the server they want. This has occurred for each report they...
1 1331
by  Matthew NyeJump to last post
03/19/2012 1:07 PM
17 Replies and 3187 Views LBI Connection to AS400 Server failure  3187  17 Started by  imty :confused:Hello All, I have a crystal report that I created where it pulls data from the AS400 system via an ODBC driver. The report in Crystal works fine. I have published this report to LBI and in the DATA SETINGS i used INFINIUM as the data source and the following user id and password which works from Cyrstal. Infinium User Profile for ODBC connect. User Profile: LAWPAY Password: PASSLAW Library (Directory) USLAWSON Table (File) ...
17 3187
by  imtyJump to last post
03/15/2012 7:02 PM
4 Replies and 1292 Views Updated to on Thursday in PROD  1292  4 Started by  Greg Moeller Updated on Thursday and now gettting repetitive errors in the log about ReportEngine not compatible with CrystalEngine. Lawson has a JT opened for it, JT-293938, but we are wondering what we can do in the meantime. Can I downgrade LBI by applying a 'Update' Hesitant to upgrade to v because of all of the zeros. Error involves the scheduling and emailing of reports.. coming out corrupt, or prompting for an Oracle database id/password which MANY users do not have. Any though...
4 1292
by  ElenaJump to last post
03/01/2012 11:21 AM
34 Replies and 9072 Views MM280  9072  34 Started by  Chris Martin Has anybody had any success reverse engineering MM280 (ie using sql/crystal)
34 9072
by  SPJump to last post
02/24/2012 11:20 AM
4 Replies and 2986 Views LBI Crystal Reports behavior with Adobe  2986  4 Started by  MHRoy We have recently installed LBI. We have been able to publish 'home-grown' crystal reports and they run fine. When selecting print in the Crystal Reports 2008 viewer a 'Print to PDF' box appears with a Page Range section and information that the viewer must export to PDF to print. If we click on the Export button a File Download box appears. Choosing Open will bring up the local PCs version of Adobe and one can either print or export. Is this the correct behavior for LBI/Crystal Reports ...
4 2986
by  MHRoyJump to last post
02/16/2012 1:32 PM
1 Replies and 2200 Views What's New in LBI 10 document published on  2200  1 Started by  Ruma Malhotra I just found the what's now for LBI 10 document present on Looks like all the auditing related to reporing services and smart notifications have been added to this version. This will be a huge plus for all customers wanting to find out security,render times etc on LBI for a long time.
1 2200
by  mark.cookJump to last post
02/16/2012 11:22 AM
2 Replies and 2754 Views Crystal/Xcelsius and LBI Bursting  2754  2 Started by  Dave Curtis We are currently working on rolling out LBI for our leadership team. One of the things I would like to do is utilize the functionality of Crystal Reports and Xcelsius to develop some interactive charts of employee reviews, certifications, turnover etc. I am not having very good luck with it at this point and before I spend money and time trying to learn more about Xcelsius I wanted to ask the group here if anyone has been succesful at publishing a Crystal Report with an embeded Xcelsius .S...
2 2754
by  Dave CurtisJump to last post
02/09/2012 10:32 AM
3 Replies and 2125 Views Max export to excel ?  2125  3 Started by  jeff-lbi I recently ran a report where the result set was close to 200,000. I know this would require excel to have 4 sheets. Instead of finishing it prompted for a login information and asked for a refreshed data set Does LBI start to have a problem exporting to excel after so many records
3 2125
by  Matthew NyeJump to last post
02/08/2012 3:10 PM
0 Replies and 1152 Views Is there a way to get the user_id name to print on a Crystal rpt?  1152  0 Started by  Deleted User I'm looking to create a report that would show the date and name of the user who added or changed PA59 records within a 24hr window. Is there any way to use the User_ID from the PAGRDI file to get the employees name who add/changed the records
0 1152
02/08/2012 10:50 AM
5 Replies and 2758 Views Open Crystal Report Hyperlink using updateModule in LBI  2758  5 Started by  Daksha Desai I have a Crystal Report open in a module on the dashboard. It has a hyperlink which opens in a new window but I want it to open in the same module. I tried adding updateModule to the link but a url appears before the updateModule and it does not work. Can anyone help please
5 2758
by  Matthew NyeJump to last post
02/07/2012 3:11 PM
4 Replies and 2457 Views Portal Field Descriptions  2457  4 Started by  Layne In the Portal on say Screen HR11.1, there is a field desciption called 'Social Number.' Does anyone know where this field description can be found in the GEN database. I was looking at Docfld and DocScrFld, but they do not seem to contain of them.
4 2457
by  Jim Van ZummerenJump to last post
02/01/2012 8:03 AM
2 Replies and 2118 Views GEN Database Programs and Screens  2118  2 Started by  Layne I am running the following query on GEN. I wanted to see what fields are being used by a certain Program and Screen. SELECT * FROM dbo.PGMFLD WHERE PROGRAMCODE = 'HR11' AND SCRNBR = 1 AND PRODUCTLINE = 'LAWPROD' What is the prefix field used for. Is there a list of the defintions of these fields Let's say I was in the Lawson Portal on Screen HR11.1. I want to know what tables and fields that this form uses, so I can write a report. I am not worried about how to connect back to o...
2 2118
by  Greg MoellerJump to last post
01/31/2012 8:44 AM
3 Replies and 3213 Views Link to Webinar?  3213  3 Started by  Greg Moeller Does anyone have the link to the LBI version 10 Webinar handy The Webinar started 15 minutes ago, and I can't locate the link.
3 3213
by  SPJump to last post
01/27/2012 3:40 PM
4 Replies and 1592 Views No recipients to whom to send the content  1592  4 Started by  Greg Moeller In my SystemOut.log file for LBI, I get a failed delivery 'No recipients to whom to send the content.' message when there is no delivery device set up for a particular report user. Is there a way to associate to which report this user belongs from the rather lengthy error in the log file For example: &91;11/11/11 8:30:21:879 CST&93; 0000005a SystemOut O Email Delivery Status: <delivery-response version='1.0' status='500'><message code='303' description='No recipients to wh...
4 1592
by  Greg MoellerJump to last post
01/27/2012 2:33 PM
3 Replies and 2533 Views Crystal Slow Loading in LBI  2533  3 Started by  jeff-lbi We've been using LBI for almost a year. We have crystal 2008, and we develop front ends using .NET. Never had any problems. However, suddenly with a few new employees we have seen .rpt files take MUCH longer to upload during the re-publish process......and then furthermore take MUCH longer to load the .aspx front end called from the report Events in LBI. I have already ruled out EVERYTHING, and isolated the problem to the .rpt files themselves....but there has to be a LBI component here, b...
3 2533
by  MHRoyJump to last post
01/25/2012 12:25 PM
7 Replies and 4735 Views Crystal Report Viewer Erroring out in 1 IE User Workstation  4735  7 Started by  jeff-lbi First I will preface by saying I've already uninstalled and re-installed Internet Explorer 8 on this machine. It is the only machine we have this issue with. I have not seen this with any of our other users. Basically when a crystal report is run from the LBI interface the window opens but IE bombs out with errors such as : (Related to crv.js) Message: 'Image' is undefined Line: 271 Char: 13 Code: 0 (Related to crv.js) Message: Object doesn't support this property or method Lin...
7 4735
by  jeff-lbiJump to last post
01/25/2012 11:25 AM
1 Replies and 1942 Views Printing Lawson Report Number on Report  1942  1 Started by  Layne I'd like to print the Lawson Assigned Report Number on the report. In Crystal, I tried using the Special Field called File Path and Name, but apparently Lawson copies the rusults report over to a temp folder on the local PC running the report. There is no report number on the file name at this point. Any ideas on how I can do this without running another query to the GEN database.
1 1942
by  John HenleyJump to last post
01/25/2012 9:29 AM
13 Replies and 3586 Views Fields restricted? Excel pull of Lawson data through OLEDB  3586  13 Started by  BertNeu... So, built a DME using Lawson Query builder (LQB), (Employee table, fields = Employee, Pay-rate); execute gives expected fields. Pasted the LQB DME text into the Excel Data -other sources routine results: only the employee field was returned. Hmmm, went back to LQB, and specified the entire employee table, copied the DME, and in Excel all fields came back except anything to do with pay. Same thing when pulling from Timerecord table - only non-pay fileds returned to Excel, despite all fields sh...
13 3586
by  BertNeu...Jump to last post
01/11/2012 3:17 PM
6 Replies and 3254 Views Crystal Reports How to determine frequency of RUNS  3254  6 Started by  Layne Does anyone know the tables in the LawsonRS database that would tell me when the last time a report was run, how often its being run, and who is running it. I see a started and finished field in the ERS_REPORTSTATUS Database, but it does not appear to be correct based on reports I have run.
6 3254
by  LayneJump to last post
01/09/2012 3:19 PM
6 Replies and 2887 Views Oracle odbc drivers for RS ODBC on LBI 904 Win 2008 64bit  2887  6 Started by  Deleted User We are doing a fresh LBI 904 install on a Windows 2008 64bit server. We will need a Reporting Services ODBC data source for Crystal ODBC reports pointing to an Oracle 11g database (Lawson app server running on AIX 6.1 Oracle 11g). Anyone know what Oracle client we should run on the Win 2008 64 bit server; example Oracle 11g client for 32bit or 64bit
6 2887
by  RobbyJump to last post
12/19/2011 12:31 PM
2 Replies and 1932 Views Crystal and .csv table linking  1932  2 Started by  Katfra I've linked a .csv file as my table in crystal. I have a debit, credit, and difference colum in the file which shows in the crystal report, except where anything has a negative value. I've tried creating calculted fields to produce the credit balance in crystal, which worked in my credit column. However, if I create a formula Debit-Credit where my debit might be a zero balance, my result is blank in the difference column. Anyone have any ideas I've tried a running total as well with no luck...
2 1932
by  KatfraJump to last post
12/05/2011 2:40 PM
10 Replies and 2791 Views LBI report users  2791  10 Started by  Jan I haven't found this issue in this forum so I'll post it now. I apologize if this was addressed earlier and I missed it. As employees terminate or transfer, I need to determine if I need to adjust LBI report distributions. Which LBI tables do I need to access to see which reports (or smartnotes) an employee has been a recipient for I have quite a few reports built up, so doing this by hand is getting to be unworkable. thanks in advance for any help you can throw my way
10 2791
by  Greg MoellerJump to last post
11/15/2011 4:34 PM
8 Replies and 2205 Views FS page goes off line with Portal integration (efsrole.xml)  2205  8 Started by  Deleted User I have a single server LBI test system running on WebSphere 6.1.13 Win 2003 Sever SP2 and LBI902.  I integrated Portal a while back with dsso and a PortalRole efsrole.xml file.  My FS page goes off line sometimes when I log into my Portal Test system profile.  The page seems to stay up if I access FS outside of Portal using dsso security.  I'm working a case with Lawson but I thought I would post in the LBI forum to see if anyone else has encountered this behavior.  Ther...
8 2205
by  Massimo EmilioneJump to last post
11/15/2011 4:16 PM
4 Replies and 2577 Views LBI Synchronizing User and Groups  2577  4 Started by  Vito Amatulli Does any one know if it is possible to automate the Synchronize User and Roles fuinction from LBI&160; We re trying to automate adding of Lawson users to security and want to be able to sync the user to LBI.
4 2577
by  Massimo EmilioneJump to last post
10/08/2011 11:33 PM
11 Replies and 1957 Views Scheduled report to be emailed to a directory instead of an email device ?  1957  11 Started by  Ruma Malhotra I would like to find out whetherwe can email a report to a directory instead of an email device Can this be done in LBI We have a report that is scheduled manually every day to refresh. This report needs to be imported to a tool used for budgeting. Can I set a report to refresh on a schedule and then email the scheduled report to go to a directory instead of an email device
11 1957
by  Ben CoonfieldJump to last post
10/07/2011 2:23 PM
5 Replies and 1983 Views Scheduled LBI report to a constant server location  1983  5 Started by  BarbLR We would like to be able to have scheduled LBI reports go to a constant server location so that they can be picked up by a later scheduled process (a ProcessFlow). The LBI analyst tells me that when the report runs it is written to a unique folder for every date with a unique instance number. That will make it difficult for the Process Flow to FTP 'get' the reports. Has anyone found a way to write the report to the same location each time
5 1983
by  Greg MoellerJump to last post
10/07/2011 11:22 AM
5 Replies and 1662 Views Importing Rights with multiple users: Is is possible?  1662  5 Started by  ric9d I have successfullt imported a right file into LBI. However I wanted to assign a right to several users. Of course you could do this manually, however, Im trying to find out if anyone out there has uploaded an imports file with several users. Thanks and any ideas will be appreciated.
5 1662
by  Greg MoellerJump to last post
09/28/2011 3:49 PM
6 Replies and 3712 Views Occassional blank LBI report  3712  6 Started by  des123 We are having an annoying problem with running LBI reports. They will occasionally display blank output. The workaround is to clear out the temporary internet files, cookies, etc... in the IE web browser (Tools -> Options). I thought it might be due to not enough space allocated for temporoary internet files and cookies so I increasing the amount of allocated space to 1024 MB but this did not help. This happens on various reports so we know that it is not report-specific. One moment a ...
6 3712
by  des123Jump to last post
09/28/2011 3:47 PM
4 Replies and 2321 Views Not valid for List error message when trying to access LBI report list  2321  4 Started by  Louise I Help! This was working yesterday and stopped working today. Also yesterday another analyst and I were looking at setup screens but do not recall clicking or changing anything. There have been other Lawson issues and a company firewall change that went in. Also, the custom group that these employees are members of was strangely missing from all the reports that used to have it in the Users lists. I added it back and that did not resolve the problem. There's also an attribute called HR that wa...
4 2321
by  Louise IJump to last post
09/28/2011 3:40 PM
2 Replies and 1238 Views Only Crystal?  1238  2 Started by  mcarlson maybe a really dumb question....or maybe one that has been covered out here before....but here it is... Can SSRS (SQL Reporting Services) be used with LBI or is it required that you use Crystal Any success or failure stories using something other than Crystal Thanks!
2 1238
by  WRBJump to last post
09/27/2011 3:57 PM
11 Replies and 7020 Views Is there a way to execute a program from within Crystal Reports 2008?  7020  11 Started by  C Fritz Hello - I am trying to find out if its possiblet execute a Windows batch file from within Crystal Reports. Does Crystal reports have the capacity to make a system call to the OS and execute a command outside itself If it does can you please explain the syntax or point me to a source that enables this Thank you.
11 7020
by  C FritzJump to last post
09/23/2011 2:31 PM
3 Replies and 3266 Views The maximum report processing jobs limit configured by your system administrator has been reached.  3266  3 Started by  Xin Li We have a crystal bursting to hundreds of users every month. It worked before we upgraded to LBI and CRAS Now report bursting was crashed and user got pdf file unopenable. The error is 'The maximum report processing jobs limit configured by your system administrator has been reached.' It looks like LBI just overloaded CRAS server when brusting rendering report.Google the whole internet universe and change PrintJoblimit in registry, no luck so far. Any help appreciated.
3 3266
by  Greg MoellerJump to last post
09/16/2011 5:08 PM
3 Replies and 2754 Views LBI Email Delivery Scheduling  2754  3 Started by  jeff-lbi I have set up my email device in LBI, and perform a test delivery (we have also scheduled deliveries but have yet to get them) I have activated my email device as well. Which is through email, so why we don't get any other emails is confusing. When we do a test we get the following error: Unable to send content to host {0}. Simple and broad message, but just wondering if anyone had any insight Thx
3 2754
by  Ruma MalhotraJump to last post
09/15/2011 2:59 PM
1 Replies and 1176 Views Assigned role not stick with user in LBI  1176  1 Started by  Xin Li After we upgraded LBI to We found another crazy issue with LBI. In Lawson security we assigned four roles to a users. IF we go to manage users and roles it sometime show the user has four correct roles. After a while, two role disappeared from this users. Sync user and roles they may show up with four roles or only two roles. Anyone had such issue What are the solution
1 1176
by  Xin LiJump to last post
09/13/2011 2:03 PM
2 Replies and 2190 Views LBI timedout issue  2190  2 Started by  Xin Li We open LBI by click link in Lawson portal. However, we encounter page cannot display error everywhere in LBI after a period of time. We have to logout Portal and login back then reopen LBI. Even if portal prompt us to login again, it still have the same issue. This problem occured after we upgraded to LBI
2 2190
by  mark.cookJump to last post
09/09/2011 7:37 AM
6 Replies and 3512 Views LBI report field overlapping  3512  6 Started by  Xin Li We have a crystal report that has a longer field that is overlapping the field to its right. We shrank this field so that it will not overlap in crystal designer. However, when we publish the report to LBI, the report is displaying field overlapping. Anyone experienced this and any suggestiion
6 3512
by  Xin LiJump to last post
09/08/2011 10:20 AM
0 Replies and 1924 Views Budget Actual Reporting (K12)  1924  0 Started by  amynelson Has anyone had to create Crystal Reports to show Budget Actual for a K12 or similar customer This particular situation is that at Year End when the GL198 is run it shows all open PO's no longer as an commitment, but as an expense. So when they run budget analysis reports for period 12, prior fiscal year all Encumbrances and Commitments are zero and Expenses are increased and Budget remaining is reduced. The problem that I am finding is that when the GL198 is run, the commitment year and ...
0 1924
08/26/2011 10:09 AM
1 Replies and 1158 Views Solution Set for Reports - Report ID?  1158  1 Started by  George Graham How is anyone else handling this: Report is created on test LBI and validate by users. Report is attached to a dashboard - therefore the link in the dashboard has the ID of the report in the URL. The desire is to be able to make test and prod LBI identical - and utilize automated procedures to migrate stuff from test to prod. But when creating a solution set from test and then loading it on prod, when the report is loaded on prod it loads it as a new report with new ID. So for new reports ...
1 1158
by  Ruma MalhotraJump to last post
08/24/2011 11:26 AM
0 Replies and 2095 Views Reporting Services: Saved Parameters Option  2095  0 Started by  WRB Has anyone used the Reporting Services Option 'View with Saved Parameters' I am attempting to actually save a parameter but not having any luck. 1. I mark the option under Maintain Parameters 2. I run the report that has parameters 3. I complete the required parameters 4. I name the parameter set. 5. The report runs but when I go in the 'View with Saved Parameters' there is nothing there. Once I get the 'View with Saved Parameters' option to work how do I show it on the Dashbo...
0 2095
08/24/2011 10:13 AM
1 Replies and 1274 Views LBI Uploading Rights  1274  1 Started by  ric9d I had several RIGHTS uploaded to LBI. Then I scheduled bursted (crystal) report. However all users are getting a 'File is corrupted of damaged' error message. Interestingly, if I manually create a RIGHT and schedule the report, bursted and all that, it works! If anyone has any idea or has encountered this issue, please, please let me know. I have created a ticket for this with Lawson Global Support, however, sad to say, they are as CLUELESS as me!
1 1274
by  George GrahamJump to last post
08/23/2011 10:37 PM
0 Replies and 2052 Views Publishing a Crystal Report with a SubREport  2052  0 Started by  ric9d Can anybody tell me how to publish a Crystal report with a subreport in it If you could do it on a numbered step by step process then I would greatly appreciate it. Thanks.
0 2052
08/17/2011 8:42 AM
0 Replies and 1774 Views Options for saving Report output (file name) from LBI Dashboard  1774  0 Started by  Daksha Desai I have a link on a dashboard that creates a report in csv so that the user can save it. How can I set a file name with a type of txt for this Location (url) is: http://vmlbisrv.domain.corp:9080/ers/ersRequestHandler.jspCMD=VIEW&INSTANCEID=LATEST&OuterWrapper=true&NewReport=true&REPORTID=35&OutputType=csv
0 1774
08/16/2011 9:14 AM
4 Replies and 1750 Views Publishing ReportWriter Reports  1750  4 Started by  ric9d Is it possible to Publish reports written in report Writer I have been searching the web for a while and I havent a clue. If it is possible Can anybody tell me how to a step x step procedure will be most welcome. Thanks!
4 1750
by  Greg MoellerJump to last post
08/11/2011 8:23 AM
1 Replies and 1552 Views Bursting in LBI; user is noted as <device only user>  1552  1 Started by  ric9d I uploaded a bunch of users into LBI using import files. Some of them, those who has NEVER login to LBI (even if they were given access to it) would have their user id with '<device onlyuser>'. I bursted the report to 2 people, one who had accessed LBI before and the other never had. IT did not work, the former got his report but the latter didnt. Does anybody have any idea Do users HAVE TO HAVE lbi access to get an bursted/emailed report Thanks in advance.
1 1552
by  Greg MoellerJump to last post
08/10/2011 12:48 PM
3 Replies and 1608 Views Unable to export LBI report  1608  3 Started by  TBonney OK, this is a wierd one... I have a user who is attempting to export the output of a Crystal report run from an LBI dashboard. The report runs fine, but just won't export for her. Also, other users are able to successfully run and export the same report & save their results locally. However, when this particular user hits the export icon, the cursor simply displays this wierd little yellow icon that looks like some sort of sunburst with a squigley red outline. But, there is no text displa...
3 1608
by  mark.cookJump to last post
08/05/2011 1:11 PM
3 Replies and 1343 Views Search box in framework services?  1343  3 Started by  George Graham Anyone know how to remove the search box that shows up for LBI Since this is linked into portal both search boxes are showing up and confusing users. I'm sure I can dig and find it but thought I would see if anyone has already done the leg work. Thanks.
3 1343
by  Chris MartinJump to last post
08/01/2011 1:27 PM
4 Replies and 1891 Views Options for export?  1891  4 Started by  Greg Moeller Just asking a question (at least for now). Is there any option available to export an LBI report automatically to a file share  We'd like to keep a couple reports, and don't want to have the manual task of daily saving the emailed versions. Thanks for any suggestions, -Greg
4 1891
by  Greg MoellerJump to last post
07/12/2011 2:43 PM
6 Replies and 2605 Views RW100 copy to Crystal  2605  6 Started by  BShort I was just at CUE and heard that we can take the RW100 and have it copied into Crystal without rebuilding the report in Crystal after all the work was completed in RW100. How do I do accomplish this task Thank you.
6 2605
by  AmyVJump to last post
06/29/2011 2:19 PM
1 Replies and 1061 Views LBI 902 compatibility with Lawson S3 901  1061  1 Started by  Deleted User Greetings Gurus! Is anyone running LBI version 902 with S3 Lawson Apps 901  We are preparing for an apps upgrade from Apps 9msp6 to Apps 901.  Anyone have any input on the required changes for LBI  Your input as always is much appreciated! Joanna
1 1061
by  George GrahamJump to last post
06/22/2011 1:36 PM
1 Replies and 1340 Views Filter a Smart Notification on a Dashboard Tab  1340  1 Started by  MCordero I've created a  Smart Notification with the username field set as a parameter. I can manually add the parameters to the URL to filter it with http://.....&paramcount=1&param0=&91;username&93;  What are the steps I need to take to dynamically show the information on a dashboard to filter according to the user viewing it  If not with username, then employeeID or possibly a specific Security Group
1 1340
by  Matthew NyeJump to last post
06/22/2011 12:27 AM
6 Replies and 4130 Views Drill Around question  4130  6 Started by  George Graham I know in Crystal Reports I can create a hyperlink using drill.jsp. And I can use query builder to get the specific drill strings. However, is there a way to do a full drill around similar to what pulls up in portal I.E., when I'm on the Employee field in HR11 and select drill I the menu of all drill arounds. I've tried capturing the calls from within portal but those calls are simply generating the drill lists and I assume the servlet is then building the form displayed....
6 4130
by  Fernando LabradaJump to last post
06/14/2011 4:53 PM
2 Replies and 2688 Views QuickStep Crystal Reports - How to view data  2688  2 Started by  ErikaS Hello, For the life of me, I cannot successfully connect a Lawson QuickStep Crystal Report to my data source. Out of the box, the data source is set to I preview the data, it prompts for parameters (which I fill out) then it prompts for data source, username and password.  I fill in the data source credentials that I want to use and I get the following: 'Failure to retrieve data from the database. A failure occurred  during the generation of schema inf...
2 2688
by  Ruma MalhotraJump to last post
06/14/2011 4:38 PM
3 Replies and 2816 Views RW100 for Crystal Report  2816  3 Started by  wintergreen I'm trying to do a RW100 as a data source to Crystal Report for budget report. How do you define a RW report which includes all the account units Currently we have one RW report for one account unit in RW100.  So we have 50 RW100 reports for each account unit for its budget report.  Is it supposed to have all the account units in one RW when you want to use it as a data source for Cystal Report ( Each account units have the same account number for salaries, bene...
3 2816
by  wintergreenJump to last post
05/26/2011 9:29 AM
3 Replies and 1379 Views email bursting  1379  3 Started by  wintergreen I am able to burst smart note by process levels through email.  I created a list which mapping the pocess levels and users's email addresses. The question I have is if someone has multiple process levels,  he will receive multiple emails; each email is for each process level's data.  I wonder if there is a way to put all his process levels' data into one email only Any input will be much appreciated.  Thanks!
3 1379
by  Matthew NyeJump to last post
05/24/2011 2:51 AM
1 Replies and 1787 Views Other BI tools Compatible with LBI  1787  1 Started by  Ruma Malhotra I am just curious to find out if anybody is using other BI tools that are non lawson supplied especially the analytics suite and whether you were sucessful in deploying thes BI enabled graphs, grids etc to LBI. I am particluarly interested in finding out more about microstrategy and silver light. Would love to hear about your experiences with these tools not for only reporting but for analytics. Thanks in advance.
1 1787
by  Matthew NyeJump to last post
05/20/2011 12:57 AM
2 Replies and 1414 Views 3 Tools dashboards ?  1414  2 Started by  Greg Moeller Hi, All! Here's the issue:  The other day, I started seeing 2 Tools dashboards.  (I'm basically the guy that takes care of the technical stuff with LBI). I have a user here in IT that sees 3 Tools dashboards.  They are all identical (as far as I can tell). How do I differentiate between them to tell which is the 'real' tools dashboard and delete the other 2 Anyone ever had this happen to them Thanks in advance, -Greg
2 1414
by  Greg MoellerJump to last post
05/19/2011 12:04 PM
4 Replies and 2218 Views LBI security / users  2218  4 Started by  Chris - MIBH Created a new list with a couple filters and loaded to the module on the dashboard.  We are using Lawson security groups for access and bursting.  When user click on the link in the module they are converetde to my, or the list/report ownwers log in and security.  Anyone seen this before  We syncronized users but it did not fix the problem.  We are on Help
4 2218
by  Chris - MIBHJump to last post
05/18/2011 12:08 PM
8 Replies and 1413 Views Unable to view Framework Services System Adimin Tools with DSSO - Pls help  1413  8 Started by  Ganesh R Hi I've installed LBI, DSSO & have intergrated with existing LSF 9 Portal. However, after logging in, I noticed that the Framework Services System Admin Tool is missing. This happens when I login as Framework services (like http://hostname:9080/efs) as well as in Portal. However, if I change the authentication to File Authentication, this issue does not appear I see complete menu. Has anyone come across this type of error earlier Any input is appreciated. Tks.
8 1413
by  Ganesh RJump to last post
05/16/2011 11:42 AM
5 Replies and 1691 Views On Demand Crystal Reports in Reporting Services  1691  5 Started by  WRB We have several reports published in Reporting Services ( all of the reports are written in Crystal 2008 and have parameters.  When I request the report(in LBI) (on demand) it takes 30 seconds to return the parameter screen.  Does anyone have suggestions on how to speed this up  This is a new install so any fine tuning suggestions is much appreciated. Thanks
5 1691
by  WRBJump to last post
05/05/2011 5:27 PM
1 Replies and 1312 Views Array Summaries that will not Print  1312  1 Started by  Donna I have been working on an Employee Position Report and created an array for all the departments to roll up into the union and report summaries. The array is capturing all the departments and printing them individually but it will not print them all simultaneously in the format we need for the Union Group Summary. The issue is not documented on the Lawson forums. Some Crystal internet forums documented the issue as a Crystal 2008 issue. I employed their print suggestions but none of them work wit...
1 1312
by  DonnaJump to last post
05/02/2011 7:25 PM
6 Replies and 3525 Views LBI authentication against ADAM  3525  6 Started by  Anne-Marie hi, We try to setup LBI authentication against ADAM. We use advanced ldap/msad settings. Our ADAM contains groups and members for example G_LBIAdmins. After making the changes in the configurationAssistant, we restart IBM websphere.  The next step is to do an Authentication test in the InstallValidator. But we never pass this test. Always the same error : (security:3004) Login failed. The userid or password entered is not valid, or the specified user does not have access to thi...
6 3525
by  Anne-MarieJump to last post
04/29/2011 4:04 PM
0 Replies and 1653 Views Lawson Webinar today at 10:00 AM and 1:00 AM on LSO  1653  0 Started by  Ruma Malhotra Topic: Constructing Efficient Data Queries Using Lawson Add-Ins for Microsoft Office Host: Lawson Webinars Date and Time: Thursday, April 28, 2011 10:00 am, Central Daylight Time (Chicago, GMT-05:00) Event Number: 665 619 705 Event Password: This event does not require a password Registration ID: This event does not require an enrollment ID Topic: Work Smarter with Lawson Smart Office Host: Lawson Webinars Date and Time: Thursday, April 28, 2011 1:00 pm, Central Daylight ...
0 1653
04/28/2011 9:19 AM
5 Replies and 2812 Views On Demand Reports in Reporting Services  2812  5 Started by  ISO Dan Does anyone know how to run an on demand Crystal report in reporting services without scheduling it and retain its history We just want to be able to run the report and not have to go through the set up of scheduling it.
5 2812
by  Matthew NyeJump to last post
04/28/2011 12:50 AM
1 Replies and 1221 Views Add Parameter Values to Instance Name or Description  1221  1 Started by  ISO Dan Does anyone know how to add parameters to the instance name or description automatically  We want our cost center managers to be able to easily tell which period the report is run  (older periods sometimes need to be rerun and it sometimes get confusing) instead of them having to go into each report. I know you can edit the instance name but we have over 50 reports and it would be a pain to have to edit 50 instance names.  Is there a way to display the parameters or append to ...
1 1221
by  Matthew NyeJump to last post
04/27/2011 8:22 AM
6 Replies and 3154 Views Can you join PRDISTRIB to PRTIME?  3154  6 Started by  Gail Can you join the PRDISTRIB table to PRTIME I need to join the PRDISTRIB table to PRTIME so that I can get the hours from PRTIME. The reason I'm using PRDISTRIB is we have pr23 records therefore the distribution accounting unit is different in prdistrib then what is in prtime. I need to create a report that shows where the amount landed in GL and the associated hours (which do not write to gl). Thank you for your assistance in advance!
6 3154
by  Carolyn LeeJump to last post
04/26/2011 1:51 PM
0 Replies and 1269 Views Viewing a work file in LBI  1269  0 Started by  maryclare hi all - i am wondering if anyone has used webrpt.exe to display files in LBI  i have done this before to display a print manager file, but i would now like to be able to display a work file (csv format) in LBI.  i am unable to use webrpt.exe, since the file path does not exist in the USERRPT table.  is there another way to display a file from the server (unix server) through a link in portal or - maybe there is a way to 'register' the work file in the USERRPT table th...
0 1269
04/20/2011 11:01 AM
0 Replies and 2248 Views Suppress Crystal Viewer Error messages?  2248  0 Started by  George Graham Have a report link on a dashboard that provides users with only access to report instances - i.e., if no instance has been created it does not run on demand. This gets controlled with permissions properly. However, when users click this link - since they do not have data refresh permission - it gives them a 'somewhat' cryptic page stating: Message: This report doesn't have saved data, it can't be viewed, exported or printed without invoking a data...
0 2248
04/19/2011 10:19 PM
4 Replies and 1252 Views SmartNotes to open Crystal and jump to a page  1252  4 Started by  David Williams Can you set up a Crystal Report with links (in our case to an Activity value) and open the report to that point in the report If you can, can you open a Crystal Report from a URL link in SmartNotes If yes to both, can you pass the Activity number as a parameter in this SmartNote URL link so the Crystal Report opens and jumps to that Activity
4 1252
by  David WilliamsJump to last post
04/13/2011 2:30 AM
1 Replies and 1126 Views Displaying Reports on Dshaboards - CR2008 LBI9041  1126  1 Started by  Nick We upgraded LBI to a few weeks ago and just upgrade Crystal RAS to CR 2008 this morning.  One change we noticed is that CR 2008 now has tabs along the tops of the reports.  My guess is that any expanded groups will open in new tabs like they do in the Designer. This will be nice for those type of reports.  However, our problem is that there are a few reports that we have displayed directly in dashboard modules.  We hide the Group Tree and Toolbar so they just show ...
1 1126
by  George GrahamJump to last post
04/12/2011 10:09 AM
12 Replies and 2277 Views Automatically database connection  2277  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 2277
by  Matthew NyeJump to last post
04/11/2011 10:06 AM
2 Replies and 1017 Views Limit on the Number of rows to burst in smart notifications  1017  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 1017
by  Ruma MalhotraJump to last post
04/09/2011 10:58 AM
2 Replies and 1458 Views DME substitute- RW?  1458  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 1458
by  mikePJump to last post
04/08/2011 2:44 PM
1 Replies and 1131 Views Datasource for LTM?  1131  1 Started by  George Graham Anyone set up one of these yet within Reporting Services
1 1131
by  NabilJump to last post
04/08/2011 9:14 AM
23 Replies and 12217 Views LBI tables and/or data dictionary  12217  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 12217
by  Greg MoellerJump to last post
04/07/2011 12:01 PM
8 Replies and 1901 Views Automatic device import  1901  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 1901
by  mark.cookJump to last post
04/07/2011 9:47 AM
1 Replies and 1628 Views Here we go GURUS!! Automate on demand report scheduling  1628  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 1628
by  George GrahamJump to last post
04/05/2011 4:08 PM
0 Replies and 1016 Views Control characters in ers_reportdatasources  1016  0 Started by  Greg Dey While trying to troubleshoot a problem with publishing reports in 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 1016
04/01/2011 10:49 AM
4 Replies and 2207 Views LBI Security Groups  2207  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 2207
by  Ruma MalhotraJump to last post
03/28/2011 2:45 PM
7 Replies and 2949 Views LBI Security setup  2949  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 2949
by  mark.cookJump to last post
03/25/2011 12:31 PM
3 Replies and 1289 Views LBI -Still Learning  1289  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 1289
by  John HenleyJump to last post
03/25/2011 9:21 AM
2 Replies and 2836 Views Crystal Effective Date Reporting  2836  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 2836
by  NabilJump to last post
03/24/2011 2:30 PM
0 Replies and 1199 Views Function to print crystal report?  1199  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 1199
03/23/2011 1:49 PM
2 Replies and 1532 Views Mapping a crystal report that uses a sql command  1532  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 1532
by  Ruma MalhotraJump to last post
03/09/2011 4:42 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 4 of 9 << < 23456 > >>

RSS Feed Available