Greetings,

I am new to the Crystal Forum and would like to say I am looking forward to learning lots of great report techniques from the experts! :)

So here goes...I have created a Cross-Tab Report for reporting monthly data. You enter a date, which determines the desired year. The report returns records from the 1st day of the selected year to the last day of the selected year.

Using the Cross-Tab Expert, I have selected a Column TRXDATE and set the Group Options as " This column will be printed: for each month."

When the report runs I have Columns for each month as desired.

Here is my question. When I run the report for a history year such as 2014. I have 12 evenly spaced columns. When I run the report for the current year, I naturally only have columns for months having transactions, (i.e. Jan, Feb, Mar, Apr). The displayed report only has 4 columns.

Is there a way to show 12 columns when the report is run in the current year? 4 Columns would have data and 8 columns would show a zero?

Thank you.

Thank you! I have created the Calendar table and joined this table to the desired table. My purpose in this is to create a Cross-Tab report that will contain a Bar chart. The chart will group on the Month and then Accounts. For each month, an item has Sales, Cost and Volume. The desired bar chart would have three bars for each month. Up to this point, I can only display one bar for each month.

Again, I am grouping on Month (Jan, Feb, Mar, etc.) and Accounts (Sales, Cost, Volume).

I appreciate your guidance on creating a Cross-Tab Report, with a Bar chart having three columns each month.

Thank you!

Thank you! Worked great!

Hopefully, this is my last question, I am still working with the Cross-Tab report and I am trying to create a summarized field call % Margin. This field uses two formula fields. The first is Spread (which is Cost/Sales) and the second is Sales.

The formula is displayed as Spread/Sales *100. When I run the report the value is wrong.

I am using Crystal XI.

Any suggestions?

They are correctly displayed individually. It's when I try and preform the calculation the calculation is incorrect.