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!

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

Search results for query: *

  1. aksm47

    OLAP Campaign Management Solution.

    Personally, I need to create an OLAP solution for Campaign Management. For example: Group 1: I need to select a group of people who buy Apple Group 2: I need to select a group of people who buy Orange. If John Smith bought Apple and Orange, he should only exists in Group 1. My question is...
  2. aksm47

    Crystal Report 9 failed to Connect OLAP

    Hi all, I have a problem connecting to OLAP from Crystal Report 9. When I go to Database Expert => Create New Connection => OLAP and try to Add Server, the following errors occurs: "Failed to acquire a list of server types. Reason for failure: "ParseDisplayName failed" Does anyone know...
  3. aksm47

    Crystal Report 9i -- How to display zero in Weighted Average

    The weighted average is from the "Summary" of crystal report. I have no control on it, it just automatically changed the values into empty. Is there any way to set the option for "Summary" function in crystal report that could resolve this? Thanks. -AK
  4. aksm47

    Crystal Report 9i -- How to display zero in Weighted Average

    Hi, I have a problem in displaying zero for the Weighted average that has zero for denominator. Right now, my report display "Empty" values for the weighted average column (Response Rate). e.g. Mail Response Response Rate 100 50 0.50% 0 0...
  5. aksm47

    How to tranpose data?

    Thank you very much. I have tried both methods and they worked great. thanks.
  6. aksm47

    How to tranpose data?

    Hi all, I would like to know how to effectively transform <TABLE 1> into <TABLE 2> <TABLE 1> ID | PRICE 1 | $2 1 | $3 1 | $4 2 | $5 2 | $6 3 | $7 <TABLE 2> ID | PRICE_1 | PRICE_2 | PRICE_3 * 1 | $2 | $3 | $4 2 | $5 | $6 | NULL 3 | $7 | NULL | NULL *The number of...

Part and Inventory Search

Back
Top