This is how my crystal report should look like
A main header INSPECTION REPORT and sub header active as of then print date.
                         INSPECTION REPORT
            Active as of report date(todays date)
Tech Name Certificate # Issue Date Expiration Date
abc               3465            04/25/2007   06/30/2011
efg               ---              ---        ---
            Expired as of report date (todays date)

Tech Name Certificate # Issue Date Expiration Date

            Terminated as of report date

Tech Name Certificate # Issue Date Expiration Date

Now I have a stored procedure that populates these fields

I wanted to ask is there any way I can add a logic that will route all values depending on when the expiration date is. Like is it is active fields of active is populated is it is expired then then fields of Expired as of report date (todays date) is populated.
your help will be greatly appreciated

Neha