Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Single Date Parameter to run financial Quarterly Report in Crystal

Avatar of geek-goddess
geek-goddess asked on
Crystal ReportsDB Reporting Tools
18 Comments1 Solution587 ViewsLast Modified:
I have 1 date parameter called {?Quarter} and it is defined as a date.  I want the user to enter this date (ie. 2008-05-01) and then want the report to pull all financial data from that entire quarter from a table field {table.invdate}.  Then summarize that data.  I've got the summarizing down, but my record selector does not seem to care about the date entered.  It is giving me all data for all quarters that year.

I do want this info, but I'd like the report to define the quarter and print that quarter's data first and then the 3 previous quarters.

Based on the above date entered example of 2008-05-01:

Quarter          Invoice Date          Invoice #          Sales         Tons
2nd                5-1-08                   123                   $2000        150
2nd                5-2-08                   246                   $1500        125
The above would be my details section (suppressed or not).

Group #1 Footer - Summarized

2nd               Invoice Date & # - suppressed     $3500        275    >>Year (2008)
1st                                                                      $4000        300     >>Year (2008)
4th                                                                      $3000        285     >>Year (2007)
3rd                                                                      $3000        290     >>Year (2007)

Any suggestions?

Thanks so much.
Beth
ASKER CERTIFIED SOLUTION
Avatar of dougvarga
dougvargaFlag of United States of America image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 18 Comments.
See Answers