Home Forums Reporting Services Reporting Services Query to Select data from a single table with mutliple conditions RE: Query to Select data from a single table with mutliple conditions

  • February 28, 2013 at 6:23 am

    #1591961

    renato_mech_334 (2/27/2013)

    Where the document data would be the previous month,

    there would be multiple accounts: for eg: [FTS Yearly Query].Account >= 847000 and [FTS Yearly Query].Account <=847900 or [FTS Yearly Query].Account = 821000

    and multiple depts as well.

    Hi:

    Your question is a little difficult to understand, unfortunately.

    But, here's a quick observation I'll share -- if the example criteria you've listed is taken from the sql code, then your results won't likely be as intended. From your example, I think you might try the following with parentheses:

    (

    [FTS Yearly Query].Account >= 847000 and [FTS Yearly Query].Account <=847900

    )

    or [FTS Yearly Query].Account = 821000

    --pete