CRM / SQL Reporting Services Tutorials and samples http://www.qos-it.com/qw/Blog/tabid/55/BlogId/4/Default.aspx en-US ged@qos-it.com Sun, 05 Feb 2012 22:19:37 GMT Sun, 05 Feb 2012 22:19:37 GMT http://backend.userland.com/rss Blog RSS Generator Version 3.5.0.35082 <p><img title="image" border="0" alt="image" width="650" height="433" style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" src="/QW/Portals/0/Blog/Files/4/81/WLW-Report8HWDevicesperSLAContractLine_12977-image_thumb_1.png" /></p><a href=http://www.qos-it.com/qw/Blog/tabid/55/EntryId/81/Report-8-HW-Devices-per-SLA-Contract-Line.aspx>More...</a> http://www.qos-it.com/qw/Blog/tabid/55/EntryId/81/Report-8-HW-Devices-per-SLA-Contract-Line.aspx http://www.qos-it.com/qw/Blog/tabid/55/EntryId/81/Report-8-HW-Devices-per-SLA-Contract-Line.aspx#Comments http://www.qos-it.com/qw/Blog/tabid/55/EntryId/81/Report-8-HW-Devices-per-SLA-Contract-Line.aspx Sun, 12 Sep 2010 11:12:09 GMT 0 http://www.qos-it.com/QW/DesktopModules/Blog/Trackback.aspx?id=81 <p><img title="image" border="0" alt="image" width="728" height="761" style="border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px" src="/QW/Portals/0/Blog/Files/4/80/WLW-Report567NumberofCaseOnsiteRemotejobsper_14355-image_thumb_1.png" /></p><a href=http://www.qos-it.com/qw/Blog/tabid/55/EntryId/80/Report-5-6-amp-7-Number-of-Case-Onsite-Remote-jobs-per-user.aspx>More...</a> http://www.qos-it.com/qw/Blog/tabid/55/EntryId/80/Report-5-6-amp-7-Number-of-Case-Onsite-Remote-jobs-per-user.aspx http://www.qos-it.com/qw/Blog/tabid/55/EntryId/80/Report-5-6-amp-7-Number-of-Case-Onsite-Remote-jobs-per-user.aspx#Comments http://www.qos-it.com/qw/Blog/tabid/55/EntryId/80/Report-5-6-amp-7-Number-of-Case-Onsite-Remote-jobs-per-user.aspx Sat, 11 Sep 2010 13:01:43 GMT 0 http://www.qos-it.com/QW/DesktopModules/Blog/Trackback.aspx?id=80 <ul> <li>Publishing a new report</li> <li>Downloading an existing report</li> <li>Updateing an existing report</li> </ul><a href=http://qos-it.com/QW/Blog/tabid/55/EntryId/77/Step-3-ndash-Publishing-your-SQL-Reporting-Services-reports-to-Microsoft-CRM.aspx>More...</a> http://qos-it.com/QW/Blog/tabid/55/EntryId/77/Step-3-ndash-Publishing-your-SQL-Reporting-Services-reports-to-Microsoft-CRM.aspx http://qos-it.com/QW/Blog/tabid/55/EntryId/77/Step-3-ndash-Publishing-your-SQL-Reporting-Services-reports-to-Microsoft-CRM.aspx#Comments http://qos-it.com/QW/Blog/tabid/55/EntryId/77/Step-3-ndash-Publishing-your-SQL-Reporting-Services-reports-to-Microsoft-CRM.aspx Wed, 08 Sep 2010 01:28:40 GMT 0 http://www.qos-it.com/QW/DesktopModules/Blog/Trackback.aspx?id=77 <p>Setting up Visual Studio for your first report and creating a simple Account list report.</p><a href=http://qos-it.com/QW/Blog/tabid/55/EntryId/76/Step-2-ndash-Setting-up-Visual-Studio-for-your-first-report.aspx>More...</a> http://qos-it.com/QW/Blog/tabid/55/EntryId/76/Step-2-ndash-Setting-up-Visual-Studio-for-your-first-report.aspx http://qos-it.com/QW/Blog/tabid/55/EntryId/76/Step-2-ndash-Setting-up-Visual-Studio-for-your-first-report.aspx#Comments http://qos-it.com/QW/Blog/tabid/55/EntryId/76/Step-2-ndash-Setting-up-Visual-Studio-for-your-first-report.aspx Wed, 08 Sep 2010 01:07:44 GMT 3 http://www.qos-it.com/QW/DesktopModules/Blog/Trackback.aspx?id=76 <p><img title="image" border="0" alt="image" width="846" height="778" style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" src="/QW/Portals/0/Blog/Files/4/75/WLW-Report3ReportedTimeperActivityJob_13067-image_thumb.png" /></p><a href=http://www.qos-it.com/qw/Blog/tabid/55/EntryId/75/Report-4-Reported-Time-per-Activity-amp-Job.aspx>More...</a> http://www.qos-it.com/qw/Blog/tabid/55/EntryId/75/Report-4-Reported-Time-per-Activity-amp-Job.aspx http://www.qos-it.com/qw/Blog/tabid/55/EntryId/75/Report-4-Reported-Time-per-Activity-amp-Job.aspx#Comments http://www.qos-it.com/qw/Blog/tabid/55/EntryId/75/Report-4-Reported-Time-per-Activity-amp-Job.aspx Wed, 01 Sep 2010 11:39:13 GMT 0 http://www.qos-it.com/QW/DesktopModules/Blog/Trackback.aspx?id=75 <p>SQL Server Reporting Services reports are defines in the XML Report Definition Language (RDL). Although it is possible to create a report by hand by using a simple text editor it is not advisable instead you can use Microsoft Visual Studio with the included Business Intelligence Projects plug-in found on your SQL Server CD-ROM or DVD.</p> <p>This artcile gives you instructions on how to install this.</p><a href=http://qos-it.com/QW/Blog/tabid/55/EntryId/74/Step-1-ndash-Installing-Visual-Studio-and-the-Microsoft-SQL-Server-Reporting-Services-Designers.aspx>More...</a> http://qos-it.com/QW/Blog/tabid/55/EntryId/74/Step-1-ndash-Installing-Visual-Studio-and-the-Microsoft-SQL-Server-Reporting-Services-Designers.aspx http://qos-it.com/QW/Blog/tabid/55/EntryId/74/Step-1-ndash-Installing-Visual-Studio-and-the-Microsoft-SQL-Server-Reporting-Services-Designers.aspx#Comments http://qos-it.com/QW/Blog/tabid/55/EntryId/74/Step-1-ndash-Installing-Visual-Studio-and-the-Microsoft-SQL-Server-Reporting-Services-Designers.aspx Tue, 31 Aug 2010 06:56:31 GMT 0 http://www.qos-it.com/QW/DesktopModules/Blog/Trackback.aspx?id=74 <p><img title="image" border="0" alt="image" width="688" height="653" style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" src="/QW/Portals/0/Blog/Files/4/73/WLW-Report3CasesbyCustomer_A0D6-image_thumb_1.png" /></p><a href=http://www.qos-it.com/qw/Blog/tabid/55/EntryId/73/Report-3-Cases-by-Customer.aspx>More...</a> http://www.qos-it.com/qw/Blog/tabid/55/EntryId/73/Report-3-Cases-by-Customer.aspx http://www.qos-it.com/qw/Blog/tabid/55/EntryId/73/Report-3-Cases-by-Customer.aspx#Comments http://www.qos-it.com/qw/Blog/tabid/55/EntryId/73/Report-3-Cases-by-Customer.aspx Mon, 30 Aug 2010 01:26:29 GMT 0 http://www.qos-it.com/QW/DesktopModules/Blog/Trackback.aspx?id=73 <p><img title="image" border="0" alt="image" width="628" height="378" style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" src="/QW/Portals/0/Blog/Files/4/72/WLW-71967738ea91_14B37-image_thumb.png" /></p><a href=http://www.qos-it.com/qw/Blog/tabid/55/EntryId/72/Report-2-Improved-version-of-report-1-List-Of-Cases-By-Customer.aspx>More...</a> http://www.qos-it.com/qw/Blog/tabid/55/EntryId/72/Report-2-Improved-version-of-report-1-List-Of-Cases-By-Customer.aspx http://www.qos-it.com/qw/Blog/tabid/55/EntryId/72/Report-2-Improved-version-of-report-1-List-Of-Cases-By-Customer.aspx#Comments http://www.qos-it.com/qw/Blog/tabid/55/EntryId/72/Report-2-Improved-version-of-report-1-List-Of-Cases-By-Customer.aspx Sat, 28 Aug 2010 13:39:05 GMT 0 http://www.qos-it.com/QW/DesktopModules/Blog/Trackback.aspx?id=72 <p>When report’s design is completed, you can then publish the report in Microsoft CRM or schedule the report to be automatically emailed to other users in the organization or to customers (refer to post: Schedule automatic Email delivery of reports)</p> <p><strong>Click:</strong> Workplace>Reports>New <br /> <strong>Select:</strong> Report Type=Existing File <br /> Browse & upload the .rdl file created in Visual studio <br /> In the Categorization section: <br /> <strong>select:</strong> Related Record Types as Cases <br /> <strong>Select:</strong> Display In as “Lists for related record types” to display the report in the Case entity <br /> <strong>Click:</strong> Run Report <br /> The option to modify the Report Filtering Criteria is available before you run any report <br /> To save new filtering criteria:</p> <p>Select the report</p> <p><strong>Click:</strong> More Actions on toolbar</p> <p><strong>Select:</strong> Edit Default Filter  <br /> Edit report filter as required</p> <p><strong>Click:</strong> Save Default Filter</p><a href=http://www.qos-it.com/qw/Blog/tabid/55/EntryId/71/Publishing-reports-to-Microsoft-CRM.aspx>More...</a> http://www.qos-it.com/qw/Blog/tabid/55/EntryId/71/Publishing-reports-to-Microsoft-CRM.aspx http://www.qos-it.com/qw/Blog/tabid/55/EntryId/71/Publishing-reports-to-Microsoft-CRM.aspx#Comments http://www.qos-it.com/qw/Blog/tabid/55/EntryId/71/Publishing-reports-to-Microsoft-CRM.aspx Sat, 28 Aug 2010 00:52:01 GMT 0 http://www.qos-it.com/QW/DesktopModules/Blog/Trackback.aspx?id=71 <p> <img title="image" border="0" alt="image" width="857" height="868" style="border-bottom: 0px; border-left: 0px; display: inline; border-top: 0px; border-right: 0px" src="/QW/Portals/0/Blog/Files/4/70/WLW-7d6828888c9a_C20B-image_thumb_3.png" /></p><a href=https://www.qos-it.com/qw/Blog/tabid/55/EntryId/70/Report-1-List-Of-Cases-By-Customer.aspx>More...</a> https://www.qos-it.com/qw/Blog/tabid/55/EntryId/70/Report-1-List-Of-Cases-By-Customer.aspx https://www.qos-it.com/qw/Blog/tabid/55/EntryId/70/Report-1-List-Of-Cases-By-Customer.aspx#Comments https://www.qos-it.com/qw/Blog/tabid/55/EntryId/70/Report-1-List-Of-Cases-By-Customer.aspx Fri, 27 Aug 2010 03:53:16 GMT 0 http://www.qos-it.com/QW/DesktopModules/Blog/Trackback.aspx?id=70