Click here to Skip to main content
The default search term operator is AND.

You can use brackets, AND, OR, and NOT to improve your search. For example: C# AND NOT(VB or SQL)

A query of a single * will return everything, filtered by any filters.

Filter examples:
Search by Author  author:"author name"
Filter by tag  tag:C# or tag:(C++ or Java)
Wildcard search  use "?" or "*" eg. gr?d or gr*
  
164 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 4
Page Size: 10 · 25 · 50

Category filtered by:  Database [x] | SQL Reporting Services [x] | General [x]
Tip/Trick 10 May 2013   license: CPOL
List out reports from Reprting Server.
Database » Sql Reporting Services » General
SQLReports
Technical Blog 9 May 2013   license: CPOL
Backing up all databases using T-SQL
Database » Sql Reporting Services » General
WCFT-SQL
Technical Blog 8 May 2013   license: CPOL
This post is designed to help you understand how to use the EXISTS keyword in your SQL query environment.
Database » Sql Reporting Services » General
WCFSQL
Article 6 May 2013   license: CPOL
An application which prints reports developed in SSRS 2008R2 using a Windows or web application.
Database » Sql Reporting Services » General
C#
Tip/Trick 9 Apr 2013   license: CPOL
This will help you generate columns dynamically in SSRS reports using Matrix control.
Database » Sql Reporting Services » General
SQLSQL-ServerBeginnerIntermediateAdvancedSSRS
Technical Blog 8 Mar 2013   license: CPOL
I remember those days when I used to simply fall into the trap set by client requirements which could have been easily resolved by using a trigger. So I can definitely say, trigger is a life saver,if used cleverly. Many of the users might know Triggers so I will use question-answer format to clear t
Database » Sql Reporting Services » General
WCF
Tip/Trick 19 Feb 2013   license: CPOL
I found out that a possible cause is the difference between the SSIS 32 bits and 64 bits environment
Database » Sql Reporting Services » General
C#SQL.NETSQL-ServerDBADevIntermediateMicrosoft
Technical Blog 19 Feb 2013   license: CPOL
AbstractSQL Server Integration Services 2012 comes with a new API for scripting packages which is called MOM – Managed Object Model. This API is accessed through the Microsoft.SqlServer.Management.IntegrationServices.dll assembly file.
Database » Sql Reporting Services » General
WCF
Technical Blog 11 Feb 2013   license: CPOL
People ask me a lot about subquery so I thought let’s answer with a article touching a bit of everything about subquery. Before discussing SubQuery, there are few things which we should know like: What is a Query? I will go with its English Definition first. As a verb, “Put a question or questions t
Database » Sql Reporting Services » General
WCF
Article 7 Feb 2013   license: CPOL
This article describes how to create custom delivery extension of Reporting service with User Control (.ascx) instead of server control.
Database » Sql Reporting Services » General
C#3.0.NET3.5C#ASP.NET.NETSQL-ServerArchitectDevAdvancedC#, +
Article 26 Jan 2013   license: CPOL
How to create and deploy a SSRS rendering extension, explained by a functional Zip Rendering extension for SSRS 2005, 2008 (R2) and 2012.
Database » Sql Reporting Services » General
SQL2005.NET3.5C#.NETSQL-ServerVisual-StudioDBADevIntermediate.NET, +
Technical Blog 7 Jan 2013   license: Apache
In my practices using continuous integration, I try to achieve 100% code coverage using integration tests. This is a separate metric from my unit tests, think of these tests as verifying all of my infrastructure code works properly when wired … Continue reading →
Database » Sql Reporting Services » General
WCF
Article 10 Dec 2012   license: CPOL
This article will show you how to implement print functionality and the jQuery datepicker in non-IE browsers.
Database » Sql Reporting Services » General
C#ASP.NETJavascriptAjaxjQuery
Article 21 Nov 2012   license: CPOL
This article might be helpful for the developers who are thinking for the migration or having trouble with migration of sql server reporting service (SSRS) 2005 to 2008.
Database » Sql Reporting Services » General
SQL-ServerDevIntermediatereporting-services
Technical Blog 23 Oct 2012   license: CPOL
CodeProjectIntroductionDue to the nature of the work I've been doing lately, it's been a while since I've had to cut much T-SQL above and beyond standard CRUD operations; but whilst fixing a stored procedure the other day, I was bitten by this little gotcha.The ScenarioImagine that we have the follo
Database » Sql Reporting Services » General
WCF
Technical Blog 7 Aug 2012   license: CPOL
In the last few posts I've been describing how to create instances of SQLCE in order to perform automated Integration Testing using NUnit and accessing the dB using Entity Framework.  I covered creating the dB using both Entity Framework and the SQL CE classes.  In particular I wanted control over t
Database » Sql Reporting Services » General
WCF
Article 30 Jul 2012   license: CPOL
Create a SQL Reporting Services report to show the status of all SQL Jobs and drill down to the status of the steps within each job.
Database » Sql Reporting Services » General
SQLSQL-ServerDevIntermediate
Technical Blog 23 Jul 2012   license: CPOL
Many a times we came across situation to merge records between two tables.
Database » Sql Reporting Services » General
SQL-ServerSQL2008
Article 23 Apr 2012   license: CPOL
Customize SSRS Page Break
Database » Sql Reporting Services » General
Windows.NETDevDesignSSRS
Article 27 Mar 2012   license: Ms-PL
This article shows a detailed approach on how to dynamically point to a given shared data source reference by setting up an RDCE and using a couple of tips and tricks.
Database » Sql Reporting Services » General
C#XMLSQLWindowsDevIntermediate
Article 5 Mar 2012   license: CPOL
This examle shows you how to create a C# program to download SSRS reports from a server.
Database » Sql Reporting Services » General
C#.NETSQL-ServerDevIntermediateSQL2008SRSS
Technical Blog 8 Feb 2012   license: CPOL
How to instantiate derived LINQ to SQL entities
Database » Sql Reporting Services » General
C#WCF
Technical Blog 29 Jan 2012   license: CPOL
Join Hint in SQL - Guest Post by Joydeep Das
Database » Sql Reporting Services » General
SQLSQL-Server
Technical Blog 27 Jan 2012   license: CPOL
Today I had to create a Linq-To-SQL query which joined two tables. These tables had compound primary keys (table simplified for example): Table Referrers ServerID (PK) ReferrerID (PK) Value 1 1 My value 1 1 2 My value 2 1 3 My value 3 Table ReferrerInfo ServerID (PK) ReferrerID (PK) Value 1 1 More i
Database » Sql Reporting Services » General
WCF
Tip/Trick 8 Jan 2012   license: CPOL
Hide/Show the row in a table in SSRS based on parameter value
Database » Sql Reporting Services » General
SSRS
Article 4 Dec 2011   license: CPOL
A step-by-step tutorial describing how to implement localization within SQL Server Reporting Services using the power of the .NET localization methods.
Database » Sql Reporting Services » General
C#SQL.NETDBA
Answer 3 Dec 2011   license: CPOL
Here you goHandling truncated leading spaces in Reporting Services[^]ConsumeContainerWhitespace property to remove blank space in SSRS 2008 report[^]Removing Multiple Extra Spaces or White Spaces Into Single Space using Regular Expressions in Reporting Services[^]
Database » Sql Reporting Services » General
SSRS
Technical Blog 26 Nov 2011   license: CPOL
Deploy/Use assemblies which require Unsafe/External Access with CLR and T-SQL
Database » Sql Reporting Services » General
All-Topics
Technical Blog 25 Nov 2011   license: CPOL
Why use CLR?Before using CLR, you should question ‘Why’. When using CLR functions within T-SQL, you have to maintain two different programming environments, unless what you gain worth more than having it.We need to use the CLR functions when occasions such as:When we have to access system resources
Database » Sql Reporting Services » General
SQLDevIntermediate
Tip/Trick 13 Nov 2011   license: CPOL
Error trying to get SubReports to show (code in Vulcan.net)
Database » Sql Reporting Services » General
SSRS
Tip/Trick 13 Nov 2011   license: CPOL
How to hide PDF Export option in Report Viewer
Database » Sql Reporting Services » General
SSRSSqlServer
Tip/Trick 10 Nov 2011   license: CPOL
I tried this for the second subreport, Table2, but no subreport for Table2 was displayed:METHOD SubReportEventHandler(sender AS OBJECT, e AS SubreportProcessingEventArgs) AS VOID LOCAL oDS AS ReportDataSource LOCAL table AS datatable // fill table here with the...
Database » Sql Reporting Services » General
SSRS
Technical Blog 1 Nov 2011   license: CPOL
I’ve recently needed to have a multilingual menu where the id for each menu item is the same across all languages, this is a bit of a tall order using the workarea as only the root menu item will share the id. So I’ve knocked out a quick’n’dirty TSQL script to clone a menu across across several lan
Database » Sql Reporting Services » General
WCF
Article 23 Oct 2011   license: CPOL
A way to combine data from two different sources into one datasource for SSRS reporting
Database » Sql Reporting Services » General
C#SQLWindows.NETIntermediateVisual-StudioVS2010SSRSServer
Tip/Trick 20 Sep 2011   license: CPOL
Three ways to put sub reports to work.
Database » Sql Reporting Services » General
CrystalReports
Technical Blog 30 Aug 2011   license: CPOL
Improve Your Crystal Reporting and Unleash Your Business’ Potential
Database » Sql Reporting Services » General
All-Topics
Technical Blog 17 Aug 2011   license: CPOL
Answer simple quiz at the end of the blog post and - Every day one winner from India will get Joes 2 Pros Volume 3. Every day one winner from United States will get Joes 2 Pros Volume 3. System and Time Data Types Keeping track of date and time data points has always been [...]
Database » Sql Reporting Services » General
SQLSqlServer
Article 9 Aug 2011   license: CPOL
A single report can be used to display different sets of data.
Database » Sql Reporting Services » General
SQLDevIntermediate
Technical Blog 27 Jul 2011   license: CPOL
    If you try to install/add feature SQL 2008 Business Intelligence Studio, to a machine with VS2008 having installed to a different location than the default, you will most probably get the following error : In order to install BI Studio 2008 properly, please do the following : Find the folder wh
