Forums
 Topics
 Replies
 Last Post
180 Topics and 623 Replies Smart Notification  180  623
RE: Formatting of Blank D...
by  thummel1
02/07/2018 11:03 AM
180 623
RE: Formatting of Blank D...
by  thummel1
02/07/2018 11:03 AM
Search this forum:
Search
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 4 of 9 << < 23456 > >>
Topics
 Replies
 Views
 Last Post
0 Replies and 972 Views Panelists wanted for a Focus Group on Performance Management and Continuous Feedback  972  0 Started by  sathiya Synergita is conducting a market research study among HR professionals on Performance Management and Continuous Feedback. The Focus group is scheduled on June 7th 2012, at 1.30 PM US Eastern Time. HR Professionals interested in participating as a panelist, please contact rsrsynergita.com
0 972
06/02/2012 3:45 AM
23 Replies and 4082 Views LBI Back Office Reports, publish more than 1 rpt from same job  4082  23 Started by  Elizabeth Ardito We only have the 'free' LBI product that replaced E-Broadcast from years ago. I have a new cobol program that produces 2 output files in the print manager (a .prt and the other file is called listing). Is it possible to publish the listing file I have all the necessary coding in the program to include the tags on both reports. I have had a case open with Lawson for the last 2 weeks and today they came back after they tried some 'canned' reports but determined they were not burstable tha...
23 4082
by  Elizabeth ArditoJump to last post
05/30/2012 11:26 AM
2 Replies and 1554 Views Specific AU's not showing in Crystal Reports  1554  2 Started by  Whitney Johnson I have two separate Crystal reports, report (A): is pulling AU’s by Attribute and report (B): is a P&L pulling revenue and expense accounts. For some strange reason I’m not able to get data for two specific accounting units to pull into these reports. Does anyone have an idea what may be causing this Could it be the setup of these AU's in Lawson All other AU data is being captured in the reports.
2 1554
by  Ruma MalhotraJump to last post
05/24/2012 4:14 PM
10 Replies and 2312 Views LBI/crystal issue  2312  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 com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: The table 'v' could not be found.
10 2312
by  Matthew NyeJump to last post
05/24/2012 7:05 AM
5 Replies and 4721 Views Locating DB Tables/Fields  4721  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 4721
by  dukeslaterJump to last post
05/17/2012 3:18 PM
3 Replies and 1856 Views Developing a rolling 12 month P&L in RW  1856  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 1856
by  Whitney JohnsonJump to last post
05/15/2012 2:23 PM
8 Replies and 4520 Views Lawson printing  4520  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 4520
by  Ruma MalhotraJump to last post
05/11/2012 11:32 AM
3 Replies and 1921 Views Crystal Reports broken after 9.0.1 upgrade  1921  3 Started by  JonA We upgraded from 9.0.0.4 to 9.0.1.5 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 1921
by  JonAJump to last post
05/07/2012 12:57 PM
12 Replies and 3381 Views LBI login and dashboard loading getting slower all the time...  3381  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 3381
by  Chris MartinJump to last post
05/04/2012 7:36 AM
1 Replies and 1259 Views A link to change parameters for all reports on a tab?  1259  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 1259
by  Matthew NyeJump to last post
05/02/2012 3:17 PM
10 Replies and 1709 Views Schedule report users *Share* ??  1709  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 1709
by  Greg MoellerJump to last post
05/02/2012 2:52 PM
1 Replies and 1602 Views LBI text datasource question  1602  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 1602
by  Greg MoellerJump to last post
04/30/2012 8:31 PM
15 Replies and 4318 Views Setting LBI timeout params  4318  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 4318
by  Greg MoellerJump to last post
04/27/2012 11:16 AM
7 Replies and 3251 Views Export a scheduled LBI report to excel DATA ONLY format  3251  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 3251
by  jeff-lbiJump to last post
04/26/2012 12:58 PM
5 Replies and 1619 Views Scheduled report no longer runs after new report user added  1619  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 1619
by  jeff-lbiJump to last post
04/26/2012 12:26 PM
1 Replies and 1474 Views Login to LBI Using Domain Account  1474  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 1474
by  Matthew NyeJump to last post
04/11/2012 3:19 PM
6 Replies and 1849 Views Dashboard Tabs - making multiple rows  1849  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 1849
by  Xin LiJump to last post
04/02/2012 3:36 PM
6 Replies and 1785 Views Report Tooltip in underlying data table?  1785  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 1785
by  Chris MartinJump to last post
03/30/2012 11:56 AM
1 Replies and 1882 Views LBI bursting rights  1882  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 1882
by  Matthew NyeJump to last post
03/22/2012 10:27 AM
2 Replies and 2592 Views HRHISTORY table compare date rows  2592  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 2592
by  SarahJump to last post
03/19/2012 2:20 PM
1 Replies and 1381 Views REPORT server.  1381  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 1381
by  Matthew NyeJump to last post
03/19/2012 1:07 PM
17 Replies and 3247 Views LBI Connection to AS400 Server failure  3247  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 3247
by  imtyJump to last post
03/15/2012 7:02 PM
4 Replies and 1339 Views Updated to 9.0.4.2.98 on Thursday in PROD  1339  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 10.0.0.0 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 1339
by  ElenaJump to last post
03/01/2012 11:21 AM
34 Replies and 9252 Views MM280  9252  34 Started by  Chris Martin Has anybody had any success reverse engineering MM280 (ie using sql/crystal)
34 9252
by  SPJump to last post
02/24/2012 11:20 AM
4 Replies and 3049 Views LBI Crystal Reports behavior with Adobe  3049  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 3049
by  MHRoyJump to last post
02/16/2012 1:32 PM
1 Replies and 2253 Views What's New in LBI 10 document published on Mylawson.com  2253  1 Started by  Ruma Malhotra I just found the what's now for LBI 10 document present on mylawson.com. 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 2253
by  mark.cookJump to last post
02/16/2012 11:22 AM
2 Replies and 2822 Views Crystal/Xcelsius and LBI Bursting  2822  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 2822
by  Dave CurtisJump to last post
02/09/2012 10:32 AM
3 Replies and 2178 Views Max export to excel ?  2178  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 2178
by  Matthew NyeJump to last post
02/08/2012 3:10 PM
0 Replies and 1210 Views Is there a way to get the user_id name to print on a Crystal rpt?  1210  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 1210
02/08/2012 10:50 AM
5 Replies and 2794 Views Open Crystal Report Hyperlink using updateModule in LBI  2794  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 2794
by  Matthew NyeJump to last post
02/07/2012 3:11 PM
4 Replies and 2565 Views Portal Field Descriptions  2565  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 2565
by  Jim Van ZummerenJump to last post
02/01/2012 8:03 AM
2 Replies and 2192 Views GEN Database Programs and Screens  2192  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 2192
by  Greg MoellerJump to last post
01/31/2012 8:44 AM
3 Replies and 3284 Views Link to Webinar?  3284  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 3284
by  SPJump to last post
01/27/2012 3:40 PM
4 Replies and 1633 Views No recipients to whom to send the content  1633  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 1633
by  Greg MoellerJump to last post
01/27/2012 2:33 PM
3 Replies and 2584 Views Crystal Slow Loading in LBI  2584  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 2584
by  MHRoyJump to last post
01/25/2012 12:25 PM
7 Replies and 4794 Views Crystal Report Viewer Erroring out in 1 IE User Workstation  4794  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 4794
by  jeff-lbiJump to last post
01/25/2012 11:25 AM
1 Replies and 2001 Views Printing Lawson Report Number on Report  2001  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 2001
by  John HenleyJump to last post
01/25/2012 9:29 AM
13 Replies and 3636 Views Fields restricted? Excel pull of Lawson data through OLEDB  3636  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 3636
by  BertNeu...Jump to last post
01/11/2012 3:17 PM
6 Replies and 3319 Views Crystal Reports How to determine frequency of RUNS  3319  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 3319
by  LayneJump to last post
01/09/2012 3:19 PM
6 Replies and 2934 Views Oracle odbc drivers for RS ODBC on LBI 904 Win 2008 64bit  2934  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 2934
by  RobbyJump to last post
12/19/2011 12:31 PM
2 Replies and 1974 Views Crystal and .csv table linking  1974  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 1974
by  KatfraJump to last post
12/05/2011 2:40 PM
10 Replies and 2876 Views LBI report users  2876  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 2876
by  Greg MoellerJump to last post
11/15/2011 4:34 PM
8 Replies and 2248 Views FS page goes off line with Portal integration (efsrole.xml)  2248  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 2248
by  Massimo EmilioneJump to last post
11/15/2011 4:16 PM
4 Replies and 2627 Views LBI Synchronizing User and Groups  2627  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 2627
by  Massimo EmilioneJump to last post
10/08/2011 11:33 PM
11 Replies and 1995 Views Scheduled report to be emailed to a directory instead of an email device ?  1995  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 1995
by  Ben CoonfieldJump to last post
10/07/2011 2:23 PM
5 Replies and 2020 Views Scheduled LBI report to a constant server location  2020  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 2020
by  Greg MoellerJump to last post
10/07/2011 11:22 AM
5 Replies and 1699 Views Importing Rights with multiple users: Is is possible?  1699  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 1699
by  Greg MoellerJump to last post
09/28/2011 3:49 PM
6 Replies and 3785 Views Occassional blank LBI report  3785  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 3785
by  des123Jump to last post
09/28/2011 3:47 PM
4 Replies and 2347 Views Not valid for List error message when trying to access LBI report list  2347  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 2347
by  Louise IJump to last post
09/28/2011 3:40 PM
2 Replies and 1274 Views Only Crystal?  1274  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 1274
by  WRBJump to last post
09/27/2011 3:57 PM
11 Replies and 7160 Views Is there a way to execute a program from within Crystal Reports 2008?  7160  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 7160
by  C FritzJump to last post
09/23/2011 2:31 PM
3 Replies and 3316 Views The maximum report processing jobs limit configured by your system administrator has been reached.  3316  3 Started by  Xin Li We have a crystal bursting to hundreds of users every month. It worked before we upgraded to LBI 9.0.4.2.79 and CRAS 12.3.0.61. 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 3316
by  Greg MoellerJump to last post
09/16/2011 5:08 PM
3 Replies and 2801 Views LBI Email Delivery Scheduling  2801  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 2801
by  Ruma MalhotraJump to last post
09/15/2011 2:59 PM
1 Replies and 1217 Views Assigned role not stick with user in LBI  1217  1 Started by  Xin Li After we upgraded LBI to 9.0.4.2.79. 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 1217
by  Xin LiJump to last post
09/13/2011 2:03 PM
2 Replies and 2246 Views LBI timedout issue  2246  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 9.0.4.2.79.
2 2246
by  mark.cookJump to last post
09/09/2011 7:37 AM
6 Replies and 3562 Views LBI report field overlapping  3562  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 3562
by  Xin LiJump to last post
09/08/2011 10:20 AM
0 Replies and 1976 Views Budget Actual Reporting (K12)  1976  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 1976
08/26/2011 10:09 AM
1 Replies and 1209 Views Solution Set for Reports - Report ID?  1209  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 1209
by  Ruma MalhotraJump to last post
08/24/2011 11:26 AM
0 Replies and 2165 Views Reporting Services: Saved Parameters Option  2165  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 2165
08/24/2011 10:13 AM
1 Replies and 1324 Views LBI Uploading Rights  1324  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 1324
by  George GrahamJump to last post
08/23/2011 10:37 PM
0 Replies and 2096 Views Publishing a Crystal Report with a SubREport  2096  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 2096
08/17/2011 8:42 AM
0 Replies and 1817 Views Options for saving Report output (file name) from LBI Dashboard  1817  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 1817
08/16/2011 9:14 AM
4 Replies and 1813 Views Publishing ReportWriter Reports  1813  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 1813
by  Greg MoellerJump to last post
08/11/2011 8:23 AM
1 Replies and 1579 Views Bursting in LBI; user is noted as <device only user>  1579  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 1579
by  Greg MoellerJump to last post
08/10/2011 12:48 PM
3 Replies and 1652 Views Unable to export LBI report  1652  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 1652
by  mark.cookJump to last post
08/05/2011 1:11 PM
3 Replies and 1402 Views Search box in framework services?  1402  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 1402
by  Chris MartinJump to last post
08/01/2011 1:27 PM
4 Replies and 1956 Views Options for export?  1956  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 1956
by  Greg MoellerJump to last post
07/12/2011 2:43 PM
6 Replies and 2670 Views RW100 copy to Crystal  2670  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 2670
by  AmyVJump to last post
06/29/2011 2:19 PM
1 Replies and 1114 Views LBI 902 compatibility with Lawson S3 901  1114  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 1114
by  George GrahamJump to last post
06/22/2011 1:36 PM
1 Replies and 1379 Views Filter a Smart Notification on a Dashboard Tab  1379  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 1379
by  Matthew NyeJump to last post
06/22/2011 12:27 AM
6 Replies and 4189 Views Drill Around question  4189  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 4189
by  Fernando LabradaJump to last post
06/14/2011 4:53 PM
2 Replies and 2720 Views QuickStep Crystal Reports - How to view data  2720  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 rock.lawson.com. 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 2720
by  Ruma MalhotraJump to last post
06/14/2011 4:38 PM
3 Replies and 2867 Views RW100 for Crystal Report  2867  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 2867
by  wintergreenJump to last post
05/26/2011 9:29 AM
3 Replies and 1418 Views email bursting  1418  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 1418
by  Matthew NyeJump to last post
05/24/2011 2:51 AM
1 Replies and 1846 Views Other BI tools Compatible with LBI  1846  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 1846
by  Matthew NyeJump to last post
05/20/2011 12:57 AM
2 Replies and 1862 Views 3 Tools dashboards ?  1862  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 1862
by  Greg MoellerJump to last post
05/19/2011 12:04 PM
4 Replies and 2262 Views LBI security / users  2262  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 9.0.2.2.127... Help
4 2262
by  Chris - MIBHJump to last post
05/18/2011 12:08 PM
8 Replies and 1463 Views Unable to view Framework Services System Adimin Tools with DSSO - Pls help  1463  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 1463
by  Ganesh RJump to last post
05/16/2011 11:42 AM
5 Replies and 1721 Views On Demand Crystal Reports in Reporting Services  1721  5 Started by  WRB We have several reports published in Reporting Services (9.0.4.1.156version) 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 1721
by  WRBJump to last post
05/05/2011 5:27 PM
1 Replies and 1350 Views Array Summaries that will not Print  1350  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 1350
by  DonnaJump to last post
05/02/2011 7:25 PM
6 Replies and 3560 Views LBI authentication against ADAM  3560  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 3560
by  Anne-MarieJump to last post
04/29/2011 4:04 PM
0 Replies and 1689 Views Lawson Webinar today at 10:00 AM and 1:00 AM on LSO  1689  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 1689
04/28/2011 9:19 AM
5 Replies and 2866 Views On Demand Reports in Reporting Services  2866  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 2866
by  Matthew NyeJump to last post
04/28/2011 12:50 AM
1 Replies and 1247 Views Add Parameter Values to Instance Name or Description  1247  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 1247
by  Matthew NyeJump to last post
04/27/2011 8:22 AM
6 Replies and 3260 Views Can you join PRDISTRIB to PRTIME?  3260  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 3260
by  Carolyn LeeJump to last post
04/26/2011 1:51 PM
0 Replies and 1301 Views Viewing a work file in LBI  1301  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 1301
04/20/2011 11:01 AM
0 Replies and 2286 Views Suppress Crystal Viewer Error messages?  2286  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 2286
04/19/2011 10:19 PM
4 Replies and 1288 Views SmartNotes to open Crystal and jump to a page  1288  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 1288
by  David WilliamsJump to last post
04/13/2011 2:30 AM
1 Replies and 1165 Views Displaying Reports on Dshaboards - CR2008 LBI9041  1165  1 Started by  Nick We upgraded LBI to 9.0.4.1 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 1165
by  George GrahamJump to last post
04/12/2011 10:09 AM
12 Replies and 2330 Views Automatically database connection  2330  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 2330
by  Matthew NyeJump to last post
04/11/2011 10:06 AM
2 Replies and 1045 Views Limit on the Number of rows to burst in smart notifications  1045  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 1045
by  Ruma MalhotraJump to last post
04/09/2011 10:58 AM
2 Replies and 1520 Views DME substitute- RW?  1520  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 1520
by  mikePJump to last post
04/08/2011 2:44 PM
1 Replies and 1161 Views Datasource for LTM?  1161  1 Started by  George Graham Anyone set up one of these yet within Reporting Services
1 1161
by  NabilJump to last post
04/08/2011 9:14 AM
23 Replies and 12387 Views LBI tables and/or data dictionary  12387  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 12387
by  Greg MoellerJump to last post
04/07/2011 12:01 PM
8 Replies and 1942 Views Automatic device import  1942  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 1942
by  mark.cookJump to last post
04/07/2011 9:47 AM
1 Replies and 1671 Views Here we go GURUS!! Automate on demand report scheduling  1671  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 1671
by  George GrahamJump to last post
04/05/2011 4:08 PM
0 Replies and 1049 Views Control characters in ers_reportdatasources  1049  0 Started by  Greg Dey While trying to troubleshoot a problem with publishing reports in 9.0.4.1 LBI, I noticed that all the records in ers_reportdatasources have a 'square' after the value in reportdatasource. Looks like maybe control characters  I am using TOAD to view the data. Our database is Oracle 10g. Does anyone else have this issue
0 1049
04/01/2011 10:49 AM
4 Replies and 2248 Views LBI Security Groups  2248  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 2248
by  Ruma MalhotraJump to last post
03/28/2011 2:45 PM
7 Replies and 2996 Views LBI Security setup  2996  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 2996
by  mark.cookJump to last post
03/25/2011 12:31 PM
3 Replies and 1330 Views LBI -Still Learning  1330  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 1330
by  John HenleyJump to last post
03/25/2011 9:21 AM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 4 of 9 << < 23456 > >>


RSS Feed Available