- how do i create a report of Incidents per account?
- Posted by Mike B. on July 22nd, 2006
I am having a heck of a time trying to create a report that will show me all
the tickets, date time and desc and time used per account. I am using SQL
2005 SRS and visual studio 2005 to try to create this report. I can generate
the tickets but If i add the filteredaccount view to get the account name it
just prints lots of duplicates. I've looked around to see if there was a pre
made template out there as i would assume alot of people would like to print
a incident history per account. I've obviously never used SRS before so i'm
probably doing something wrong.
- Posted by John O'Donnell on July 24th, 2006
Mike
I think one of the standard reports is something like account summary and
will include a sub report of incidents etc
=======================
John O'Donnell
Microsoft CRM MVP
http://codegallery.gotdotnet.com/crm
"Mike B." <MikeB@discussions.microsoft.com> wrote in message
news:550BD905-6629-4843-8762-C42D7C5E5796@microsoft.com...
- Posted by Mike B. on July 25th, 2006
hrmm, i've tried running Account Summary with case field and anything else.
All i keep getting is a subject related to emails then a bunch of "v\;*
behavior:url(#default#VML);}" over and over again below the subject. It seems
no matter what i run as the report it always spits out exchange routed emails
pertaining to the account. thats it? is something configured wrong?
"John O'Donnell" wrote:
- Posted by Tao Yue [MSFT] on August 10th, 2006
<MikeB@discussions.microsoft.com> wrote:
This is how a left join works. If you just want to display the account
once, use the appropriate level of grouping and/or use the First expression
in SRS to return only the first account record.
--
Tao Yue
Microsoft Dynamics CRM Development
This posting is provided "AS IS" with no warranties, and confers no rights.
