Solved

MS CRM SSRS Report Display Quote Products Detail

Posted on 2010-09-21
3
1,030 Views
Last Modified: 2012-05-10
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!
0
Comment
Question by:compterk
3 Comments
 
LVL 11

Expert Comment

by:rakeshAgarwal
ID: 33741530
Use matrix instead of tables

regards
Rakesh
0
 
LVL 4

Expert Comment

by:iamozymandias
ID: 33914634
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)
0
 

Accepted Solution

by:
compterk earned 0 total points
ID: 33924973
I was able to handle the null rows in CRM as opposed to the report.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question