cancel
Showing results for 
Search instead for 
Did you mean: 

Self Updating Report of Open Sales Orders (Maybe Crystal )

Former Member
0 Kudos

I want a self updating report of Open Sales Order. I want it to refresh constantly. I know that it could be an alarm but it would be executed every # minutes and dont want to. Any ideas ? I dont know Crystal Reports enough but is it posible ?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

If you need all open sales orders, it would be easy to find solution by XL reporter. You just need a report job to list all open sales orders in a predefined duration.

Thanks,

Gordon

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

Create a query similar to open sales order , put in alert ..every second ... set up alert management in one minute

under administration > system initlisation > general setting

update message every min ...

I don't think you can do it through crystal report

Hope this helps

Bishal

Edited by: BIshal Adhikari on Nov 12, 2009 2:20 PM

Former Member
0 Kudos

Can these alert tax too much the SQL Server ? Make it slow ?

Former Member
0 Kudos

Hi ,

If I were you , I will not be crazy looking at my sales order in every 1 minutes ..I would train my users to check at least 15 minutes.

I understand what u are trying to do;you want that customer will see the latest open SO created ..but 15 minutes is good enough time .

I think you have to check if database size grows up big time ..so far no report has come to me from my clients for this set up .

make sure you are not saving an alert into database

If you are using multiple alerts , I will atleast monitor my database for a while to see i encounter performance issue ..

So far for one alert at every 15 minutes ..i think u should be fine ..

Hope this helps

Bishal

Former Member
0 Kudos

It cannot be more than 2 minutes time...

Former Member
0 Kudos

Hi Hector ,

You will be fine even if you do for 2 minutes ..

Thank you

Bishal