Print Page | Close Window

Date Range Parameter Used in Formula with DataPart Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23013 Printed Date: 02 May 2024 at 9:19pm Topic: Date Range Parameter Used in Formula with DataPart Posted By: techsupport Subject: Date Range Parameter Used in Formula with DataPart Date Posted: 11 Aug 2022 at 1:02pm Hello, Report is to show data for each week based on a date range prompt I have this formula but it errors saying the {?DateRange} prompt I get an error "A date is required here." with the {?DateRange} highlighted If DataPart("ww", ({TransactionDate}) = DatePart("ww",{?DateRange}) then Sum({TransactionQty}) else 0) ------------- ____________________ Thank you very much! Replies: Posted By: kevlray Date Posted: 15 Aug 2022 at 4:53am Looks like the Tek-Tips forum has you covered.

Print Page | Close Window