Search results for query: *

Using CR XI I have created a parameter for the user to select either New or Used from the field {sales.newused}, easy enough. However the data field contains either "U" or "N" How can I change or replace the "U" or "N" with "Used" or "New", so the the user can type in New and get N or type...

We solved the problem of duplicates by having our MySQL programmer add a field of [datasorces] to the peopledump table. So we no longer have the duplicate records problem. The field contains records such as datasources ,1,3, ,1,3,4, ,1,3,4,5, ,4, ,5, We can now use this field for certain...

How to use Formulas that work in Select expert as a Group Select criteria ? For purchased cars not({sales.stockno} like ['*A*','*B*','*C*','*D*']) For Trades {sales.stockno} like ['*A*','*B*','*C*','*D*'] I now have 3 reports, Used, Used Purchased, and Used Trades I want to combine them in...

RE: Suggestion from Remou SELECT idn, Min(datasource) FROM tblT GROUP BY idn Not applicable or formatted in correct SQL for Access Can anyone help ?

I did it {sales.sold_date}> {mailings.date} and {sales.sold_date} < {mailings.date} +31

Actually what I am trying to do is get ONLY those dates that are in the range of a ZERO to Month from {mailings.date}) so with a date of 5/24/2008 I want 5/24/2008 to 6/24/2008 in Select Expert

I tried both of these and I get an error "A Boolean is required here" DateAdd ("d",30,{mailings.date}) {mailings.date}) + 30 {mailings.date}is formatted as a date field and shows 5/24/2008 Using CR XI

Using Access 2003, we have a main table of peopledump, which has unique records, each with an idn in field idn. However each idn may be in several Lists, such as sales, service, other, etc. numbered 1 2 3 4 5 etc In order to see which lists each person idn is in I have created a query linking...

I did it, Thank You all for your assistance lbass's formula worked best. For purchased cars {sales.stockno} startswith "P" and not({sales.stockno} like ['*A*','*B*','*C*','*D*']) For Trades {sales.stockno} like ['*A*','*B*','*C*','*D*']

This is for a car dealer I need 2 reports on Used car sales I need one for Cars purchased and one for trade ins Cars that were Purchased start with a "P" such as P3389R Then Tradeins have and ending of A or several others such as 13797AR P2905AR 17405AW 15433BR So some have a leading "P"...

I Tried this {sales.stockno} startswith "P" and not({sales.stockno} in ['*A*','*B*','*C*','*D*]) but the the "AR" and the "AW" are still showing Not sure are B C D thye simply may Not be in this date range

Using CR XI I have some stock numbers that I need to select. The ones I want start with a "P" and that's simple enough to select {sales.stockno} startswith "P" But some of those end in "A" or "AR" or "AW" or "BR" So want something like .... {sales.stockno} startswith "P" and...

Thank you, That did it! This would seem to be a common problem. Out of the 15 or so reports I have created, this problem seem to occur almost every time. Why do they make it difficult where you have to use a formula, instead of simply having sections where you could put headers or tittles for...

lbass, I'm not sure exactly what you mean by {table.groupfield} = previous({table.groupfield}) The group field is - GroupName ({sales.sold_date}, "monthly") but using ({sales.sold_date}, "monthly") gives me errors Using - {sales.sold_date} = previous({sales.sold_date}) is better than before...

Using CR XI pro, and I need to have different field headers or text object headers for a Group section vs. Detail section. The group data is generally totals, summaries, or formulas, and so sometimes I need what was the field header in PH to be a text object description, especially if I delete...

Thank you for your response. Perhaps I didn't state my question clearly. The real problem was not just creating formula it was how to use it to format the field in a Group It did figure it out, however. In Group Expert Options, after creating the Group, I select "Use formula as a group" and...

Using Crystal Reports 10, with data from Access or MySQL, The Report is a Zip Code report, with the zip field as the Group. The Data has the zip formated as a number. I have formated it in Crystal as -1123 (no comma and no decimals)This works fine in the body, except in the left drill down...

Report uses only one table "sales" Grouped on Zip Code (top 10 Etc) In a field named "newused" there is either an "N" or a "U" I simply want to count how many N's and how U's in each Group I was able to get answer but had to use 3 formulas Formula1=@Count New if {sales.newused}="N" Then 1...