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: *

  • Users: mathews1
  • Content: Threads
  • Order by date
  1. mathews1

    thread767-711462 - IF CONTAINED FROM PARAMETER

    -crystal report 9 -SQL SERVER I tried to pull items using instruction in thread767-711462. it works fine if I am pulling with one descrete value but it doesn't work if I am using multiple values or range of value. if I am changing prameter from descrete value to range or multiple values, it is...
  2. mathews1

    exporting SQL DATA TO EXCEL

    I want to export sql data output to excel but resultant lines are more than 1.5 millions but excel sheet can handle upto 65000 lines in one sheer. Is there any way that I can transfer upto 65000 lines in one sheet and 65001 and onwards move to next sheet and so on please help? -g
  3. mathews1

    thread632-701316 - posting in closed year in POP/SOP/INV

    As per thread632-701316, we can enter transactions in sub modules also for closed year. MY question is, if we enter transacitons in POP/SOP module for closed year then would it update vendor summary and customer summary windows for YTD,LTD Figures also or not -g
  4. mathews1

    RECIEVED BUT NOT INVOICED REPORT IN CRYSTAL

    I am trying to make crystal report for recieved but not invoiced report. I am using POP10500 AND POP10600 as main tables. What are other tables that I can use. I am not able to understand qty invoiced and qty matched fields in POP10500 Thanks -G
  5. mathews1

    thread632-875655

    lUVSQL: Just a thought, it may help in valuing qty and cost. use table IV30300,IV30200,BM30200,POP30300,SOP30200 to pull quantities and cost from there for historical stock status report. -G

Part and Inventory Search

Back
Top