Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

cross-tab question

Posted on 2001-09-06
2
Medium Priority
?
278 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 400 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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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. …
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…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

572 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