Results 1 to 4 of 4

Thread: Report Header

  1. #1
    Join Date
    Apr 2003
    Posts
    54

    Question Unanswered: Report Header

    Hi,
    I have a sales report which may not have contents everyday. If the selection criteria does not return any rows then the report is empty. I want the report to display the header and in the body print "NO SALES FOR TODAY", if there are no rows. How do I do this????

    Please help..........

    Regards

    Jaideep

  2. #2
    Join Date
    May 2004
    Posts
    46
    Just use the ISNULL function. For Example:

    if isnull({Table.Field}) then 'No Records'

    Cheers-

    Joel
    reportwritingexperts.com

  3. #3
    Join Date
    Apr 2003
    Posts
    54
    Where do I say that??? In the record selection formula or comewhere else. Also, I an selecting a number of columns from one table and grouping by userid.

    Please help........

    Regards

    Jaideep

  4. #4
    Join Date
    Apr 2003
    Posts
    54
    This report is a sales report for every salesman. So for a given period of people it will give back records of may be some sales people. But It does not even show the page header if there are no records. I want it to show the page header with the info that NO RECORDS if for a given periods no one sells anything. Is this possible in CR 8.5????


    Regards

    Jaideep

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •