Forum: Lawson Business Intelligence/Reporting/Crystal

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.
137 Subscribed to this forum
Page 22 of 34 << < 2021222324 > >>

Topics

Replies
Rating
Status
Views
Subscribers
Last Post

Open an Image from a Crystal Report    

Started By  TracyO
I have been asked to add a link to a Crystal report that will open up the image from Webnow.  The link would need to use informaion from the line of the report that you want to see the image for.  Has anyone done this or know where I can find information on how to do it.  I don't even know where to begin, so any help on where to find out the 'how to' would be greatly appreciated. Thanks
20 6192 1
by  TracyOJump to last post
5/18/2010 2:26 PM

ACHISTDTL linked to PURCHORDER    

Started By  TracyO
We are trying to create a Crystal report to create more meaningful invoices to our locations. The GL120/121 does not give enough details. I want to be able to somehow tie back to the PO line Descriptions. I am not sure if these are the correct files, but I see the information I need on ACHISTDTL for hte BR side and I have linked the PURCHORDER, POLINE & MMDIST tables to get what I need on that side. I am looking for the bridge to get me from one to the other. Has anyone created a report to ...
8 3602 1
by  TracyOJump to last post
5/20/2010 6:41 PM

DSSO upgrade to 9.0.1.5    

Started By  Chitta
Hi, I am planing to upgrade our Lawson LSF 9.0.1.2 to 9.0.1.5, being the part of it, i have to upgrade LBI as well, but i have no idea where to download DSSO 9.0.1.5, i cannot found in Products download page in LGS. can any one please provide me the steps and for upgrade DSSO
6 3650 1
by  Matthew NyeJump to last post
4/28/2010 11:27 AM

Issues in Crystal Report    

Started By  dipu
How can I get the max value of check-date in lawson 9 with crystal reports9. I created a report how ever it is not showing the correct value. Please help. The condition I need is the max( check-date)
1 2826 1
by  CharJump to last post
4/28/2010 10:47 AM

Count/Sum Question    

Started By  FireGeek21
I have an id field in which the same id may exist multiple times for an employee. I have another field whose values are true or false. How can I count the number of true/falses for each unique id
2 2895 0
by  FireGeek21Jump to last post
4/28/2010 7:48 PM

DME query issues    

Started By  dipu
how can I get the maximum check date while creating a query in Lawson Query Builder, where I have informations about employee, employee status, process level, company and paymastr only. Please help.
7 7129 1
by  Shane JonesJump to last post
5/11/2010 2:35 AM

Samrt Notification for Parent & Child    

Started By  Ruma Malhotra
I am creating a smart notification which works like a parent-child but both parent and child are derived from 2 different infosets instead of the same. The parent notification is delivered and the child is not delivered as the case would be. I am trying to schedule both the parent and child infosets to update and wondering whether they should be scheduled at the same time or whether the child before the parent. The logic for this is if the parent and child infosets update on the same ...
4 3147 0
by  Ruma MalhotraJump to last post
5/10/2010 3:24 PM

PO Comments    

Started By  Kevin Hagan
I am working on a report and looking to pull in the comments added from the PO20 screen. Originally I thought that they would be stored in either L_HPCR or L_DPCR but that turned out not to be the case. I am hoping that someone can point me to the table these comments are stored in.
5 8693 1
by  Kevin HaganJump to last post
5/6/2010 2:29 PM

Dashboard to publish crystal reports other than LBI    

Started By  Thomas Varughese
Hi, Can some one recommend a solution that can be used to publish crystal reports other than LBI We have third party software that needs some crystal report development and these users should not be a Lawson user. We need to publish the reports to some kind of dashboard for the users to generate the reports. Any ideas and suggestions most appreciated. Thanks, Thomas.
5 4709 1
by  John HenleyJump to last post
5/14/2010 10:37 AM

Report to calculate PTO, Sick leave hours for taken by an employee    

Started By  Ruma Malhotra
I am trying to create a report for all employees for their PTO hours, sick leave etc but for a month. Since this report should show me all the pto time taken by the employee for a months and all payroll tables store hours by pay period end date I would like to find out if anybody has created anything like this. This would mean that the pay period end date may fall on the first of the next month but have hours that belonged to the last 2 weeks of the previous month. Is there a formula that i...
2 4828 0
by  Ruma MalhotraJump to last post
5/14/2010 5:23 PM

Filter by Current User's Group    

Started By  MCordero
Our company is very new to Lawson (9.0.1.5..still currently not live), and I've been looking at Crystal Reports 2008 through LBI. Most of our reports need to be filtered based off what facility the current user is a part of. How do I go about pulling user's Facility Group and pass it as a parameter Or, I suppose I should as a more general question of how do I pull a user's 'anything' to pass as a parameter
12 4127 0
by  MCorderoJump to last post
5/28/2010 1:56 PM

Need a report that shows previous pay rate    

