Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Excel is not populating all of the data.

Posted By Terry Bumgardner over 4 years ago

I have an Intelligence report generating and excel document. There are several sheets. One sheet in particular stops populating part of the records at line 3000. The other sheets populate just fine past the 3000 line. This sheet has 8 columns of data. Seven columns fill out completely, and the eighth column fills out to line 3000. Any suggestions?

Parents

0 Sandra Smith over 4 years ago

Hi Terry,

Is this using the Report Designer or another report - which one are you using? Also, if you are using the Report Designer are the sheets you are referring to the Hidden Sheets or are they sheets from which you created a report layout - if so, which sheet is not population past line 3000?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Sandra Smith over 4 years ago

Hi Terry,

Is this using the Report Designer or another report - which one are you using? Also, if you are using the Report Designer are the sheets you are referring to the Hidden Sheets or are they sheets from which you created a report layout - if so, which sheet is not population past line 3000?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Terry Bumgardner over 4 years ago in reply to Sandra Smith

Report designer. The sheet to which I am referring is a hidden sheet. It is the hidden sheet that is not populating past 3000.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Excel is not populating all of the data.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING