Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

cross-tab question

Posted on 2001-09-06
2
270 Views
Last Modified: 2012-05-04
I'm fairly new to crystal.  I've created a cross-tab using region as the row field and @week as the formula for the column field.  Order amount is the summary field.  My @week formula is:

["Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"]
[DayOfWeek({Orders.Order Date})]

I grouped by @week and in the cross-tabs group options dialog box I chose specified order.  There was nothing to choose from in the speicifed order tab list box, which I thought was weird so I typed each week in one at a time allowing for any value.

After doing all this, I got a report that only showed the region amounts for Monday and a second column showing the total.  What i wanted was each week across the page and the total.  What did I do wrong?
0
Comment
Question by:ylecoyote
2 Comments
 
LVL 12

Accepted Solution

by:
DRRYAN3 earned 100 total points
ID: 6461465
ylecoyote

Your formula for week is just fine.  Right click on your crosstab, choose Format Cross-tab.  Be sure the Cross-Tab tab is active.

Click on the @Week in the Columns box.  It should be the only field/formula listed.  Click on Group Options button.  The first drop down should be set to read In Specified Order.  When you make that selection, the "specified order" tab becomes active.  It is here that you made your mistake.

You should see the 7 days of the week listed in the drop down control, and initially nothing in the scrolling list.  From the drop down, select each day of the week in the order in which you want them displayed.  All 7 days should be listed in the scrolling listbox when you are done.

OK and SAVE your way out of the dialog boxes and preview your crosstab again.

DRRYAN3
0
 

Author Comment

by:ylecoyote
ID: 6461509
Thank you! I don't know how I missed that.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question