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!

Register Log in
  • Congratulations SkipVought 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. zhanghua

    Why does Impromptu display "#FORMAT#" when displaying different Dates?

    Format symbol Description General Shows the date value in the General format. D Shows the day of the week as one or two digits (1-31). DD Shows the day of the week as two digits (01-31). DDD Shows the day of the week as a three-letter abbreviation (Mon). DDDD Shows the full name of the day of...
  2. zhanghua

    Ima having a strange problem. When

    i have the problem you mentioned too. but i don't know . hope someone can help us.
  3. zhanghua

    Save as Excel...

    thank Simon Rouse for your hints. i find it.
  4. zhanghua

    Save as Excel...

    hi, all in impromptu, after opening the imr files,from "file"-> "save as",selecting "Excel With format". then it can work. in cognosscript, ExportExcel method can't save it with " Excel With format",it can only save it with "Excel...
  5. zhanghua

    impromptu issue

    Thanks for Griffin. now i slowly begin to accept your advise.
  6. zhanghua

    impromptu issue

    Thank you for Carm. and Griffin but as you said,"If so then just click one of the numbers in that column and then click the sum button on the tool bar, this will add all the numbers in that column and generate a grand total at the last row". i find it's only available when i select...
  7. zhanghua

    impromptu issue

    hi,guys i have a sql like this: select billingcyclid as month, sum(case when to_char(recstatchgdate,'YYYYMMDD')> to_char(add_months(to_date (billingcyclid||'25','YYYYMMDD'),1),'YYYYMMDD') then fee else 0 end) as mounts from...

Part and Inventory Search

Back
Top