Search results for query: *

I have a report written in crystal 2008 off sql 2008 db. Ideally, I will always want #1 and only #1. Sometimes I need the #2 only when #1 is not present. The problem is that there are records where #1 and #2 are both present. If thats the case, I only want #1. Can this be done? I appreciate...

Yes, briangriffin, this is lawson data. Here is my code for the Command statement: SELECT aux.MATRIX_CAT, aux.MX_VALUE, gla.COMPANY, gla.ACCT_UNIT, gla.ACCOUNT, gla.SUB_ACCOUNT, gla.FISCAL_YEAR, gla.DB_AMOUNT_01...

I have a report written in Crystal 2008 off sql 2008 and I'm having a problem with duplicate totals in a running total. In my report there are 2 date fields, FBDETAIL.FISCAL_YEAR and Command.FISCAL_Year. FBDETAIL.FISCAL_YEAR is the main driver, while Command.Fiscal_Year may be necessary for...

pmax9999, that did it perfectly. Thanks for all the help!

Hi Guys, I'm using crystal 2008 off sql server 2008. The report is working perfectly, but the end user doesn't like the fact that when he is prompted to select a year, it displays as 2,013 instead of 2013. I've tried editing the parameter properties from number to text, but I have many...

As long as the code works, I don't care how ugly it is. Both Acct Period and Fiscal Year are number fields. I've added the code in the selection criteria, but the report returns an error on my select statement. Says that a "Date Range is required". How should I change that to get the code to work?

Yes

Unfortunately, I only have 2 datefields to work with. Fiscal Year and Acct_Period.

CoSpringsGuy, Thanks. I was able to resolve the array issue by removing the multiple values option from the parameter. I am trying to get the user to input the month they would like to see; which would be the current month, and also show the 2 previous months. Each month has a formula like...

I am using Crystal 2008 and my data is coming from sql server. I have a crystal report that prompts the user for a month. The parameter is defined as a number and is dynamic. I also have it set to true to allow multiple values. Once this is selected, I need to for the report to show the...