This is a quick tip which may save you some time if you frequently use Business Intelligence in Visual Studio to develop custom reports for Dynamics CRM. You can create a report RDL file and use this as the default template for new reports. Simply create a new report and configure your CRM data source and add any other common items you require such as … [Read more...] about Dynamics CRM Default Custom Report Template
SQL
SQL stands for Structured Query Language and allows you to access and manipulate databases. SQL has many advantages which makes it a popular and efficient language for communicating with the databases such as faster query processing and easy to learn. Check the latest posts from tutorials to troubleshooting from Joe Gill.
Could not load file or assembly Microsoft.ReportViewer.WebForms
A colleague of mine got this error after deploying an application which uses the reporting services report viewer control. By default when you add a reference to an assembly which resides in the GAC it does not copy the dll to the local bin folder. So the application runs fine locally in debug mode however you then get this error when you deploy it to a server where … [Read more...] about Could not load file or assembly Microsoft.ReportViewer.WebForms
SQL Server Saturday Dublin 24th March
Well done to the SQL Server User Group in Dublin who have organized a great day of SQL server talks taking place on 24th March.This is a community event and free to attend with many of the world top sql experts speaking.More details and registration here Well done all involved. … [Read more...] about SQL Server Saturday Dublin 24th March
SQL Server Express – Profiler
SQL Server Express does not come with a profiler however AnjLab have just released a new version of their great free open source profiler here. Well recommended … [Read more...] about SQL Server Express – Profiler
Reporting Services – Shared Datasets
Shared datasets which were introduced in Reporting Service 2008 R2 allow a dataset to be shared across reports improving performance and avoiding the typical duplications of common querys and joins you find in most reporting services projects. Like most things in Reporting Services they are pretty easy to use.The following is an example of how to use shared datasets with the … [Read more...] about Reporting Services – Shared Datasets
Reporting Services – Data -Driven Subscription
In Reporting Services data driven subscriptions are used to run a query on a scheduled basis which returns a list of recipients to receive a report. What I have tried to do here is to show a simple example which will use this functionality to monitor an application and email out a report when any alerts that have been triggered. You need the enterprise version … [Read more...] about Reporting Services – Data -Driven Subscription
SQL Server Express and Reporting Services
A common question that gets asked is if SQL Serve Express supports Reporting Services. Yes it does however you need to install the version Advanced Services which can be downloaded from here.In addition to the usual restrictions you get with the Express version you can only use Reporting Services against you local express database i.e. you cannot install SQL Express and then … [Read more...] about SQL Server Express and Reporting Services
Conditional Formatting in Reporting Services using Common Code
The lack of support for CSS style sheets in reporting services can make life difficult when you want to have common formatting across reports. There are also occasions where you may want to share common conditional formatting logic across reports. This example shows how common code can be used to help in these scenarios. Whilst a .NET assembly would probably be more efficient … [Read more...] about Conditional Formatting in Reporting Services using Common Code
Cork talk on using CLR inside SQL Server
PJ Naughter, a Microsoft MVP, is coming to Cork on April 27 to do a talk on using .NET Common Language Runtime (CLR) inside SQL Server.Register on the mtug web site register … [Read more...] about Cork talk on using CLR inside SQL Server
SQL Server Indexing Talk – Niall Flanagan
Niall Flanagan did a great talk to MTUG Cork on indexing and fragmentation in sql server last night. It was a good session and it went on for over two hours with lots of interaction.Well done NiallThe materials from the talk can be found on the materials tab on the event Event … [Read more...] about SQL Server Indexing Talk – Niall Flanagan