Search results for query: *

Hi, the best solution I came up with is first writting this formula (I called it convert) CDbl ({table1.sp_id}) Then using the select expert to select {@convert} = 0.00 This seems to work for me. ------------- DB

Hi, neither of these work -- the isnull returns false (because of the convert database nulls to default) and if I ask for {table1.sp_id} = 0.00 zero records are returned. Any other ideas? ---- DB

Hi, I have several reports that require I have the convert database null values to default option turned on. With this option turned on, how can I write a formual to select blank values? The field on my report displays as "0.00" & it is a number data type, but in the select expert this...

Hi, I will try to explain what I am doing, or looking for: I am looking for a formula that will give me the balance when the product is -either a class 1 or 6 - but exclude if the type is "A" and if there is a 15, 21, 23 in any of the 5 fields (cd1, cd2, cd3,cd4,cd5) - or exlude if the type...

Does anyone have more advice on this problem I am having? ------- DB

Hi -- sorry as I look back at this I have not made my intent real clear, whoops. I guess I have been looking at this too long. My objective is two different formulas -- one to give me the records that meet the conditions (the 1st "in" formula) and then a seperate formula that gives me the...

Hi, the problem is that the 15, 21, 23 could be in any of the 5 cd1, cd2, cd3, cd4, cd5 fields. And I need to return if it is in any one of the 5, so that is why I used "or" --------------- DB

Hi, thanks for the quick reply -- I have been looking at this all day and I can't find the solution, is it possible for someone to show me the proper parenthesis ?? ----------- DB

Hi, I am looking for some clarity in how Crystal Reports XI handles "or" statements and the "not in ....." statements. I have 2 formulas below, the top one works fine and I get the proper results, but the bottom one returns the same result as the top one -- the fields table1.cd1, table1,cd2...

I have many old Crystal Queries (QRY) from Crystal 8.0 I would like to have these converted to Crystal XI, but it no longer supports the QRY files. It says I need business views, but I believe those are part of Crystal Enterprise, which I don't own. I guess I could convert them to SQL views...