Post reply

Report sorts

  • August 24, 2005 at 1:29 pm

    #165852

    I have generated a reoprt with the following sort fields, ITEM, PO MUNBER, VENDOR NAME, START DATE & END DATE.  I would like to be able to type in ITEM number, START DATE and have the report return all ITEM for that date.  I am not sure how to use the sort fields as stand alone or in combination with another to return date based on selected sort date.  Any help would be appreiated.

    Regards,

    Michael

  • August 25, 2005 at 7:11 am

    #584941

    Based on the value in the sort field, you could dynamically hide columns if that helps. 

    A more complicated approach is to use a stored procedure and then through if statements, run the select for the desired data.  If you take this approach, you'll have to have each block in the SP return the same column name so alias each column.

  • August 25, 2005 at 8:22 am

    #584998

    I have done a similar report based on a date selection and I had to do it thru a stored procedure and parameter in my report. If you are using dates with times , the datetime datatype, for your dates, don't forget to take that into consideration.

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

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