Search results for query: *

I tried Madawc's solution, but Crystal Reports tends to freeze at "Accessing Database"? I'm thinking adding a 2nd table for JrnlHdr & JrnlRow is causing it to crash? Anyone know why this is?

@Turkbear, Yes, it's only under JrnlHdr. @Madawc, Ahhh...that makes so much sense. Don't see why I couldn't think of that. I'll try it from that angle and provide updates once I try. Thanks for your replies!

I'm currently using Peachtree Quantum Accounting 2012 with Crystal Reports XII. I'm trying to write a report that mainly shows 3 things: Ship By Date, Invoice number, & Invoice Date. I can get 2 of the fields to show, but not the 3rd. Below are the tables that are involved. JrnlHdr JrnlRow...

Kray4660, Worked perfectly! I'm still pretty new to this, a great learning experience. Thanks.

Hi crystalkiwibruce. Thanks for your reply. As I mentioned below, I already have a formula. I've copied below. whileprintingrecords; if {@Gross Profit} <>0 then {@Gross Profit}/Sum ({@Sales}, {LineItem.ItemID}) *-100 else 0 When I hit View > Print Preview, I can see all records and data...

I have a formula that helps with my division by 0 issue. Whenever I preview the report with data, everything comes out just fine. But when I try to export the report to excel, the division by 0 message pops up with the formula workshop. Is there something I'm missing? I am by no means an...

Thank you for your reply Turkbear. I can't believe it was just one check mark that held me up for the past few weeks. I kept reading on about how permissions between windows server and pt will affect the report. Thank you very much for your help. I probably would have went for weeks without...

Hello. We've recently updated Crystal Reports with Peachtree within our company and I'm starting to have trouble retrieving data from the database(our server - Windows Server 2003). When I try to preview the report in Crystal Reports the following pop-up windows surfaces. 1. Failed to...