Sign in

Microsoft.com

Microsoft

Remove From My Forums

MS CRM 2011 ONLINE - sum quantities but remove lines

Question
0

Sign in to vote

So I have made a report using report wizard.

The report groups products and then sums every product quantities so I can get a total sum of quantities from each product. The problem is that when CRM calculates the sum, CRM shows all "sub quantities" of each product and I don't want to show those. Can I remove those "sub quantities"?

See the picture.

Friday, January 10, 2014 11:57 AM

Answers

0

Sign in to vote
Hi,
you can edit your report using BIDS, and you can add an hidden condition on that rows.

You can start from this link about BIDS:

http://blogs.msdn.com/b/crm/archive/2010/10/26/how-to-creating-custom-report-with-microsoft-dynamics-crm-2011-bids-fetch-extension.aspx
My blog: www.crmanswers.net - Rockstar 365 Profile
- Marked as answer by Payman BiukaghazadehEditor Sunday, January 19, 2014 7:30 AM
Friday, January 10, 2014 12:04 PM

All replies

0

Sign in to vote
Hi,
you can edit your report using BIDS, and you can add an hidden condition on that rows.

You can start from this link about BIDS:

http://blogs.msdn.com/b/crm/archive/2010/10/26/how-to-creating-custom-report-with-microsoft-dynamics-crm-2011-bids-fetch-extension.aspx
My blog: www.crmanswers.net - Rockstar 365 Profile
- Marked as answer by Payman BiukaghazadehEditor Sunday, January 19, 2014 7:30 AM
Friday, January 10, 2014 12:04 PM
0

Sign in to vote

Hi,

AFAIK in the report wizard of CRM you could not do this. But you could export your rdl file and edit it the VS to hide the rows or sub-sums, then import it in CRM.

Friday, January 10, 2014 12:07 PM

Moderator
0

Sign in to vote

Hmm, does the BIDS works with Visual Studio 2013? And do I need a SQL server?

Friday, January 10, 2014 12:35 PM