-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...
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
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
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.