Search results for query: *

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...

I am using Crystal 10. The report is using OLEDB(ADO) connection to SQL. I have tried a SQL Expression using various syntax: Execute dbo.MyProc (Execute dbo.MyProc) (Execute [dbo].[MyProc]) The above results in "Incorrect syntax near Execute" or "Incorrect syntax near dbo." I was able to add...

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...

There are some sub-reports that have the Re-import option checked AND grayed out, so I can't uncheck. Any idea why? Unchecking the Re-import option on the other sub-reports has resulted in it opening a bit faster in developer. Still pretty slow when running though. Again, the report had not...

I'm coming into this 3rd hand so not sure exactly what may have changed on the workstation. I was thinking it could be related to some recent Windows auto-updates. All SQL stuff looks OK. This is actually a quote form so the data returned is very small (1 header recod plus X line records)...

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...

I was not the original author of the report but it looks like it needs a re-write. I tried moving the subreport to the main report header. Now, the subreport group variables pass values to the main groups but the value are just the last value the variable held. I will re-do with subreports for...

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...