The SSRS report does not have rows?

Aspose.Words Product Family
1

The SSRS simply would not have rows. Please check. Please find the attached RDL.

2

Hi Anshuman,

Thanks for your inquiry. Could you please use the select statement (to populate the data) inside your RDL file and share it here for testing? We will investigate the issue on our side and provide you more information.

Please check the following DataSet example with select statement for your kind reference:

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>DataSets<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>DataSet<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: red;”>Name<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>=<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>“DataSet”>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>Query<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>DataSourceName<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>><span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>DataSource</DataSourceName>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>CommandText<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>><span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; background-color: yellow;”>select 1 as value, ‘label1’ as label

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; background-color: yellow;”> union all

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; background-color: yellow;”> select 2 as value, ‘label2’ as label

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; background-color: yellow;”> union all

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; background-color: yellow;”> select 3 as value, ‘label3’ as label

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; background-color: yellow;”> union all

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; background-color: yellow;”> select 4 as value, ‘label4’ as label<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> </<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>CommandText<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> </<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>Query<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>Fields<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>Field<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: red;”>Name<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>=<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>“value”>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>DataField<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>><span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>value</DataField>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>rd:TypeName<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>><span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>System.Int32</rd:TypeName>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> </<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>Field<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>Field<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: red;”>Name<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>=<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>“label”>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>DataField<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>><span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>label</DataField>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>rd:TypeName<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>><span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”;”>System.String</rd:TypeName>

<span lang=“EN-GB” style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> <span style=“font-size: 10pt; font-family: “Courier New”; color: blue;”></<span style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>Field<span style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> </<span style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>Fields<span style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span style=“font-size: 10pt; font-family: “Courier New”; color: blue;”> </<span style=“font-size: 10pt; font-family: “Courier New”; color: rgb(163, 21, 21);”>DataSet<span style=“font-size: 10pt; font-family: “Courier New”; color: blue;”>>

<span style=“font-size: 10pt; line-height: 14px; font-family: “Courier New”; color: blue;”> </<span style=“font-size: 10pt; line-height: 14px; font-family: “Courier New”; color: rgb(163, 21, 21);”>DataSets<span style=“font-size: 10pt; line-height: 14px; font-family: “Courier New”; color: blue;”>>