Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal reports quote printing many pages when a formula referencing the bedryf table is added

Status
Not open for further replies.
kevvlol

kevvlol

IS-IT--Management
Jul 3, 2013
4
US
We're running Exact Macola v9.6.400 and Crystal Reports v14.0.4.738

I'm trying to have the logo on the crystal quote change depending on the company which seems simple but I am having some problems with it.

I took the default quote report and added the bedryf table, was warned there are multiple start points which should be fine since bedryf only ever has 1 record and can't be linked to anything (I think?) Logo1 is added with no suppression formula, prints just fine. When I add Logo2 with a suppression formula referencing bedryf (If {bedryf.bedrnr} = '001' then true) it will print more than just the specified quote.
 
Sort by date Sort by votes
Instead of including bedryf in the main report, why not add it as a non-linked subreport? You can then control what is displayed within the subreport and it wont increase the number of records in the main report.

Peter Shirley
Macola Consultant, PA and surrounding states.
 
Upvote 0 Downvote
Actually the method Peter suggested is exactly the way that Exact suggests that do this. I will try to upload an example later. What are you doing, pick tickets, invoices, packing lists? Please advise.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:
 
Upvote 0 Downvote
Thanks for the advice, I will take another look at this when I get some time.

@dgillz, I am only worrying about the quote at the moment (MACOEQTEFRM.rpt.)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

prog_0927
  • Locked
  • Question
Macola inventory Tag count Process How Many Days Open?? 2
Replies
2
Views
1K
dgillz
dgillz
mjbasecamp
  • Locked
  • Question
What is the highest version of SQL Server 2017 CU that Macola Progression 7.9.300 is compatible with
Replies
3
Views
520
dgillz
dgillz
prog_0927
  • Locked
  • Question
Journal Source SQL Table
Replies
9
Views
822
dgillz
dgillz
prog_0927
  • Locked
  • Question
Status on APOPNHST_SQL Table
Replies
1
Views
350
dgillz
dgillz
nsiegmundt
  • Locked
  • Question
How to edit the "search_desc" field for an item inside of macola (table imitmidx_sql)
Replies
1
Views
398
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top