How to schedule a report to print based on a condition?

[javedi]

Hi

Does anyone know if it would be possible to schedule a report to print if it has met a criteria.

The report i am working on has a running total, if the total meets the 500 or above criteria it should print in Crystal Entperise. I have other reports scheduled to print based on day, but this is based on a condition.

Any ideas welcomed.

Thanks,
Javedi

CRv10

 

[DataDog]

I did something like this a while back. I found the solution here on TT and now I can't find it. In my case, I wanted a CE Report to Fail, and not send an email adobe attachment if there were no record in the report. (Don't email a blank document) For you: Basically put a totally blank 1st page (RHa)and do a 'new page after' in that section. Have the 'real' report start on page 2. In every future Report Header section (RHb+), Group Header, Footer, detail, put a conditional supression when your running total is not met. In CE, don't print all pages, but print in a range of 2 to ...(something larger than your biggest report). If CE can't find page 2, it will fail and nothing will print out....It worked for me, hope my theory works for you.

DataDog
If God wanted us to count in Hexadecimal, then why did he only give us A fingers?

 

[IdoMillet]

DataDog,

The approach you describe works for conditions that can be evaluated early enough (in report passes) to be used for property expressions.

However, the condition Javedi is describing is based on a running total, which gets evaluated too late in the report passes.

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[IdoMillet]

Javedi,

Frequently, there are ways to convert running totals to simple totals by creating a conditional detail level formula and then applying a simple sum to that formula.

If you describe your running total, it would be easier to give more guidance.

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[javedi]

Thanks for you input on this Guys,

I haven't started creating the report, i'm happy to implement a simple total to get the report working. In essence all i want to do is get the report to print when a target of 500 or more is achieved. I'm happy for a basic formula or idea to get me going.

DataDog, Can you provide more info. I don't understand the theory.

 

[DataDog]

The Theory is : Force a Scheduled report in Crystal Enterprise to FAIL when a condition is/is not met. Then follow the directions in my original post. And I agree with Ido, running totals won't work but straight Sums (Grand Totals) should.

DataDog
If God wanted us to count in Hexadecimal, then why did he only give us A fingers?

 

[javedi]

Thanks DataDog,

Can you offer further advice on how i can create a conditional supression?

Javedi

 

[DataDog]

Have your Grand Total created and in the report footer.

Go to Report / Section Expert. For RHb (remember RHa is a blank page) Next to Supress there is a "X+2". Click on it. enter your "Sum(yourtable.field) < 500" information. Do this for every other Group Header, Footer, Detail below the RHa.

DataDog
If God wanted us to count in Hexadecimal, then why did he only give us A fingers?