I am using Event Manager (KnowledgeSync) with Progression SQL to email customers an order acknowledgement. The event currently runs once per order. We would like this to re-trigger if the order changes, or if some items are backordered then re-trigger when the BO is filled.
Any ideas on how to...
Hi,
I have a database field that stores data like A,B,F,G.
I wrote a SQL stored procedure to parse that field into its parts:
A
B
F
G
I could schedule the proc but since it is only needed for this one report, can Crystal run the proc then the report?
I thought a SQL expression would work...
Crystal XI has a Dynamic Parameter option. Is there a way to do this in Crystal 10?
Example is a report on inventory item numbers. You want to give the user a choice of all items currently in the database. If you do a “Browse table/field” option when creating the parameter in Crystal 10, it...
Hi all,
I have some Crystal XI reports on a SQL 2000 database that have recently had a big drop in performance.
Database Type: OLE DB (ADO)
Provider: SQLOLEDB
The report have not been modified in about 8 months. It used to take about 30 seconds when run from an XP workstatation, now it takes...
Hi all,
I have a Crystal 10 report with a subreport. The main report has 3 groups with totals for each group. The subreport is identical, the difference is the where the data comes from.
The subreport is placed in the main reports footer (report footer a).
I added variables to pull the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.