Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Moving an Excel Spreadsheet over to Crystal

Status
Not open for further replies.

obuspider

Programmer
Oct 31, 2002
78
0
0
US
I have a fairly complicated Excel spreadsheet that I need to move to Crystal Reports so info is recieved dynamically from a db. The following is a basic idea of what it needs to look like. The easy part is grouping by month and year to get the actuals. Is there a way to add the forecast info so it appears for right before the actuals, but only lists info for 02?

Forecast October 02 fcnumber fcnumber fcnumber
Variance from plan fcnumber fcnumber fcnumber

October 02 Actual # Actual # Actual #
October 01 Actual # Actual # Actual #
October 00 Actual # Actual # Actual #

Forecast Sept 02 fcnumber fcnumber fcnumber
Variance from plan fcnumber fcnumber fcnumber

September 02 Actual # Actual # Actual #
September 01 Actual # Actual # Actual #
September 00 Actual # Actual # Actual #

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top