subreport in rdlc only shows for one record in master

I have a report that shows expenses and a sub report to show all payments against expenses.and this is how i am passing data to master and sub report

         Dim datasource As New ReportDataSource("Expenses", Ds.Tables(0))

        Me.ReportViewer1.LocalReport.ReportPath = "../../Reports/Expenses.rdlc"

        Me.ReportViewer1.LocalReport.ReportEmbeddedResource = "../../Reports/Expenses.rdlc"           

        Me.ReportViewer1.LocalReport.DataSources.Clear()

        Me.ReportViewer1.LocalReport.DataSources.Add(datasource)



        AddHandler ReportViewer1.LocalReport.SubreportProcessing, AddressOf SetSubDataSource

        Me.ReportViewer1.LocalReport.Refresh()

        Me.ReportViewer1.RefreshReport()

        Me.Show()

    End If

End Sub

Public Sub SetSubDataSource(ByVal sender As Object, ByVal e As SubreportProcessingEventArgs)

    Dim Ds As New DataSet

    Call gSetDatabaseConnection()

    Dim sqlcmd As New SqlCommand

    With sqlcmd

        .CommandType = CommandType.StoredProcedure

        .CommandText = "CV_GetPay_BY_EXP"

        .Connection = gSqlConncetion

        .Parameters.Add(New SqlParameter("@iExp", SqlDbType.Int))

        .Parameters("@iExp").Direction = ParameterDirection.Input

        .Parameters("@iExp").Value = CType(e.Parameters(0), ReportParameterInfo).Values(0)  '11747

        Dim sqladp As New SqlDataAdapter(sqlcmd)

        sqladp.Fill(Ds)

        gSqlConncetion.Close()

    End With

    Dim datasource As New ReportDataSource("Payments", Ds.Tables(0))



    Dim path As String

    path = e.ReportPath

    e.DataSources.Add(datasource)

End Sub

edited Nov 14 '18 at 20:15

asked Nov 14 '18 at 19:46

user3439450

165

add a comment |

I have a report that shows expenses and a sub report to show all payments against expenses.and this is how i am passing data to master and sub report

         Dim datasource As New ReportDataSource("Expenses", Ds.Tables(0))

        Me.ReportViewer1.LocalReport.ReportPath = "../../Reports/Expenses.rdlc"

        Me.ReportViewer1.LocalReport.ReportEmbeddedResource = "../../Reports/Expenses.rdlc"           

        Me.ReportViewer1.LocalReport.DataSources.Clear()

        Me.ReportViewer1.LocalReport.DataSources.Add(datasource)



        AddHandler ReportViewer1.LocalReport.SubreportProcessing, AddressOf SetSubDataSource

        Me.ReportViewer1.LocalReport.Refresh()

        Me.ReportViewer1.RefreshReport()

        Me.Show()

    End If

End Sub

Public Sub SetSubDataSource(ByVal sender As Object, ByVal e As SubreportProcessingEventArgs)

    Dim Ds As New DataSet

    Call gSetDatabaseConnection()

    Dim sqlcmd As New SqlCommand

    With sqlcmd

        .CommandType = CommandType.StoredProcedure

        .CommandText = "CV_GetPay_BY_EXP"

        .Connection = gSqlConncetion

        .Parameters.Add(New SqlParameter("@iExp", SqlDbType.Int))

        .Parameters("@iExp").Direction = ParameterDirection.Input

        .Parameters("@iExp").Value = CType(e.Parameters(0), ReportParameterInfo).Values(0)  '11747

        Dim sqladp As New SqlDataAdapter(sqlcmd)

        sqladp.Fill(Ds)

        gSqlConncetion.Close()

    End With

    Dim datasource As New ReportDataSource("Payments", Ds.Tables(0))



    Dim path As String

    path = e.ReportPath

    e.DataSources.Add(datasource)

End Sub

edited Nov 14 '18 at 20:15

asked Nov 14 '18 at 19:46

user3439450

165

add a comment |

I have a report that shows expenses and a sub report to show all payments against expenses.and this is how i am passing data to master and sub report

         Dim datasource As New ReportDataSource("Expenses", Ds.Tables(0))

        Me.ReportViewer1.LocalReport.ReportPath = "../../Reports/Expenses.rdlc"

        Me.ReportViewer1.LocalReport.ReportEmbeddedResource = "../../Reports/Expenses.rdlc"           

        Me.ReportViewer1.LocalReport.DataSources.Clear()

        Me.ReportViewer1.LocalReport.DataSources.Add(datasource)



        AddHandler ReportViewer1.LocalReport.SubreportProcessing, AddressOf SetSubDataSource

        Me.ReportViewer1.LocalReport.Refresh()

        Me.ReportViewer1.RefreshReport()

        Me.Show()

    End If

End Sub

Public Sub SetSubDataSource(ByVal sender As Object, ByVal e As SubreportProcessingEventArgs)

    Dim Ds As New DataSet

    Call gSetDatabaseConnection()

    Dim sqlcmd As New SqlCommand

    With sqlcmd

        .CommandType = CommandType.StoredProcedure

        .CommandText = "CV_GetPay_BY_EXP"

        .Connection = gSqlConncetion

        .Parameters.Add(New SqlParameter("@iExp", SqlDbType.Int))

        .Parameters("@iExp").Direction = ParameterDirection.Input

        .Parameters("@iExp").Value = CType(e.Parameters(0), ReportParameterInfo).Values(0)  '11747

        Dim sqladp As New SqlDataAdapter(sqlcmd)

        sqladp.Fill(Ds)

        gSqlConncetion.Close()

    End With

    Dim datasource As New ReportDataSource("Payments", Ds.Tables(0))



    Dim path As String

    path = e.ReportPath

    e.DataSources.Add(datasource)

End Sub

edited Nov 14 '18 at 20:15

asked Nov 14 '18 at 19:46

user3439450

165

I have a report that shows expenses and a sub report to show all payments against expenses.and this is how i am passing data to master and sub report

         Dim datasource As New ReportDataSource("Expenses", Ds.Tables(0))

        Me.ReportViewer1.LocalReport.ReportPath = "../../Reports/Expenses.rdlc"

        Me.ReportViewer1.LocalReport.ReportEmbeddedResource = "../../Reports/Expenses.rdlc"           

        Me.ReportViewer1.LocalReport.DataSources.Clear()

        Me.ReportViewer1.LocalReport.DataSources.Add(datasource)



        AddHandler ReportViewer1.LocalReport.SubreportProcessing, AddressOf SetSubDataSource

        Me.ReportViewer1.LocalReport.Refresh()

        Me.ReportViewer1.RefreshReport()

        Me.Show()

    End If

End Sub

Public Sub SetSubDataSource(ByVal sender As Object, ByVal e As SubreportProcessingEventArgs)

    Dim Ds As New DataSet

    Call gSetDatabaseConnection()

    Dim sqlcmd As New SqlCommand

    With sqlcmd

        .CommandType = CommandType.StoredProcedure

        .CommandText = "CV_GetPay_BY_EXP"

        .Connection = gSqlConncetion

        .Parameters.Add(New SqlParameter("@iExp", SqlDbType.Int))

        .Parameters("@iExp").Direction = ParameterDirection.Input

        .Parameters("@iExp").Value = CType(e.Parameters(0), ReportParameterInfo).Values(0)  '11747

        Dim sqladp As New SqlDataAdapter(sqlcmd)

        sqladp.Fill(Ds)

        gSqlConncetion.Close()

    End With

    Dim datasource As New ReportDataSource("Payments", Ds.Tables(0))



    Dim path As String

    path = e.ReportPath

    e.DataSources.Add(datasource)

End Sub

.net vb.net reporting-services ssrs-tablix ssrs-2017

edited Nov 14 '18 at 20:15

asked Nov 14 '18 at 19:46

user3439450

165

edited Nov 14 '18 at 20:15

asked Nov 14 '18 at 19:46

user3439450

165

edited Nov 14 '18 at 20:15

asked Nov 14 '18 at 19:46

user3439450

165

asked Nov 14 '18 at 19:46

user3439450

165

asked Nov 14 '18 at 19:46

user3439450

165

add a comment |

1 Answer
1

active

oldest

votes

figured it out
when i inserted sub report should be inserted inside the group to repeat after each row.

answered Nov 14 '18 at 21:02

user3439450

165

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53307730%2fsubreport-in-rdlc-only-shows-for-one-record-in-master%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

figured it out
when i inserted sub report should be inserted inside the group to repeat after each row.

answered Nov 14 '18 at 21:02

user3439450

165

add a comment |

figured it out
when i inserted sub report should be inserted inside the group to repeat after each row.

answered Nov 14 '18 at 21:02

user3439450

165

add a comment |

figured it out
when i inserted sub report should be inserted inside the group to repeat after each row.

answered Nov 14 '18 at 21:02

user3439450

165

figured it out
when i inserted sub report should be inserted inside the group to repeat after each row.

answered Nov 14 '18 at 21:02

user3439450

165

answered Nov 14 '18 at 21:02

user3439450

165

answered Nov 14 '18 at 21:02

user3439450

165

answered Nov 14 '18 at 21:02

user3439450

165

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Vfrdtyky