Crystal report Crosstab

35 pts.
Tags:
Crystal Reports
Crystal Reports Crosstabs
I want to run the report for 2007,2008 and 2009 how to display this three year in the top by month

Answer Wiki

Thanks. We'll let you know when a new response is added.

Create a year formula for the field you wish to test

year({database.field}). In the cross tab expert put that formula in the columns area. Hope that helps. If not, please provide a little more detail and I’ll try again.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Hapipee
    hi! hey guys! Im having a problem when it comes to cross tab reporting.. i dont know how to make cross tab reports. can anyone has idea or tutorial? thanks! any help would be appreciated! Regards, Happy
    15 pointsBadges:
    report
  • carlosdl
    70,190 pointsBadges:
    report
  • Brijesh
    TRANSFORM Count(tblCalls.[CallNumber]) AS CountOfCallNumber
    SELECT tblCalls.[CallTypeID], Count(tblCalls.[CallNumber]) AS [Total Of CallNumber]
    FROM tblCalls
    GROUP BY tblCalls.[CallTypeID]
    PIVOT Format([CallDateTime],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
    8,280 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following