Full-page print with one record
Posted: Mon Apr 11, 2011 6:17 am
by lampson
Hi,
I have two tables, t1(classid,name),t2(studentid,name,classid),i have been using t1.classid and t2.classid to created a relationship.
I would like to fill a page with one class and student data .
Thank you .
Full-page print with one record
Posted: Mon Apr 11, 2011 7:29 am
by Ivan
Hello,
Sorry, maybe we did not exactly understood your question. Could you explain your issue in more details. And, if possible, send us a sample.
Thank you.
Full-page print with one record
Posted: Mon Apr 11, 2011 7:49 pm
by lampson
I hope all the work of a student to print page.
Thank you very much .
This is the code:
Code: Select all
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
List ClassList = new List();
ClassList.Add(new ClassInfo("1", "Class"));
ClassList.Add(new ClassInfo("2", "Class2"));
ClassList.Add(new ClassInfo("3", "Class3"));
ClassList.Add(new ClassInfo("4", "Class4"));
ClassList.Add(new ClassInfo("5", "Class5"));
ClassList.Add(new ClassInfo("6", "Class6"));
List WorkList = new List();
WorkList.Add(new WorkInfo("1", "Work1"));
WorkList.Add(new WorkInfo("2", "Work2"));
WorkList.Add(new WorkInfo("3", "Work3"));
List StudentList = new List();
List ScoreList = new List();
foreach (ClassInfo cls in ClassList)
{
int num = new Random().Next(0, 25);
for (int i = num; i > -1; i--)
{
StudentInfo student = new StudentInfo(cls.ClassID + i.ToString("0000"), cls.ClassName + i.ToString(), cls.ClassID);
StudentList.Add(student);
foreach (WorkInfo work in WorkList)
{
ScoreList.Add(new ScoreInfo(work.WorkID, work.WorkName, student.StudentID, new Random().Next(0, 100)));
}
}
}
Stimulsoft.Report.StiReport r = new Stimulsoft.Report.StiReport();
r.RegData("ClassList", ClassList);
r.RegData("StudentList", StudentList);
r.RegData("WorkList", WorkList);
r.RegData("ScoreList", ScoreList);
r.Design();
}
}
public class ClassInfo
{
public ClassInfo(string classid, string classname)
{
ClassID = classid;
ClassName = classname;
}
public string ClassID { get; set; }
public string ClassName { get; set; }
}
public class StudentInfo
{
public StudentInfo(string studentid, string name, string classid)
{
StudentID = studentid;
StudentName = name;
ClassID = classid;
}
public string StudentID { get; set; }
public string StudentName { get; set; }
public string ClassID { get; set; }
}
public class WorkInfo
{
public WorkInfo(string workid, string workname)
{
WorkID = workid;
WorkName = workname;
}
public string WorkID { get; set; }
public string WorkName { get; set; }
}
public class ScoreInfo
{
public ScoreInfo(string workid, string workname, string studentid, int score)
{
WorkID = workid;
WorkName = workname;
StudentID = studentid;
Score = score;
}
public string WorkID { get; set; }
public string WorkName { get; set; }
public string StudentID { set; get; }
public int Score { set; get; }
}
Full-page print with one record
Posted: Mon Apr 11, 2011 7:52 pm
by lampson
This is the design file:
ClassList
ClassID,System.String
ClassName,System.String
_ID,System.Int32
_Current,System.Object
ClassList
ClassList
StudentList
StudentID,System.String
StudentName,System.String
ClassID,System.String
_ID,System.Int32
_Current,System.Object
StudentList
StudentList
WorkList
WorkID,System.String
WorkName,System.String
_ID,System.Int32
_Current,System.Object
WorkList
WorkList
ScoreList
WorkID,System.String
WorkName,System.String
StudentID,System.String
Score,System.Int32
_ID,System.Int32
_Current,System.Object
ScoreList
ScoreList
EngineV2
None;Black;2;Solid;False;4;Black
Transparent
Transparent
0,0.4,13,0.8
Bottom;Black;1;Solid;False;4;Black
Transparent
True
0,0,6.4,0.8
Arial,8
0,0,0,0
DataClassList_ClassID
{ClassList.ClassID}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Bottom;Black;1;Solid;False;4;Black
Transparent
True
6.4,0,6.6,0.8
Arial,8
0,0,0,0
DataClassList_ClassName
{ClassList.ClassName}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
ClassList
DataClassList
Transparent
0,2,13,0.8
Transparent
True
0,0,6.4,0.8
Arial,8
0,0,0,0
DataStudentList_StudentID
{StudentList.StudentID}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Transparent
True
6.4,0,6.6,0.8
Arial,8
0,0,0,0
DataStudentList_StudentName
{StudentList.StudentName}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
StudentList
DataStudentList
Transparent
0,3.6,13,0.8
Transparent
True
0,0,6.4,0.8
Arial,8
0,0,0,0
DataScoreList_WorkName
{ScoreList.WorkName}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
Transparent
True
6.4,0,6.6,0.8
Arial,8
0,0,0,0
DataScoreList_Score
{ScoreList.Score}
Black
HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
Center
ScoreList
DataScoreList
6ff396ded28042a38178c0302173d35f
1,1,1,1
Page1
10
15
Arial,100
[50:0:0:0]
System.Dll
System.Drawing.Dll
System.Windows.Forms.Dll
System.Data.Dll
System.Xml.Dll
Stimulsoft.Controls.Dll
Stimulsoft.Base.Dll
Stimulsoft.Report.Dll
Report
4/12/2011 8:47:30 AM
4/12/2011 8:43:38 AM
fadedee3bbc2460b8568de245cc8c658
Report
Centimeters
2010.1.700
using System;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using Stimulsoft.Controls;
using Stimulsoft.Base.Drawing;
using Stimulsoft.Report;
using Stimulsoft.Report.Dialogs;
using Stimulsoft.Report.Components;
namespace Reports
{
public class Report : Stimulsoft.Report.StiReport
{
public Report()
{
this.InitializeComponent();
}
#region StiReport Designer generated code - do not modify#endregion StiReport Designer generated code - do not modify
}
}
CSharp
Full-page print with one record
Posted: Tue Apr 12, 2011 1:17 am
by Andrew
Hello,
Thank you for the information you have sent.
However we still cannot understand the following phrase:
I would like to fill a page with one class and student data.
What do you mean by this? Could you explain this in detail. And. if possible, send us a sample or screenshot of a structure how a report mustd look like.
Thank you.
Full-page print with one record
Posted: Tue Apr 12, 2011 1:30 am
by lampson
About the style:
ClassID:1 ClassName:Class1
StudengID:0001 StudentName:Class20
Work Score
Work1 32
Work2 57
Work3 99
one page shows one student's work .
Thank you for your answer
Full-page print with one record
Posted: Wed Apr 13, 2011 2:19 am
by Alex K.
Hello,
You can use the master-detail-subdetail report.
Please see modified report in attachment.
Thank you.
Full-page print with one record
Posted: Wed Apr 13, 2011 5:38 am
by lampson
Hi.
Your report is to show the work more than one student , but, i hope one page shows one student's work in printting ..
Thank you .
Full-page print with one record
Posted: Thu Apr 14, 2011 1:53 am
by Alex K.
Hello,
You can put Header band on page and set the NewPageAfter properties to true.
Please see the modified report in attachment.
Thank you.
Full-page print with one record
Posted: Thu Apr 14, 2011 5:04 am
by lampson
Haha, this is great.
Thank you very much .
There is also a problem, can i use GDI+ drawing on the page?