Crystal in Sleep or Wait Mode

[kskid]

Crystal 8.5 with Oracle 8.16 using Oracle ODBC connectivity

I currently have a simple report that counts the number of people on V_$SESSIONS at the top of each hour. It also means that I must run the report 11 times a day with 11 reports to capture the numbers I need to update an Excel spread sheet for graphing

Is there a way I can create a formula or loop that will run a subreport or count once an hour?

 

[dgillz]

If youhave a report that does this on demand, I would buy a crystal reports scheduler such as Ido Millet's Visual CUT. Check it out:

http://www.millettsoftware.com

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[kskid]

The report is on a scheduler with hourly option. I just want to create one report, not 11.

 

[fredp1]

I would approach it from the db end.
Create a sp that captures the info to a table with a some sort of a key, like datetime.
Then schedule the report in Orcale to run every hour.
Crystal can report from that table and do the graphing.
That way you can also eliminate Excel from the reporting process.




Cheers
Fred

 

[kskid]

Thanks Fredp1,

I'll get with my dba and see if I can get something going.