Post reply

crystal report 8 report designer count(field) issues

  • January 4, 2007 at 7:20 am

    #171756

    i need help with counting a field based on the values of another firled.

     

    when i do the selct it works just fine in sql query analyser, but when am in crystal report, i am unable to execute the same quesry.

    in the sql expression feild in crystal report.

    i an trying to get

    the distcinct count (accts) that

    have Base like '%bus%'

     

    does any one know how to do this in crystal reports 8. thanks

    [font="Comic Sans MS"][/font]It is what it is.

  • January 4, 2007 at 9:02 am

    #681241

    i think Crystal requires all fields to have a name/alias, right? try this:

    SELECT DISTINCT count (accts) AS ACCTCOUNT FROM SOMETABLE WHERE Base like '%bus%'

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 5, 2007 at 6:43 am

    #681452

    thanks i will try it.

    [font="Comic Sans MS"][/font]It is what it is.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply