Solved

cross-tab question

Posted on 2001-09-06
2
269 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Crystal Report Filter Question 6 64
Swapping Last and First names in Crystal Reports formula 2 62
Mask on Parameter CR2008 28 52
Crystal Reports No Record Returned 2 52
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 …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

810 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