question

HeatherBrouillette-7757 avatar image
0 Votes"
HeatherBrouillette-7757 asked Joyzhao-MSFT commented

SSRS is there a more efficient way to call a sub report using VB

I'm currently calling specific sub reports with visibility options. I have some of my sub reports (so far) in a tablix but I will have hundreds of sub reports. I was wondering if there is a better way of doing this? Perhaps somehow calling the sub report with an IIF expression in VB?

106267-screenshot-2021-06-16-100852.png


sql-server-reporting-servicesdotnet-visual-basic
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @HeatherBrouillette-7757 ,
I am not sure if I understand it correctly. Do you mean to write multiple sub-reports to mainreport through vb? Regarding vb sentences, I really lack this knowledge. I added tags related to vb. I hope experts in the vb field can help you.
Best Regards,
Joy

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HeatherBrouillette-7757 avatar image
0 Votes"
HeatherBrouillette-7757 answered Joyzhao-MSFT commented

Yes @Joyzhao-MSFT, essentially I'm wondering if there is a more efficient way to do what a main report calling the tablix of sub reports does. When you have hundreds of sub reports listed it's not going to be practical to maintain and I can only assume it may start to process very slowly. So I'm looking for another option.

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

As far as I know, this should not be possible.
You can consult VB experts,I am not good at using VB.

0 Votes 0 ·

Thank you @Joyzhao-MSFT for responding and trying. I appreciate that. :)

0 Votes 0 ·
Joyzhao-MSFT avatar image Joyzhao-MSFT HeatherBrouillette-7757 ·

If there is an issue about SSRS, you can feel free to let me know.

1 Vote 1 ·