Showing posts with label lines. Show all posts
Showing posts with label lines. Show all posts

Monday, March 26, 2012

Duplicate Lines and Resources

I have a VB application with about 75 installations that uses the Crystal Control (Version 7.0) to print Crystal RPTs. On about 7 of these installations the clients are getting duplicate lines (usually on the last page or a single page report).
1) Using the same data (and reports) we cannot create this problem on any workstations execpt the 7 workstations that have the problem.
2) We do not think it a data problem, since we can clearly see in the [access] DB that there a 6 records, while the Crystal Report is clearly displaying 7 lines.
3) The report has 3 groups and the buplicates are with the detail records.
4) I have tried suppresion in the Section with
Whileprinting records;
previous(RecordId) = recordId

QUestions;
A) Are there any known resource requirements (Available Physical Memory/Available Virtual Memory/Page File SIze) limitaions anyone know of?
B) Any other ways in Crystal to attempt to resolve the problem?
C) ANY general suggestions, comments, or ideas?

ThanksDon't know why it's only on some clients, but what other tables is Crystal using? Try running Crystal's SQL on the DB to see if there's a join issue.
If a recordID really should be unique in the report then group on it and display in the group header/footer instead of the details section. This'll fix the symptom of any duplicate IDs, if not the cause of them.|||I have checking the links and am fairly confident this is not the cause, but it is worth another look. However, I will try the grouping suggetion; it sounds promising. THANKS!

Wednesday, February 15, 2012

DTS to SSIS

I've written thousands of DTS Packages with thousands of lines of ActiveX code which does thousands of things that would have been really simple in T-SQL.
How do I upgrade them to SSIS packages?
Do I need Visual Studio to do this?
Man it's slow todayi think that upgrade utility will come out right after they fix windows vista. anybody in Redmnond getting that sinking feeling?|||I've written thousands of DTS Packages with thousands of lines of ActiveX code which does thousands of things that would have been really simple in T-SQL.

How do I upgrade them to SSIS packages?

Do I need Visual Studio to do this?

Use Notepad :D|||Actually, I think this is only supported in Notepad Enterprise Edition.|||Install the The SQL Server 2000 DTS Designer, that's what I did.|||I was thinking about using cursors