<div>
Use matrix instead of tables<br />
<br />
regards <br />
Rakesh 
</div>


Use matrix instead of tables

regards
Rakesh

<div>
A matrix will cause problems in report rendering to PDF or Excel. <br />
<br />
Another solution is to create multiple rows of the same group/detail level in VS. Then select the row of the table. In the properties window modify the <b>Visibility </b>to show <b>Hidden</b> <i>=iif(Fields!new_field ToBeChecked.Value&lt;&gt;&quot;&quot;,fals<wbr />e,True)</i>
</div>


A matrix will cause problems in report rendering to PDF or Excel.

Another solution is to create multiple rows of the same group/detail level in VS. Then select the row of the table. In the properties window modify the Visibility to show Hidden =iif(Fields!new_field ToBeChecked.Value<>"",false,True)

<div>
<div class="content wysiwyg-content">
I am creating a Quote report from MS CRM using SSRS and Visual Studio. &nbsp;The Quote report has an area for a sub-report, QuoteProduct. &nbsp;What I would like to display is all the fields from QuoteProduct vertically under the Quote Product Name field, for multiple Quote Products associated with the Quote, like:<br />
<br />
Skylight 1[new_skylightnumber]:<br />
Length: [new_length]<br />
Width: &nbsp;[new_width]<br />
Height: [new_height]<br />
<br />
Skylight 2:<br />
Length: &nbsp;[new_length]<br />
Width: &nbsp;[new_width]<br />
<br />
If a particular field is null, I want to skip and not show it. &nbsp;A Table will llist the multiple quoteproducts, but will extend to the right for multiple pages. &nbsp; <br />
<br />
Any suggestions are appreciated!
</div>
</div>


I am creating a Quote report from MS CRM using SSRS and Visual Studio.  The Quote report has an area for a sub-report, QuoteProduct.  What I would like to display is all the fields from QuoteProduct vertically under the Quote Product Name field, for multiple Quote Products associated with the Quote, like:

Skylight 1[new_skylightnumber]:
Length: [new_length]
Width:  [new_width]
Height: [new_height]

Skylight 2:
Length:  [new_length]
Width:  [new_width]

If a particular field is null, I want to skip and not show it.  A Table will llist the multiple quoteproducts, but will extend to the right for multiple pages.   

Any suggestions are appreciated!

MS CRM SSRS Report Display Quote Products Detail

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.