Sage 100

Any Crystal Cross-tab experts out there? It was probably back in the 8.5 Crystal version but I thought I'd made a cross tab report with multiple rows display on one line, instaed of the ugly chop up and extra subtotals Crystal 11 has but I can't seem to make it work on this version. Is that possible in 11? I have used a formula for pulling the item and description into the field but the user wants to export to Excel and with a formula they need to use text to columns to separate the values.

If they need it in Excel, why not use a pivot table instead?

Damn, Mark beat me to it! This would look to be VERY doable in a pivot table. I assume your columns are months. Would take about 10 minutes to set up in Excel.

I would use a pivot table but they need both - the crystal report and the export. I suppose I could just go with the pivot and save myself some grief but I'd seriously like to beat this quirk in Crystal crosstabs - they've be so much more useful then.

A thought would be to make the pivot table part of the Excel spreadsheet that you are exporting Crystal to. Eliminate a step completely.

Where's the item description coming from?

You can turn off the subtotals at least.

In Group Options for the row, I customize the Group Name field to be ""Item + "" "" + Description"", etc. May have to get fancier if the first item varies in length, like ""Item + space (20-length(Item)) + Description"".

Here is an example using Pivot Tables. Q & D, took about five minutes.

Thank you all - and @JeffSchwenk that was very nice of you to provide that! @BethBowers - your suggestion was very similar to what I Implemented but I used fixed length rather than a space delimiter . In Basic Syntax in Crystal it looked like the following for each data element (and used another formula to string these elements together) Dim ItemsString as string Dim ItemCodeSpace as number If Len({CI_Item.ItemCode})< 30 then ItemCodeSpace = 30 - Len({CI_Item.ItemCode}) Formula ={CI_Item.ItemCode} & Space(ItemCodeSpace) Else Formula = {CI_Item.ItemCode} End If

Oooh, my head hurts just trying to make sense of that code. Pivot tables, drop and drag. No thinking required!!!!!!