Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MS CRM SSRS Report Display Quote Products Detail

Posted on 2010-09-21
3
Medium Priority
?
1,036 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part II
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

636 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