Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Date Range Parameter Help Post Reply Post New Topic
Author Message
lorimack21
Newbie
Newbie


Joined: 30 Sep 2015
Online Status: Offline
Posts: 2
Quote lorimack21 Replybullet Topic: Date Range Parameter Help
    Posted: 02 Oct 2015 at 8:37am
Hi there,

I have my main report with the date range parameter set so that all my sub-reports inside will refresh when the main report refreshes.

However, I need the main report to refresh based on dates of last 7 days or last full week. Any ideas how I can write my ?DateRange to pull from lastfullWeek instead of prompting for dates?


Thanks!
IP IP Logged
praveeng
Senior Member
Senior Member
Avatar

Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
Quote praveeng Replybullet Posted: 04 Oct 2015 at 9:31pm
Hi,

in Reports>Selection Formulas>Record use below code:

{table.modifieddate}<dateadd('d', -7, currentdate)

--Praveen G
Praveen Guntuka,
praveen_guntuka@yahoo.com
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.