SQL Db/Crystal Reports admins

Discussion in 'Off Topic' started by iMacattack, Sep 26, 2007.

  1. iMacattack

    iMacattack busy, too busy

    4,673
    186
    2,268
    Any SQL/Crystal Reports gurus here? Trying to figure out something simple... I think...

    Quick Overview...

    We have a MIS system that imports XML data from another system. In one of the fields we sometimes get html charter returns like [&] without the [] While this has no effect on our SQL Db or the MIS app that reads the SQL Db, when we print a Crystal Report it shows on the report and confuses the user. Is there a way in Crystal to scrub out those misc codes but leave the actual data we need?

    Thanks
    Jan
     
  2. tom_in_orl

    tom_in_orl Founder of Microskiff, Member of the Gheenoe Army

    I am out. I am missing the gene that helps understand SQL. I have also purposefully avoided Crystal Report training because of what management has done to those people in the past. (report whores :-* )
     

  3. iMacattack

    iMacattack busy, too busy

    4,673
    186
    2,268
    wusss...  ;D

    That's ok I get paid good money to sit around  and [smiley=1-computergeek.gif] for a few minutes then do [smiley=hmmm.gif]
    for an hour or so while looking at [smiley=computer-ebay.gif] or replying to [smiley=computer-email-sent.gif].

    Hehehe
     
  4. MATT

    MATT Well-Known Member

    (Report it shows on the report and confuses the user)

    More then just the user is confused here.....
     
  5. iMacattack

    iMacattack busy, too busy

    4,673
    186
    2,268
    sorry... :D sometimes I type redundantly redundantly :-? ;D
     
  6. captnron

    captnron Guest

    Hunh?, Hunh? ;D ;D
     
Loading...
Similar Threads Forum Date
Any water clarity reports for Anna Maria/Longboat Key General Discussion Aug 30, 2017
I don't see a lot of Louisiana reports Fishing Reports Aug 2, 2017
Recent reports on the 10k islands? Fishing Reports Jun 30, 2017
Any reports for the lower keys? Fishing Reports Apr 25, 2017
Biscayne reports? Fishing Reports Oct 12, 2015