Quickbooks and Crystal Report 9

[JD]

Hello Everyone, Is there anyway to customize QuickBooks reports using
Seagate Crystal Report 8.5 or 9. Some of the reports in QuickBooks looks
really ugly. Thanks for any feedback.

[Bob Alston]

You can customize most reports using capabilities built into Quickbooks.

--
Bob Alston

bobalston9 AT aol DOT com
"JD" <cg001@canada.com> wrote in message news:RQuzb.4772$bC.3207@clgrps13... Hello Everyone, Is there anyway to customize QuickBooks reports using Seagate Crystal Report 8.5 or 9. Some of the reports in QuickBooks looks really ugly. Thanks for any feedback.

[JD]

I would like to modify payroll report. Can someone help me how to do it?
(Using QB Pro 2003 with Payroll features CDN version)
I want to see following fields on the report and their totals:

Current Earnings:
Gross Income xxxxx
CPP xx
EI xx
Tax xxx
Net Income xxxx

YTD Gross xxxx
YTD CPP xxxx
YTD EI xxxx
YTD Tax xxxx
YTD Net Income xxxx
YTD Compnay CPP xxxx
YTD Company EI xxxx

How can I get this report for each employee. thanks in advance



"Bob Alston" <bobalston9@aol.com> wrote in message
news:7mvzb.58168$kl6.28756@fed1read03... You can customize most reports using capabilities built into Quickbooks. -- Bob Alston bobalston9 AT aol DOT com "JD" <cg001@canada.com> wrote in message
news:RQuzb.4772$bC.3207@clgrps13... Hello Everyone, Is there anyway to customize QuickBooks reports using Seagate Crystal Report 8.5 or 9. Some of the reports in QuickBooks looks really ugly. Thanks for any feedback.

[Guest]

"JD" <cg001@canada.com> wrote:
Hello Everyone, Is there anyway to customize QuickBooks reports usingSeagate Crystal Report 8.5 or 9. Some of the reports in QuickBooks looksreally ugly. Thanks for any feedback.

There's an ODBC driver from qodbc.com (I have no relationship with
this company) that lets any ODBC aware application like Crystal
Reports, etc, to interface with QB 2002 and later in real time - no
need to export data first.

Try it out and see if it can do what you're after. I also tried to use
Crystal Reports with QB for reporting, because the internal QB
reports, including its own report customization, are severely limited
and insufficient for even the simplest reporting a small business
needs, but I have a very hard time accessing the data I need with
Crystal Reports.

The driver is extremely slow and I haven't been able to do something
productive even with the small QB sample company files, let alone the
120MB files I planned to use Crystal Reports with. The internal QB
table structure is so convoluted that it will take some serious time
to figure out what table indexes you need to associate with each other
before you are able to put something on a piece of paper.

If you have intermediate to advanced experience with Crystal Reports
you may do better than me, in which case, please post back with your
findings.

==

[John Schmerold]

The slow driver is a big problem. I solved it by using QBFC2 to create
a Foxpro database. Then I was able to build flexible reports quickly.

nospam@invalid.com wrote: "JD" <cg001@canada.com> wrote:Hello Everyone, Is there anyway to customize QuickBooks reports usingSeagate Crystal Report 8.5 or 9. Some of the reports in QuickBooks looksreally ugly. Thanks for any feedback. There's an ODBC driver from qodbc.com (I have no relationship with this company) that lets any ODBC aware application like Crystal Reports, etc, to interface with QB 2002 and later in real time - no need to export data first. Try it out and see if it can do what you're after. I also tried to use Crystal Reports with QB for reporting, because the internal QB reports, including its own report customization, are severely limited and insufficient for even the simplest reporting a small business needs, but I have a very hard time accessing the data I need with Crystal Reports. The driver is extremely slow and I haven't been able to do something productive even with the small QB sample company files, let alone the 120MB files I planned to use Crystal Reports with. The internal QB table structure is so convoluted that it will take some serious time to figure out what table indexes you need to associate with each other before you are able to put something on a piece of paper. If you have intermediate to advanced experience with Crystal Reports you may do better than me, in which case, please post back with your findings. ==

[Guest]

John Schmerold <john@katy.com> wrote:
The slow driver is a big problem. I solved it by using QBFC2 to createa Foxpro database. Then I was able to build flexible reports quickly.

Do you mean you exported the data to a database first?

How did you create the Foxpro database? If you could describe the
steps in general maybe I can try to find out what I have to learn to
do the same thing. I don't have Foxpro but if you can create a Foxpro
database you can probably create an Access database too.

Although I'm mostly looking for a real-time ability to pull data from
QB for reporting, it will come in handy for less frequent reports.

Thanks for your time.

==