Search results for query: *

I have a simple report wherein I get the customer credit status from FP (a sql database) and from our accounting software SBT (a foxpro db), and compare them side by side. When I open it up and refresh the data the first time, it works fine. I had SBT running in the background, but not FP. So...

Infobabe, I made a formula for the column and named it &quot;sortbalances&quot;. This is the formula: if {armast10.balance} < 0 then &quot;negative&quot; else if {armast10.balance} < 1000 then &quot;1-1000&quot; else if {armast10.balance} < 2500 then &quot;1001-2500&quot; else if...

Thanks for all the responses, even though they weren't what I had wanted to hear. :)

Ken, Thanks for the lightning fast response! :) I do have a finite number of products (about 50) and I've already done the first thing you suggested and it works fairly well. The reason I wanted a cross tab was so that I could break out the product requests into calendar quarters across the...

I am using Crystal 8.0 which connects to my db via ODBC. I have a field with multiple values separated by commas. What I want to end up with is a cross tab. data: record1: product1, product2, product3 record2: product3, product4, product5, product6 record3: product1, product6 record4: product7...

I want to print out the details of what makes up my crosstab because it has multiple criteria. When I use the print/export/report definition, it doesn't print out what's behind the crosstab. Is there a way to do this? Thanks.

Kersten, Try turning off auto-smart-link before you open up the tables, that won't create all the links that you think might be causing CR to lock up. It's in File/Options. Kelley

Would that it were that easy. :) In each record in the comment table, there's a field for sales order number, and a field for the comment text. So if there are no comments on a particular order, there are no entries for that sales order in the table. A typical SO has comment, blank line...

I have a sales order with 6 comment lines available to use. I only want to select a sales order if ALL 6 of the comment lines do NOT start with the letter Q. How can I do this in Crystal 8?