Database » Sql Reporting Services » General
WCF
Technical Blog 22 Jul 2011   license: CPOL
Part 1 of a discussion about replacing cursors with SQL statements for significant speed improvements.In a previous post I discussed where it is best to put logic – SQL or code. In my view, SQL is great for processing sets of data and poorly structured for row-based processing. To put it blu
Database » Sql Reporting Services » General
WCF
Technical Blog 22 Jul 2011   license: CPOL
Part 2 of a discussion about replacing cursors with SQL statements for significant speed improvements.In a recent post I discussed cursors and mentioned, at a high level, an example of replacing a cursor with a set-based series of SQL statements. In this post, I’m going to provide a simplified
Database » Sql Reporting Services » General
WCF
Tip/Trick 4 Jul 2011   license: CPOL
How to export a SQL Server Reporting Services 2005 report directly to PDF or Excel.
Database » Sql Reporting Services » General
reporting-services
Technical Blog 24 Jun 2011   license: CPOL
Why being careful is such an important mindset when working with SQL and databases.At the Boston Public Schools, certain processes need to be run at particular times of the school year. There’s a couple of specific windows of time where we print choice forms for students. There’s a few
Database » Sql Reporting Services » General
WCF
Technical Blog 6 Jun 2011   license: CPOL
A discussion about nightly populated tables and how they have reduced SQL Server load.
Database » Sql Reporting Services » General
SQL-ServerDBADevIntermediate
Technical Blog 31 May 2011   license: CPOL
A followup to a post about subqueries with an estimation for how long it would take for the query to run.In a recent post about subqueries, I compared 4 queries and how they handled 4 million rows of data. The queries involved:1) Joins with AND conditions.2) Subqueries with AND conditions.3) Joins
Database » Sql Reporting Services » General
WCF
Technical Blog 29 May 2011   license: CPOL
A discussion of how views give a more denormalized means for querying against normalized tables.
Database » Sql Reporting Services » General
SQLquery
Technical Blog 15 May 2011   license: CPOL
Configuring CRM 4.0 for SSRS Without the Data Connector
Database » Sql Reporting Services » General
SQL-Server
Article 12 May 2011   license: CPOL
This article will illustrate the approach to open SSRS report in ASP.NET UI using URL command and IFrame Method.
Database » Sql Reporting Services » General
C#2.0C#ASP.NETSQL.NETSQL-ServerArchitectAdvancedC#MOSS2007
Article 12 May 2011   license: CPOL
In this article we will learn creation of subreports, drilldown reports, custom coding and expression, web service and wcf service consumption frm SSRS,custom paging and sorting, working with databars and indicators with real time examples
Database » Sql Reporting Services » General
WinXPSQL2005SQLWindowsSQL-ServerDevBeginnerWindowsSQL-ServerSQL2008, +
Article 11 May 2011   license: CPOL
This article will help in understanding the myraid ways of report creation, deployment and invocation of report from various client applications
Database » Sql Reporting Services » General
WinXPSQL2005SQLWindowsSQL-ServerDevBeginnerIntermediateWindowsSQL-Server, +
Page 1 of 4
1 2 3 4
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web01 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid