Customized Crystal report format in vb.net

Question

5.00/5 (1 vote)

See more:

Hello everyone,

I am working currently on a project of student report card generation for a school.
Here i need to generate crystal report in dynamic form which is explained below:

1- There is a category combobox in which there are many categories
2- On category selection there comes subjects which could be more than one.
3- On subject selection there comes description of that subjects they could also be more than one.

Now when i select one category i.e. "Part 1- B " , there are 5 subjects , and in each subject there are 7 description.

Now what i need is dynamic and tabular format of crystal report generation.
i.e. like this.

Category - Part 1-B

Subject 1 Subject 2 Subject 3
Description 1 Description 1 Description 1
Description 2 Description 2 Description 2
Description 3 Description 3 Description 3
.... ... ...

Now these subjects,description are dynamic so i can make the controls in crystal report static..

Please help me what to do in this case , i m really stucked up please help me..

Thanks & Regards,
Krunal Panchal

Posted 2-Jul-11 3:36am

krunal25

Updated 7-Oct-17 1:32am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ganesan Natarajan · Answer 1 · 2011-08-24T18:51:00

Solution 1

Hi,

can u give ur table structure

then only we can proceed...

Posted 24-Aug-11 18:51pm

Ganesan Natarajan

Member 13449182 · Answer 2 · 2017-10-07T01:32:00

Private Sub BtnPreview_Click(sender As System.Object, e As System.EventArgs) Handles BtnPreview.Click
If CboItemGroup.SelectedIndex >= 0 Then

If RbtAll.Checked = True Then

Dim AllItemsDA As OleDbDataAdapter = New OleDbDataAdapter("Select Distinct * From stkrpt Where I_Group = '" & CboItemGroup.Text & "' Order By I_Code", DBConnect)
Dim AllItemsDS As DataSet = New DataSet

AllItemsDA.Fill(AllItemsDS, "stkrpt")

DGVPreview.DataSource = AllItemsDS
DGVPreview.DataMember = "stkrpt"

AllItemsReport.SetDataSource(AllItemsDS.Tables("stkrpt"))

Final.CRVItemsStock.ReportSource = AllItemsReport
Final.CRVItemsStock.Width = Final.Width
Final.CRVItemsStock.Height = Final.Height

Final.CRVItemsStock.Refresh()

Final.MdiParent = MDIParent1

Final.StartPosition = FormStartPosition.CenterScreen
Final.WindowState = FormWindowState.Maximized

Me.Hide()
Final.Show()

Final.PrintForm1.PrintAction = Printing.PrintAction.PrintToPrinter
Final.PrintForm1.Print()
End If
End If
End Sub