<div>
Try just (Fields!amount.Value, &quot;DataSet2&quot;)
</div>


Try just (Fields!amount.Value, "DataSet2")

<div>
Thanks for the reply<br />
It gives out error and is not possible to use (Fields!amount.Value, &quot;DataSet2&quot;).<br />
Can you suggest me any other solution
</div>


Thanks for the reply
It gives out error and is not possible to use (Fields!amount.Value, "DataSet2").
Can you suggest me any other solution

<div>
Where are you using the data? In a textbox or table?
</div>


Where are you using the data? In a textbox or table?

<div>
<div class="content wysiwyg-content">
hi,<br />
<br />
how do I get value from second dataset (in multi dataset report) in some function it provide scope parameter like Sum(Fields!amount.Value, &quot;DataSet2&quot;).<br />
but I need to show the value without using function<br />
<br />
i.e; i want to have fields form second dataset but i am getting error when i enforce field values.<br />
if i use Fields!amount.Value then its showing up an error stating 'not in scope'.<br />
Please Help em resolve this problem for me.<br />
<br />
<br />

</div>
</div>


hi,

how do I get value from second dataset (in multi dataset report) in some function it provide scope parameter like Sum(Fields!amount.Value, "DataSet2").
but I need to show the value without using function

i.e; i want to have fields form second dataset but i am getting error when i enforce field values.
if i use Fields!amount.Value then its showing up an error stating 'not in scope'.
Please Help em resolve this problem for me.




Get Fields from second dataset insted of getting function Sum(dataset2)

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.