I'm using MS Analytic Services. I have YTD member names in GLDM.5 (and Qtr YTD in GLDM.6) but those elements are not available in my cube - neither in Analysis Manager nor in Scorecard. I get my current period and current qtr elements, but nothing for YTD. GSC hasn't been any help to this point. We've analyzed IA150 and these vales appear to be handled by some java scripting (which is way out of my league) but we're not seeing any issues there. I'm wondering if somehow ytd values just are...

We are trying to create a datasource in LBI that will connect to a non-Lawson database that is on a server outside our network. We have been able to create a NAT'd IP for the server and connect to it with Crystal, but we get errors or a login prompt when we try to do it in LBI unless we change the Data Source to the Nat'd IP before it is published. The issue is the client does not have access to the server to change the Data Source themselves after publishing. They can't use the NAT when publ...

Does anyone know a way to display the user's Lawson acount name in reports run from an LBI server This can be handy in a report heading when you're trying to determine the origins of a printed page at a later date. There a CR function called CurrentCEUserName, but it only works with Crystal Enterprise, which our provider doesn't have. I was hoping someone else may have developed a workaround for this. Thanks, Mike .

Hello, I'm trying to create a report in Crystal using an RW Report i've already created. However, i was given some literature stating before doing this that i need to eliminate my totals and use my totals as headings. So with this being said, do i need to copy my current report and create it backwards. Net income as being my first line followed by my other totals I'm not sure how to go about this the right way. My intention going foward is to build the reports right out of crytal bu...

My friends: I am trying to get XI R3 (AKA 2008) on to our test server. I have no problem applying both along side XI R2 SPx. My question comes in when I have downloaded XI R3 SP3 cumulative from Lawson, it says 'Another version of this program is already installed, this installation cannot continue...' Is there a certain order that you need to apply these in From the readings I've already done, XI R2 and XI R3 can co-exist. Anyone be able to confirm or deny that Thanks much, -Gre...

My organization wants to use Lawson Report Writer reports as the data source for Crystal Reports - which I have read about doing here and in the Lawson Knowledge Base. However we don't have Lawson LBI and they no longer sell the OLE DB connector as a separate item. If I go into Crystal Reports I see that I can add an OLE DB connector for Lawson but it does not give me any way to specify the Report Writer reports as a data source - only tables and such. Is there a way to duplicate what the Law...

hello All, I have two crystal reports published in LBI. One is summary level report another is detail level report. Client is asking for link from summary level report to detail level report. I made attempts to use options 'Report part drill down' and 'Another report object' in Hyperlinks tab of formt editor in crystal reports 2008 and not succeeded. Any help would be appreciated.

Is there a way to create a role in reporting services that has access to all departments but excludes 2 departments. All users can access all reports for all departments except for those 2 that have been restricted.

Has anybody seen issues with the database override function with Oracle 11g and LBI 9.0.4. We have a number of odbc reports that were published and now with the oracle 11g upgrade from Oracle 10gR2 they have stpeed refreshing. Basically the database override function is not working when the reports point to the new DSN on the reporting services page and we are seeing this only on our upgrade to 11gR2. Has anybody experienced this

Does anyone managed to publish any PATCOM relatedd report to LBI We would love to hear from you. PATCOM has its own propriety database and no ODBC driver for it. I wonder whether anyone come up with any creative way to publish PATCOM related report to LBI.

Is there a way to disable the refresh button on the crystal Report viewer launched from LBI Reporting Services

I'm trying to force my stacked bar chart to display the data in a specified order but it's not behaving. Attached is a screen capture of my graph and the group sort order settings.

Our Lawson (9.0.x) environment creates a 1.3 version of Adobe 4.x PDF. Is there anyway to upgrade that pdf generater to something that will generate a newer version Thanks in advanced.

