Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

No Drill-Down Error

I have a report that you cannot go past about page 16. When you try to go past page 16 the report opens up the Select Expert for Group Footer 2 highlighting {@Month 1} as being an error. There is no error message that says what's wrong or anything. It just opens up and highlights {@Month 1}. My select expert has the following formula.

if {?Pallet ><} = "Show Pallets Less Than 1" then

{@Month 1} > .99 else if //Yes, this is backwards but you have to do it this way because Crystal suppresses the opposite of what you want.

{?Pallet ><} = "Show Pallets Greater Than 1" then

{@Month 1} < .99

// Show Pallets less than one means to suppress pallets greater than one.

The formula for {@Month 1} which is just a regular formula I've created.

if {dim_Date.FiscalMonthNBR} = {Command.Previous Fiscal Month} and

(tonumber(Maximum ({vw_dim_Product.CA_MPN_JMelBoxesPerPallet}, {@upc}))) <> 0 then

Sum ({fct_CurrentSales.Cases}, {@upc}) /

(tonumber(Maximum ({vw_dim_Product.CA_MPN_JMelBoxesPerPallet}, {@upc})))

/ {Command.Prev Mo Week Count} else

if {dim_Date.FiscalMonthNBR} = {Command.Previous Fiscal Month} and

(tonumber(Maximum ({vw_dim_Product.CA_MPN_JMelBoxesPerPallet}, {@upc}))) = 0 then

0

Anyone know why this isn't working and maybe how to get around this?

The report will also not export because it gets stuck on the page after page 16, and again opens up the Section expert for Group Footer 2 and highlights the {Month 1} like I said above.

Thanks

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question