Please Help - Can not get all rows to display on report

building reports webintelligence
1

Thanks for taking time to read this. Hope you can help.

Using: Web Intelligence XI Ver 12.3.7 / Webi Applet

Issue: Need Crosstab report to show YTD case sales by item and store.

Problem: Too many stores to export entire file at once to Excel or CSV.

There are 3000+ rows of data and 500 Stores.

I can run the report and it completes but I am unable to export the entire report out. The list actually has 3334 items on it. It will write to Excel (97-2003) but that version has the limits of 256 columns. So, I have exported as much data as possible and then gone back to filter to stores greater than the last store number that exported.

My issue compounds because when I filter to get the stores that wouldn’t export, my number of items reduces from 3334 to 3280.

I need to keep a constant number of items.

I have read posts and found the way to make 2 queries and return a 0 for all items with a null value (by using =If(Isnull([Crnt YTD Billed Qt])) then 0 else [Crnt YTD Billed Qt]) but my item count still shrinks.

Query 1 contains only the Distribution center and the order codes

Query 2 contains the order code, store number, & YTD case sales

The report is set up with Order Code down the left side and Store Code across the top with YTD Case Sales in the data area.

I would appreciate the help to get this solved.

GA3 (BOB member since 2012-06-05)

2

if you absolutely need an excel format then you have to work within the column limits. if you have too many columns my suggestion would be to export as rows (not in a crosstab) and then change it to crosstab/pivot table in excel

erik.stenson :us: (BOB member since 2012-07-30)