Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formula for current quarter based on company calendar

Status
Not open for further replies.

singajeet

Programmer
Apr 20, 2012
1
US
Hello,
I want to create a report show as below:
-----------------------------------------------------------
Header: {Current Quarter from Company Database Calendar} {Next Quarter from Company Database calendar}
-----------------------------------------------------------
Detail: Some data from Database
-----------------------------------------------------------

In detail section I can get data from Database but in header section I want to show "Current Quarter" and "Next Quarter" which is saved in company database.

Would it be possible to calculate "Quarter" information separately from database without joining it with query used for detail section?
 
You could add the header information as an unlinked subreport.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top