Click here to Skip to main content
14,209,923 members
Rate this:
Please Sign up or sign in to vote.
See more:
i have a 50 students records in one Student table of sql Server which contain all details regarding students given below.

Student name
Father Name
ROll No
Class name
Fee Amount

I Design RDLC Report as Student Fee voucher and also connect the database but when i click on generate Student fee voucher its show only one student record for ready to print but i want all students record will print separately in 50 pages or depend on number of student records on single click or it combine all fee voucher in one single file of pdf file.

What I have tried:

im trying to get solution from 25 days but no one help me also ask this question several time on this website also but no ony trying to help me..
please Solve this problem give me the Code.
VB.NET +SQL SERVER
Posted
Updated 12-Jun-19 2:10am
Comments
Richard MacCutchan 12-Jun-19 3:29am
   
No one is going to write your code for you. If you do not understand how RDLC reports work then look at the documentation. If you have some code that does not work, then show the code in your question and explain where the problem(s) occurs.
Naqash Younis 12-Jun-19 8:10am
   
im using this code but this code generate only one student record

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

<pre>  Public Function itemQillareport() As DataSet
        Dim dsData As DataSet
        Try

            dsData = DalHelper.ExecuteDataset(m_ConString, CommandType.Text, "SELECT dbo.MonthlyFeeGenrate.*, dbo.School_Info.* FROM dbo.MonthlyFeeGenrate CROSS JOIN dbo.School_Info where MonthlyFeeGenrate.registration_id='" & StidentFee.TextBox14.Text & "' and MonthlyFeeGenrate.Received_Fee='0' and  MonthlyFeeGenrate.Fee_Year='" & StidentFee.TextBox4.Text & "' and School_Info.Id='1'")
        Catch ex As Exception
            Return Nothing
        End Try
        Return dsData

    End Function
    

    Private Sub Employe_Led_report_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
       

        ReportViewer1.LocalReport.ReportEmbeddedResource = "KTC.Report38.rdlc"
            Dim rdsNumberofReferrals As New Microsoft.Reporting.WinForms.ReportDataSource()

            rdsNumberofReferrals.Name = "DataSet1"
            Dim dsBrands As DataSet = itemQillareport()
            rdsNumberofReferrals.Value = dsBrands.Tables(0)
            ReportViewer1.LocalReport.DataSources.Add(rdsNumberofReferrals)
            ReportViewer1.Update()
        Dim newPageSettings As New System.Drawing.Printing.PageSettings
        newPageSettings.PaperSize = New Printing.PaperSize("Custom", 820, 1150)

        newPageSettings.Landscape = True
        newPageSettings.Margins = New System.Drawing.Printing.Margins(30, 10, 10, 10)
        ReportViewer1.SetPageSettings(newPageSettings)

        Me.ReportViewer1.ZoomPercent = 90
        Me.ReportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent
        Me.ReportViewer1.RefreshReport()

    End Sub
   

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



Advertise | Privacy | Cookies | Terms of Service
Web02 | 2.8.190617.3 | Last Updated 12 Jun 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100