Solved

cross-tab question

Posted on 2001-09-06
2
272 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
[X]
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
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

688 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