We have a Crystal report that groups employees by Supervisor. There is a running total in the footer that meet specific criteria. For example, a supervisor may have 5 people reporting to them, but none of them meet the criteria. In the footer, that supervisor's running total is 0. We want to suppress that supervisor from displaying if the running total is > 0. We can suppress the footer based on the running total, but not the header. We've played around with different counts, but can't ge...

I have published a Crystal report to LBI that shows overtime paid, grouped by department, and burst (emailed as an attachment) on a weekly schedule to the head of each department so that the department head only sees their department on the report. Occasionally a department has no overtime for the period, but the report is still distributed to the department head with the page headers and no detail (a blank report with the headers at the top). I have tried to find a way to suppress the distrib...

We are pushing out links on dashboard for access to historical instances of reports. The users are getting access to these lists with no issue. However, they get a link for 'Details' which gets them to the report details page. We can lock down all of the items via permissions - with the exception of the General Properties. But this gives them the ability to change the report name, description and if it is active or not. I have not found a way to stop this. I've got a case open on this but no ans...

I am trying to query the reporting services database to find out the user-ids that are attached to a report security group in LBI. I see that ERS_REPORTACCESS has the access_type and access_value which could be a securitygroup for access type and has an access value associated but cannot seem to find a table that lists the user-ids attached to that report security group. We are on the lates version of 9.0.4.2. Previously these values were stored in a table called ENPUSERGROUPLIST. Does anyone k...

Hi All, Anyone ever seen this error message Failed to retrieve data from the database. Details: HYC00:[Crystal Reports][ODBC Oracle driver] Optional feature not implemented When using Crystal Reports 2008 to query the LBI Schemas, I can get some tables, but others result in the error message. How do I fix this Thanks in advance :)

I have a crystal report that has picture objects that are set to hyperlink the user to url. When the user opens the target, it takes them from the report to the correct URL but it won't open that target in a new window. I've found a number of discussions related to this and have tried to implement the solutions. It seems no matter what I do, it continues to open target in same tab and the user then looses the report. I'm thinking this may be a report viewer setting or some other setting with our...

I'm okay on the basics, but I need help with the trickier stuff. Not sure that this forum here is really for that sort of thing, so just wondering if you guys know of a good active crystal forum. I have a set of books in front of me, and I can usually figure it out, once I get pointed in the right direction! :blush:

Hello All, Can anyone recommend a good LBI course/class that I could take that is comprehensive and covers LBI Administration, interfacing LBI with Crystal and writing scripts to control LBI functionality. This may be a pretty advanced course but if there are introductory courses that encompass these areas, then I could first take the introductory course and progress to the advanced course. I have been using LBI as Admin for the past two years. So, I have a pretty good idea in areas suc...

Hi All, I'm seeing LBI 10-1-10-0-1 for the very first time. New install, still setting up for go-live in a few weeks. My previous experience tells me that the Tab 'My Reports' is visible for any user who is assigned reports as 'Report User'. Only - there is no tab showing up... Am I missing something [PS, the 'install' was done by someone else...did they overlook a step] Thanks in advance! Robby

Something that we've noticed is on the schedule the 'Burst Report' check box has been intermittently unchecked by the upgrade. In conjunction with this the check box for Default Permissions (in the schedule) the box for 'Ability to view with refresh data and view with saved parameters' is also unchecked. Everywhere that we find the 'Burst Report' box being unchecked where it should be checked, we are also finding the second box unchecked. Is there any report that I can run that would indicate...

Hello I've got a situation where my cyrstal report published and scheduled into LBI occasionally does not produce a report. This is a long-running report that has not been updated for over a year. Typically the report schedule runs and the report is produced just fine. But lately, but not in all occasions, the report schedule says the report ran but the report is not produced. In these cases, I'll wait an additional day to make sure the report doesn't produce, but it never does. I then r...

I'm trying to write a delivery device audit report. Does anyone know which table and fields I would need I've found the email address listed in a couple of tables and would like the login name, the delivery device name, and the address. Is the EFSDOCUMENTS.DOCNAME the appropriate field to use for the delivery device name How do I tie that back to the login id

We would like to create a report that shows the number of times a report has been run and the last date it was run. Has anyone prepared a query or a report that provides this information

When we access Page Setup while in Crystal it takes over a minute to come up - the same thing when we click on Print - has anyone ever had this happen before It happens to all of us that are developing reports in Crystal Reports 2008.

Good afternoon. We have a weekly file that goes to our medical insurance carrier and tells the carrier: 1. Employees that have current medical, dental and\or fsa\hsa plans with a row for the employee and a row for every dependent that is attached to the plan(s). 2. Employees that have changed medical, dental and\or fsa\hsa plans with a row for the employee and a row for every dependent that is attached or ended their plan(s). If I populate the crystal report sql and record selection, group...

We have LBI running a number of Crystal reports but the bulk of our corporate reporting outside of Lawson is done with Microsoft Reporting Services. Because this is a company standard and reports are easier to deploy, schedule and maintain in MSRS we are considering moving new Lawson report development to MSRS. Has anyone used both MS RS and Crystal with Lawson that could offer their experiences We are curious about any limitations encountered with Crystal and MS RS accessing both Lawson and no...

How would one do that

We have a Crystal report built that uses the MM280 as a datasource. We have been able to successfully run the report to pull in 5 months of data, but when we add a 6th month, it errors out. Has anyone ever experienced or know of any limitations on data size or run time using the OLE DB connector that would cause the report to throw an error Crystal is describing it as a parsing error, but the individual monthly reports run fine--with no errors. Infor Support has told us to just split the rep...

When running a delivery test for a users' email setup, the text in the body of the test email says 'Test email delivery successful!' Can that wording be changed To something like-- Please contact the LBI Administrator, Sally Soso, when you receive this test email. OR--- What happens when its a bad email address I tested, and so far no bounce-back to the admin email inbox...

The record layout for one of our benefit carriers wants the contribution amount to have an implied decimal. I tried toText((ER_Match),2) but that still leaves the actual decimal place. Has anyone ever had to do this

Occasionally a user will log a trouble ticket saying that they are not getting a report they used to get. So, checking the schedule for that report I see that they are still designated as a user, and the 'Recipient(s)' field is still showing 'All Report Users and Roles' I'd like to be able to check their subscription status to see if they clicked the unsubscribe link and forgot :-(

Hi All, It seems that it could be very useful to know things like 'Who is in This or That Custom Group', or when was the last time so-and-so Infoset was updated So, my question is this....Do you have some queries against the LBI Schemas that have proven useful for your end users or for your 'LBI Administrator' Care to share :-)

I want to make reports with Crystal Report. Have find table using MDP. In program MOS320 I want to find the key to table used (CSYTAB), but I don't know the key filtered on. If I could take out the sql behind the program, I beleve I will see this. How can I find the sql behind each program in M3 my kind regards Vilfred.

Has anyone out there ever migrated from one LBI system to another and included a physical relocation of report files My obvious first concern is CLOBs and GLOBs. :-( Any experience with this is greatly appreciated. Infor has recommended a HW upgrade which would take us to 64-bit. Additionally, they have suggested that we consolidate from 2 production LBI instances to a single LBI instance, and from 5 RAS instances to just 3 on beefier hardware. A previous Infor consultant performed t...

When clicking on the calendar button next to a date field, it pops up a 'blank page' screen instead of a calendar. This seems to be isolated to my PC only. Has anyone else encountered this and what was the fix We are on LBI 10.1.0.0.76 Thanks