Hello Team,
Hi Ken,
<DataSets><o:p></o:p>
<DataSet Name=“DataSet1”><o:p></o:p>
<Query><o:p></o:p>
<DataSourceName>DataSource1</DataSourceName><o:p></o:p>
<CommandText>select 1 as value, ‘label1’ as label<o:p></o:p>
union all<o:p></o:p>
select 2 as value, ‘label2’ as label<o:p></o:p>
union all<o:p></o:p>
select 3 as value, ‘label3’ as label<o:p></o:p>
union all<o:p></o:p>
select 4 as value, ‘label4’ as label<o:p></o:p>
</CommandText><o:p></o:p>
</Query><o:p></o:p>
<Fields><o:p></o:p>
<Field Name=“value”><o:p></o:p>
<DataField>value</DataField><o:p></o:p>
<rd:TypeName>System.Int32</rd:TypeName><o:p></o:p>
</Field><o:p></o:p>
<Field Name=“label”><o:p></o:p>
<DataField>label</DataField><o:p></o:p>
<rd:TypeName>System.String</rd:TypeName><o:p></o:p>
</Field><o:p></o:p>
</Fields><o:p></o:p>
</DataSet><o:p></o:p>
</DataSets>
Hi Tahir,
Hi Ken,
LordoftheRink:
I am using a stored procedure instead of a select statement in rdl.
The concept of using ‘Select Statement’ inside RDL files is to populate the data for RDL files. Please share your RDL files along with data source here for investigation purposes. You may share SQL Server database backup which contains the specific tables (with dummy data) and store procedure related to your RDL files.
LordoftheRink:
I also have another problem with ASPOSE. When ever I hide a tablix which has data, instead of not displaying anything, ASPOSE report is producing space instead of data. Please let me know if you have a solution for this problem.