Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Display the current week of data - Crystal Reports 2016

Display the current week of data - Crystal Reports 2016

Display the current week of data - Crystal Reports 2016


Im new to Crystal reports, Im trying to build a more granular chart, in Crystal, off a report that I currently generate and then export to excel.

I have data that runs from the start of this year through today as I refresh the report data every morning to include what we did yesterday.

so the fields I use specifically are the Date and the Quantity fields. Simple straightforward but it tells the entire story.

In excel I can show a table that is monthly, weekly and daily, In crystal the charts aren't exactly pivot charts.

I've managed to generate a chart showing the monthly data and a chart showing the weekly data too, what I'd like to do is have a chart generate showing the last 2 weeks worth of data, From Monday to Friday and have that update at the start of next week. Does that make sense?

RE: Display the current week of data - Crystal Reports 2016

I assume you have two date groups by Month and by week. Then placed your charts in week and Month group header?

You could create another group for a two week band. The only way I can think of doing this is to use week number
DatePart ("ww", {table.date})

If DatePart ("ww", {table.date})<=2 then Band01
If DatePart ("ww", {table.date})>2 DatePart ("ww", {table.date})<=4 then Band02
If DatePart ("ww", {table.date})>4 DatePart ("ww", {table.date})<=6 then Band03
Repeat for 26 bands
Need to use zero padding to ensure Group sorts correctly
Group on this and place between Month and week Groups


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close