We are trying to create a Crystal report that will inlcude the IC (Inventory Control) details for transactions posted to ACTRANS. It does not appear that there is any link (object ID, etc) from ACTRANS to ICTRANS so we have been trying to link to MMDIST. The trouble is the the indexes on MMDIST do not inlcude AC items and the other indexes have items that are not inlcuded in the ACTRANS table. If we do not use the indexes, the performance is terrible (as MMDIST is a huge table) A...

This might be a little off topic, but let's see what you all think. We've got a data collection website that really has nothing to do with Lawson. Since we already have staff with SQL, Crystal Reports and LBI skills, I'd like to figure out how to leverage them and LBI or just the RAS service to provide reports to users of the non-lawson system without them having to log in to LBI. They don't have user names for LBI and the business owners of this other system are not very keen on making users...

I am looking for advice from other Lawson consultants or clients who are using Windows 7 and develop Crystal Reports. My laptop died forcing me to buy a new one and could not get another Windows operating system. I have been developing reports in Crystal 2008 for 2 years using Windows Vista with no issues. Prior to that I have been developing Crystal Reports since 1997 with many versions of Crystal and Windows. I am on a client assignment using Crystal 2008 and Oracle 10g. I did some res...

We have LBI report that has heperlink for user drillaround. Unfortunately it open the link in current I.E Window instead in a new I.E. window that is not desirable. Does anyone know how to force hyperlink in crystal report to display on a new I.E. window

We have several CXI reports that use Excel as a datasource (From a network share) and I have been approached to see if there is a way for me to get them into LBI. I have been attempting to get it to work, to no avail. The reports work fine when they are run in Crystal, but once I upload the rpt to LBI, I get the following error: Error Failed to load database information. Error in File C:\WINDOWS\TEMP\PE LBI Test 01 {1FCAF25D-D167-41B6-93B1-E92A1D6B7B2D}.rpt: Failed to load database inform...

I just logged this hole with Lawson. Hopefully they will fix it soon. Anyway, here is the security hole. Ie: http://server:port/efs/ConfigurationAssistant No login check, nothing, and you can make changes.

I am trying to create a hyperlink from a Crystal Report to GL90 (Transaction Analysis). I have been able to successfully write the hyperlink with the exception of being able to pass the Fiscal Year, Beginning and Ending Periods. following is the string I am using: 'https://laprd1.sharp.com:4443/lawson/portal/index.htmtarget=_blank_PDL=P90&_TKN=GL90.1&_HK='&{GL90Drill} THE HK is based upon a formula is Crystal: GL90Drill which concatentates the Company, AU, Account, SubAccount, Fis...

Can someone please explain the difference between these two types of groups and which one is better to use and why Doing some maintenance on our LBI reports and dashboards and trying to decide which ones to set up.

We have two LBI instances(9.0.2.2.127) on seperate servers using WebSphere (6.1.0.17).  We have two seperate databases too.  We have DSSO set up too.  I want to keep these two in sync.  How does one do that I have tried copying the sql tables and the data folders, but run into DSSO errors on the test instance of LBI.

I'm currently using LBI in the test environment and have come across a problem.  I have an 'x' in all the icons which would show me: Print, Export, Next Page, Prev Page, etc... I was told by my IT department that it's a compatibility with IE8 but was at my user group this week and was told there is a fix and should be compatible.  I was wondering if anyone has had this problem and if so, what can i do    Thanks, Frank

I'm fairly new to LBI and what I would like to do is set up a drop down of pre defined date parameter formulas such as Year to Date, Last Month, Previous 6 Months, as well as Date Ranges instead of the user having to select the start and end dates.  I know it can be done within crystal, but can it be done through LBI  If so, how would this be accomplished  I've tried just hard coding 1/1/2010 as a date in a drop down list but haven't been able to get it to show up when the date parameter is ...

Apparently at CUE someone showed how to publishe Reporting Services reports via Process Flow.  I can't find any information on this does anyone have some info on this they would not mind sharing. Thanks