Full-page print with one record

[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 .

[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.

[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; }
    }

[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

[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.

[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

[Alex K.]

Hello,

You can use the master-detail-subdetail report.
Please see modified report in attachment.

Thank you.

[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 .

[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.

[lampson]

Haha, this is great.
Thank you very much .

There is also a problem, can i use GDI+ drawing on the page?