RSS Feed
Knowledgebase : Reports and Letters

Collect! Member Center offers many training videos. The Basic Letter Setup video shows you basic letter setup, copying and modifying a letter, printer codes, margins and more. 22 minutes Select the link below to view the video. http://www.colle...
Collect! Member Center offers many training videos. The Basic Report Writing video shows you how to quickly modify existing reports, copy/import/export reports and presents tips and suggestions to get you started in Collect!'s Report Writer. 35 minute...
An interesting note about concatenation in the report writer: The math functions in the report writer can be used for concatenating variables by writing a regular equation with a plus sign. Changing the type of variable from an "numeric" to a "string"...
Collect! Member Center offers many training videos. The Creating A New Report Library video shows how to create a new report library and populates the library with sample reports from the Collect! website. 8 minutes Select the link below to view t...
Link to our CV11 on line sample reports. http://www.collect.org/cv11/Help/reports/index.html
Q. I am trying to find out how we delete a series of letters we no longer need that were created for a specific client. A. Select Print from the top menu bar and then select Customize Printing, Edit Report Templates When you are looking at the list o...
The following code will allowing printing Max 25 specific Transactions @de.tr no total @varST = XOXOXOXO @varST = @mm.yasoao if (@tr.ty = 101 .. 108 ) @varST = @mm.yasoao if (@tr.ty = 201 ) @varST = XOXOXOXO if (@varCNT > 25 ) @mm no total where (@...
Collect! Member Center offers many training videos. The Mail Merge video shows you how to use Mail Merge functions in Collect! to quickly produce professional mailing labels and custom documents. Several methods as demonstrated. 35 minutes Select t...
Using a Collect! report that redirects to a Word 2003 or 2007 template. You receive the "Opening this will run the following SQL command" message when you open a Word mail merge main document that is linked to a data source When you open a mail merg...
Q: Is there any way of making my reports run faster. Some of them take hours! A: There are several things that can make your reports run slow but one of the central issues is "indexed fields." If you have WHERE clauses in your reports, you should alway...