Last post Jun 30, 2011 11:40 PM by salman behera
Jun 24, 2011 07:24 AM|salman behera|LINK
i using crystal report but face one problem.problem is when i print my report that time user wants report should print only data not blank space of a page.
currently,when i print a report then it is print a long page in which half data and half blank.
for example,suppose data is like
item qnty price
chicken 2 20
motton 3 60
.....Thank you.... like this.
and user want in print out that much paper should print(up to ...Thank you...) and then stop out paper.but currently,when my print start it print data as well as
half blank paper which totaly valueless.
so is it possible to prevent print blank space in end of one page?
pls help me,i am very new in report.
my code is like
Dim STR As String
STR = "SELECT * FROM V_NEWBILL WHERE Fbill_no='" & billno & "'"
Dim DT As New DataTable
DT = RetTable(STR, strCON)
Dim objREP As New RPT_FoodBill
CrystalReportViewer1.ReportSource = objREP
Jun 24, 2011 07:41 AM|hassanmehmood|LINK
You should set an appropriate page layout for your report.
Click on the blank part of reportfrom where select its report design (or something like it) and choose Page Setup, I think if data is not much you can choose A4 (Portrait) paper for it.
Moreover, the printed page can't be cut or shortened. So if your report is having (suppose) 3 lines of data then the page will show the blank part below.
Hope this helps..
Jun 24, 2011 07:54 AM|salman behera|LINK
Thank you hassanmehmood for your quick replay.actually,i design a report for a resturant.so previously,they working in a DOS based project.so,
they want report only data not full page which half blank.
so what yo do for or what is the best solution for it?
is there any printer setting?
pls help me.
Jun 27, 2011 12:55 AM|salman behera|LINK
someone help me please.
Jun 29, 2011 11:44 PM|necro_mancer|LINK
I believe you can try Microsoft Reporting Service as an alternative to Crystal Report.
If you still want to use Crystal Report, you must find a way to adjust your printer settings
Jun 30, 2011 02:18 AM|Munish.Bhargav|LINK
I am not sure what you actually want to active.
But if you want to redce the extra space between the lines that you shown. then move the detail section near to filelds
If you are facing the problem that summation is coming on the bottom of the page. then
Remove all the code from the bottom section and create new section where you can place the summery of your products.
Its very simple.
If have further query then let me know.
Jun 30, 2011 11:40 PM|salman behera|LINK
i just want that much paper should print as i show it page and also paper in same not extra paper should comeout.
is it possible?
if no!then could you show me the another way?