How to print many pages that I can enter
Hi Everyone, I have a problem to ask. I want to print a report that I can enter a number.
If I enter 2, and print 2 pages report the same.
If I enter 3, and print 3 pages report the same.
I use Maskedtextbox in dialog and it can enter number.
the information is in database , and I use SQL command to select data.
I post a part of code like below:
namespace FastReport
{
public class ReportScript
{
private void Page1_StartPage(object sender, EventArgs e)
{
int count ;
count = Convert.ToInt32(MaskedTextBox1.Text);
count = int.Parse(MaskedTextBox1.Text);
int yy,mm,dd;
string cyy,cmm,cdd,str;
TableDataSource HDS = Report.GetDataSource("HDS") as TableDataSource;
str = "declare @i varchar(10) "+
"set @i= "+count+
" while(@i>0) "+
" begin "+
"SELECT a.*,b.* from t_ordhad as a "+
"left join t_orddel as b on a.shtno = b.shtno "+
"where a.shtno = "+Report.GetColumnValue("HDS.shtno").ToString().Trim();
str = str+ " set @i=@i-1 end";
HDS.SelectCommand = str;
HDS.InitializeComponent();
HDS.Init();
}
}
}
but it can't run. Is there any parameter or function I can change the page count?
Thanks a lot!
If I enter 2, and print 2 pages report the same.
If I enter 3, and print 3 pages report the same.
I use Maskedtextbox in dialog and it can enter number.
the information is in database , and I use SQL command to select data.
I post a part of code like below:
namespace FastReport
{
public class ReportScript
{
private void Page1_StartPage(object sender, EventArgs e)
{
int count ;
count = Convert.ToInt32(MaskedTextBox1.Text);
count = int.Parse(MaskedTextBox1.Text);
int yy,mm,dd;
string cyy,cmm,cdd,str;
TableDataSource HDS = Report.GetDataSource("HDS") as TableDataSource;
str = "declare @i varchar(10) "+
"set @i= "+count+
" while(@i>0) "+
" begin "+
"SELECT a.*,b.* from t_ordhad as a "+
"left join t_orddel as b on a.shtno = b.shtno "+
"where a.shtno = "+Report.GetColumnValue("HDS.shtno").ToString().Trim();
str = str+ " set @i=@i-1 end";
HDS.SelectCommand = str;
HDS.InitializeComponent();
HDS.Init();
}
}
}
but it can't run. Is there any parameter or function I can change the page count?
Thanks a lot!
Comments