ver 7.6.100a Integrated Crystal Reports 2

[ultrav]

I am having a problem getting line comments to print on the Invoice, Quote and Acknowledgement forms - is anyone else using these ICRs? Do the comments print for you? They use subreports to print these and I can't figure out where the hold up is.

Thank you for any help.

Celeste

 

[dgillz]

Mine print no problem. Are you suppressing or conditionally suppressing the section where the comment subreports are?

A subreport in a supressed or conditionally suppressed section will not execute.

Also, check your subreport linking and record selection.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[MacolaHelp]

I have often found that the links to order line & header comments from the subreports are broken in the ICRs & have had to recreate them. If you place a support call to macola, they may have already corrected. If not, I can probably walk you through how to fix them.

 

[crystalreporting]

Do yourself a big favour and write your own reports instead of basing them on the Macola ICR's. Whoever developed the ICR's for Macola/Exact, did not prescribe to the 'KISS' way of thinking (keep it simple, stupid). In addition, the myriad of redundant UFL's is crazy, there's not a single one of those functions that can't be replicated with a simple formula. If you end up distributing, or web-enabling your reports, particularly on workstations without Macola installed, you'll wish you hadn't used Macola's ICR's, and the associated UFL's.

Peter Shirley

http://www.linkcorp.com

 

[ultrav]

MacolaHelp,

Thank you - I would appreciate a walk through - I have created quite a few reports(50+) but have little experience with subreports(and no formal crystal training). It appears that there are some parameter fields but I don't know how to tell if the data is getting passed to those fields.

Celeste

 

[dgillz]

Peter is right on about the UFLs and the difficulties in deploying this to a workstation that does not use Macola.

In fact, the only UFL I ever use in Macola crystal reporting is the NumberToDate() function.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[ultrav]

Peter, Dgillz

Thank you - in time I will probably rewrite theirs- was hoping to get by with theirs so I can work on more pressing matters.

Thanks for the info.
Celeste

 

[crystalreporting]

Yep, NumberToDate is the only 'UFL' I use as well. It's important to note that with versions 6 and 7 of Crystal, you had to distribute the NumberToDate UFL (U2LTDATE) to every workstation that needed to run a report that included the NumberToDate function. NumberToDate became a standard Crystal function with version 8 and above, so even this requirement went away.

Celeste, if you edit the subreport in the designer, you can refresh just the subreport - this will tell you if it's even picking up the right data. You can also comment out the subreport criteria, and gradually add the criteria back in (or re-establish links one at a time) to see what's happening. In other words, subreports are typically linked to a field value in the main report, but they don't have to be. If you remove all of the subreport links, then each order should print/display the comments for EVERY order (and every comment type). Then gradually introduce subreport links one-at-a-time, until you get the desired result. The links for open orders should be;

OEORDLIN_SQL.Ord_type = OELINCMT_SQL.Ord_Type
OEORDLIN_SQL.Ord_No = OELINCMT_SQL.Ord_No
OEORDLIN_SQL.Line_No = OELINCMT_SQL.Line_Seq_No

Then, the subreport should also have criteria to look at specific comment types - in most cases OELINCMT_SQL.Cmt_Type = "I"

Peter Shirley

http://www.linkcorp.com

 

[ultrav]

Thanks for all the help - got the quotes to work - unfortunately - the invoices are setup incorrectly(prints the line item comments and header comments in the same place - if an order has both line order comments will supersede order header comments UGH) - so will have to work on that a bit - at least I am getting practice with subreports!

Celeste

 

[dgillz]

Line item comment have a value of "L" in the cmt_type field, whereas header comment have a value of "H" there.

Write a record selection formula to restrict your subreport to the type of comments you want to see.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com