Search results for query: *

Thanks for you responses. Both formulas worked GREAT.

Backend: SQL Server 2000 Crystal Version: BO Crystal XI Is it possible to set up a formula that returns the last six months worth of data? I tried something like: {order.date} in DateTime (CurrentDate - 180) to DateTime (CurrentDate) But, the problem with that, is depending on when the...

Hi Steve, Thanks for your input. I'll have to give that a try or see what my limitations are with creating multiple views on one db. The other problem that I have is these two dbs reside on two separate servers, one application is "on demand"/hosted by an external company and the other...

Backend Database: SQL 2000 Crystal Version: XI Background Information: I'm trying to create a report that shows me ALL the parts and various attributes between two databases whether or not a specific part exists in one and not the other. Currently, I've been able to somewhat achieve what I need...

That was it. Thanks.

synapsvampire, Thank you for directing me in the right spot. However, when I added the formula field to my report, I still get the extra blank space (" ") where one of the Dim field's were null. Is there a way to exclude the "output:=output...." if the Dim field is null? My formula looks...

Backend: SQL Server 2000 Crystal Version: XI I have a total of 10 columns that I'm trying to concatenate; however, whether or not I concatenate 2, 4, 6, 8, or all 10 columns would depend if the source column is null. For example: My data consists of the following tables and columns...

Backend: SQL Server 2000 Crystal Version: XI I need to link two tables Cart.ItemID with Design.Serial_Number; however, they Data Types differ. Cart.ItemID is a Varchar and Design.Serial_Number is an Integer. Is it possible and if so, how do I do link/join the two tables in Crystal? When I...

Thank you synapsevampire. :-) That worked. Sorry I forgot to mention that I'm using Crystal Reports XI.

I know in Crystal that I can perform the following joins: - Inner Join - Left Outer Join - Right Outer Join - Full Outer Join Is it possible to perform a custom join similar to the following SQL join? SELECT * FROM CO_DOC JOIN Market_Type ON...

Thanks for the responses. I forgot to mention that I have a cross tab with Sales Rep (Rows), Discount (Column), Count of Discount and Count of Orders (Summarized Fields). In response to LBASS, I cannot exclude the records (Quotes) with no order info because that'll defeat the purpose of...

Database: SQL Server 2000 Application: Crystal Reports XI Background Information: I've created a report for Marketing that shows Win/Loss ratio bases on Quotes that turned into Orders. I've created a report that already has three groupings Calendar Month/Year, Sales Rep, and Discounted %...

In response to synapsevampire's question, "How do you know that these are dupes, because the company is the same? Seems like a bad criteria, could you never quote to the same company a second time?" In short, a quote from our company typically expires within 14 days. If a customer calls back...

Reporting Environment: BO Crystal XI SQL Server 2000 Reporting Issue: I’ve created a detailed sales/quote report that displays the Quote, Project, Discount %, Gross $, Net $. Then grouped the report based on three groupings listed below: • Group 1: Calendar Month • Group 2: Sales...