Started By  Deleted User
I am building a report that shows current pay rates, effective date, reason for the change, as well as the previous rate. I have everything except the previous rate working, and I keep hitting the wall. My logic has been to use a nthLargest=2 on the PRRATEHIST.BEG_DATE field. To pull the previous pay rate I then use the formula: if {PRRATEHIST.BEG_DATE} = NthLargest (2, {PRRATEHIST.BEG_DATE}, {EMPLOYEE.EMPLOYEE}) then {Pay Rate} Even though the {NthLargest (2, {PRRATEHI...
2 3170 1
by  Shane JonesJump to last post
6/2/2010 7:47 PM

Updates made system down    

Started By  Chitta
Hi All, I am newbie to LBI, as we faced ERROR500 while brusting reports with details option, we advised for FSupdate to 9.0.3.1.151 and RS 9.0.3.1.156. But after updates the LBI install validator itself not working'page cannot find' error, and LBI application also the same error, but In WAS, FS,SN,RS every thing working fine, can any one help me where to look Regs, Chitta
2 2812 0
by  ChittaJump to last post
6/10/2010 9:34 AM

Supply Chain Help    

Started By  Michael7
I have been working with LBI for the past year and a half developing and mainting HR specific reports. We are looking to expand into supply chain. I am completely new to supply chain, so I do not know the data structure or the key metrics related to this division. I was hoping I can find some help here. Maybe see some example reports related to materials management, purchasing, buyers, inventory, etc. Any help is greatly appreciated.
2 3300 0
by  Michael7Jump to last post
6/11/2010 4:53 PM

Publishing Excel/Word Files in LBI Dashboard    

Started By  Saurabh
Hi All We have a set of Excel files refreshed every week by a job. I would like to place a link to those file in the Dashboard. Is this possible or does the LBI dashboard only allow either a 'web address' link or a published Crystal Report This is on LSf9.0.0.4 on Windows 2003 with SQL2005 backend Thanks Saurabh
3 3770 1
by  Matthew NyeJump to last post
6/11/2010 3:09 AM

Crystal Security    

Started By  Kelly H
Does anyone know of any way to lock down Crystal Security so that the end user can only see the departments they have access to in Lawson Or a way to give the end user view only access within Crystal Then we could write the reports with the limits behind the scenes and have them refresh them only. Thanks!!!
7 4132 2
by  Ruma MalhotraJump to last post
6/17/2010 12:30 PM

Multiple Output Files From one report    

Started By  David V
I need to create a report in crystal that will read a file with many invoices in it. I then need to create a report for each invoice, that will be it's own file. For example, read 20 invoice. Create 20 files with 1 invoice each. Thanks...
1 2818 0
by  Matthew NyeJump to last post
6/16/2010 6:10 PM

Data File Text equivalent for PLM tables?    

Started By  Chris Martin
Is anybody aware of Data File Text-like documentation for PLM tables
6
6404 2
by  Chris MartinJump to last post
7/16/2010 3:39 PM

RW Report Data not showing in Cyrstal    

Started By  Katfra
I used a RW100 report i created and moved it over to crystal. However, i'm missing 2 lines that are on my RW report so my numbers don't tie out. If i go to the specific data field and browse the data, i can see the data i'm missing. I've tried going to the select expert to specify that data but nothing comes up. Did i do somethign wrong or is something switched to prevent that data from showing
1 2884 1
by  sharonmtJump to last post
7/7/2010 4:54 PM

word PROD in smart notes content    

Started By  Ruma Malhotra
Has anybody encountered an issue where smart notes content on the email is coming out with only the word 'PROD' in it
2 2882 0
by  Ruma MalhotraJump to last post
7/7/2010 5:01 PM

crystal parameters    

Started By  sharonmt
I am a crystal advanced user(using since 1987 every version) i have an issue with 2008 and the parameters it appears that i have to use dynamic paramters, but concerned there will be rpt maintennace when not useing a lookup table to retrieve the values(datasets are sql stored procedures) i would like to be able to use a static parameter where i can use and ALL option or the user can enter a value or multiple with the dynamic parameters i can only use what is from the database values an...
6 4297 0
by  sharonmtJump to last post
7/8/2010 4:28 PM

LBI as an enterprise solution    

Started By  David Williams
Does anyone use LBI as their enterprise reporting repository I know Lawson sells it this way but does anyone use it for Cerner, McKesson or EPIC reporting as well Thanks
6 3898 1
by  Greg MoellerJump to last post
7/15/2010 7:21 PM

error    

Started By  sharonmt
have a report which runs in crystal i run the report, it prompts for my stored proc parameters when it gets to the parameters that are in the report which are dynamic i get this error com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: Missing parameter values.---- Error code:-2147217394 Error code name:missingParameterValueError
3 5198 0
by  Matthew NyeJump to last post
7/8/2010 5:31 PM

Using Smart Notifications To Query LDAP    

Started By  Ruma Malhotra
I am using smart notifications to query LDAP and am able to get data. However I need certain fields in a container and I am not able to write the right syntax to query LDAP to get data for only certain fields. Has anyone able to get this to work and can share the exact syntax for those queries. I believe there are also certain oracle commands to query LDAP but I cannot get any to work and I am sure that the syntax is not right. Has anyone got this to work and willing to share the queries as w...
13 4098 4
by  Ruma MalhotraJump to last post
7/15/2010 2:18 PM

Looking for the SQL behind a Lawson report    

Started By  Wade-T
Hello, I need to write a Crystal report that is similar to the AP265 but with some adjustments. I was wondering where you could find the SQL behind the existing Lawson report to use as my begining point. Is this how you would start Thank you, Wade
6 4087 1
by  TomwiseJump to last post
7/15/2010 10:07 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 22 of 34 << < 2021222324 > >>


RSS Feed Available
Forums Performance Management

Group: Performance Management

Forums
Topics
Replies
Subscribers
Last Post
189 635 14 RE: SQL Help by  Greg Moeller 11/9/2023 2:49 PM