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 TouchToneTommy 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. angiole

    Formatting all line objects at once Crystal v10

    Yes, Thanks. Of course, now all the object s are overrighting each other. V 8.5 had a clunky feature that basically reformatted the entire report line. It doesn't appear to be part of v 10. Any ideas? AA 8~)
  2. angiole

    Formatting all line objects at once Crystal v10

    Good afternoon experts. Having been certified in another reporting tool, I'm feeling a little disappointed in what CR 10 does when formatting objects on a detail line. Basically, the widths of all the objects narrow when there isn't enough room on the page in portrait. I change the print...
  3. angiole

    BW Tabel relationships

    Good morning, Is anyone able to supply information or a resource publications that would demonstrate the relationship between the various table in BW? Thanks AA 8~)
  4. angiole

    BW / Bex Table relationships

    Good Morning Experts. I was able to successfully browse the SQL of a Bex query (transaction RSRT1), copy and tweak it to run in SQL*Plus(Oracle). Since the tables to the cube in question are normalized ad nauseum, I need to get to the next level of tables and joins to retrieve real data, and...
  5. angiole

    SAPDB SQLStudio setup

    Good Morning All, New to SAP, but from a data warehousing background with extensive knowledge in data structures/bases and Oracle SQL. I would like to connect to SAP via the available SAPDB odbc available on the net. I downloded a tool called SAPDB SQLStudio which would appear to provide for...
  6. angiole

    Finding the SMTP server name for BLAT

    Thanks for all the help AA AA 8~)
  7. angiole

    Finding the SMTP server name for BLAT

    Thanks John. I'm afraid you need to walk me through this. As I understand port 25 is a default and not a requirement. How do I run a port scanner against port 25 to check if it's open? If SMTP is not set up, could I get a free one? Just asking... AA 8~)
  8. angiole

    Using BLAT to automate EMail

    Thanks strongm This is a typical LAN environment, so is the server on the LAN, my guess is yes, and outlook 2002 is the desktop client. I responded with the ping message before in case someone might find it useful in answering the question. Hope helps. AA AA 8~)
  9. angiole

    Using BLAT to automate EMail

    Thanks, The question is how do I find this piece of information. I ping localhost and it provides the following: Pinging nca6762633e.drhc.com [127.0.0.1] with 32 bytes of data Is this the server name? Thanks again AA 8~)
  10. angiole

    Finding the SMTP server name for BLAT

    Hello, I'm posting this item here because a keyword search revealed a lot of expertise for this item was in this forum. PROBLEM: ======== I am attempting to use BLAT to batch email. We are an exchange environment, and BLAT requires the smtp address. I entered the following...
  11. angiole

    Using BLAT to automate EMail

    Hello, I'm posting this item here because a keyword search revealed a lot of expertise for this item was in this forum. PROBLEM: ======== I am attempting to use BLAT to batch email. We are an exchange environment, and BLAT requires the smtp address. I entered the following...
  12. angiole

    VBScript Focus() or Click() with Access Data Pages

    Good Afternoon, First some history ... Moved into a new assignment where I'm presenting Access data using Access Data Pages. So forgive me ahead of time for perhaps not asking my question properly. The Access (2000) wizard created what I needed and I've modified the layout for our groups' use...
  13. angiole

    Problem with subquery performance !!!

    You might try to change the 'Select *' for the subquery to 'Select 'x''. AA 8~)
  14. angiole

    Export of Report data to delimited format

    Thanks for the input, much appreciated. AA 8~)
  15. angiole

    "Prompt Values Not Available"

    Yes, even giving the prompt a name, but problem persists. AA 8~)
  16. angiole

    "Prompt Values Not Available"

    Good suggestion, But since I can't downgrade it (no there aren't previous versions), I don't think I can re-upgrade it... Thanks anyway for the tip... AA 8~)
  17. angiole

    Rplace sql query

    If your dbms is Oracle you may try: select Column1, replace (Column1,'A','Z') New_Column1 from tablex Giving: Column1 New_Column1 --------- ----------------- ABC ZBC CDB CDB XYZ XYZ AAA ZZZ Cheers AA 8~)
  18. angiole

    User Defined Functions ( Oracle ROWNUM )

    Thanks again Dave, My current assignment doesn't have the access to Cognos Support, so you're including the code was good foresight ... AA 8~)
  19. angiole

    User Defined Functions ( Oracle ROWNUM )

    Good Afternoon, Has anyone successfully implemented the ROWNUM feature for Oracle queries into the User Defined Functions. I can't more specific into why it doesn't work here except to say that even when I get it to appear in the report functions list, I can't use it. Thanks in Advance. AA 8~)
  20. angiole

    "Prompt Values Not Available"

    Good Afternoon. After a fresh install of Imp 6.0 Admin on my workstation, a previous problem has reared its ugly head again. The initial prompt value for a report works fine, but any subsequent attempts to action the prompt again greets me with the above message, (with no further info)...

Part and Inventory Search

Back
Top