Ed Giardina's .NET Blog - All Comments

re: SQL Server Reporting Services - Optional Parameters

Tom — Fri, 08 Jan 2010 13:14:32 GMT

Thanks! Your solution was just what I needed!

re: SQL Server Reporting Services - Optional Parameters

Alaa — Sun, 27 Dec 2009 14:35:49 GMT

hi all, am trying to walk through steps described above

"UNION

SELECT NULL, 'All'

ORDER BY 1,2

could u plz describe what does this query do, who does it works ??

I tried this solution but it does not work, am using SSRS 2008, and trying to do the date/time parameters optional, any suggestions !!

re: SQL Server Reporting Services - Optional Parameters

Swetha Sankaran — Thu, 17 Dec 2009 16:27:10 GMT

Great post, thanks! We had to pass the parameter through url from .NET code calling the rdl in the ReportServer.

Following your steps, the report generated in BIDS without any issues. But when trying to access it through URL the parameter didn't acced NULL value.

One quick addition resolved it.

{domain}/ReportServer/Pages/ReportViewer.aspx?YourReportName&rs:Command=Render&Parameter1=Value&Parameter2:isNull=True

re: "Failed to Enable Constraints" Error, and the Zen of DataSets

dtb — Fri, 13 Nov 2009 00:21:46 GMT

Ran into this myself. The cause in this case was unprintable characters in a character column that was part of a primary key.

re: Check intersection of two date ranges in SQL

colin — Mon, 05 Oct 2009 20:38:17 GMT

also note, that if you break out the NOT, you get something like this:

daterange1_startdate <= daterange2_end_date

AND daterange1_endate >= daterange2_startdate

which i'm using like this:

min(dateCreated) <= @EndDate and max(DateCreated) >= @StartDate

group by ...

i always prefer AND to OR, but it really doesn't make any difference.

re: What? No Columns in my GridView?

Steve — Wed, 26 Aug 2009 18:14:29 GMT

Thanks very much Virender

re: SQL Server Reporting Services - Optional Parameters

Sindy — Mon, 24 Aug 2009 06:48:17 GMT

What if i want to have an option of either passing a parameter or not??

For e.g.

either execute

select * from emp where emp_id='001';

or if i dont want to pass the value then select all emps as:

select * from emp;

Please help!

re: SQL Server Reporting Services - Optional Parameters

Alan — Fri, 17 Jul 2009 10:01:05 GMT

Hi Guys

Great post and thanks for the solution. I did a slight rework on the sql though

Select Employee_Id, Full_Name,1 As [Sort Order]

From Employee

Union All

Select Null As [Employee_Id], '<Optional Exclude>' As [Full_Name], 0 As [Sort Order]

Order By [Sort Order],Full_Name

This has the effect of auto choosing the first value in the list on running which is always my null because of the ordering.

I am seeing another wierd issue though, as whatever I select it always changes the selected option to the last one in the list <Grrrrrrrr>

I suspect this might be a service pack issue ????

Anyone ?

re: Check intersection of two date ranges in SQL

Paul — Wed, 20 May 2009 04:49:18 GMT

Thanks guys. This one is a mind-bender, and your postings saved me hours of work!

ok

wow gold — Fri, 24 Apr 2009 03:15:16 GMT

good article , I added you in the ‘Liked’ category.. thanks for sharing the article!

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

Left Brain Logic — Sun, 09 Nov 2008 17:56:08 GMT

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

Juju : Find Intersection of Two Date Ranges

Juju : Find Intersection of Two Date Ranges — Tue, 29 Jul 2008 16:16:02 GMT

Pingback from Juju : Find Intersection of Two Date Ranges

re: SQL Server Reporting Services - Optional Parameters

Diana Rhoades — Thu, 10 Jul 2008 19:43:29 GMT

I need to put a parameter in a report in two ways: one is Start Account and End Account (2 parameters). The other is an Account List where they put in a string delimited list of non-contiguous account numbers. Do you know of an example on the web where something similar has been done or have any other thoughts about this?

My primary dataset is built by a somewhat complex SQL code that ends with a table with no name. So I don't know how to query on that and get DISTINCT(account) and I don't know if this method above gives them the two options they need. Obviously my SQL would change but I need to set up the new Account List parameter before I know how to change my SQL.

Thanks.

diana.rhoades@agvantis.com

re: SQL Server Reporting Services - Optional Parameters

MRM — Tue, 01 Jul 2008 13:24:03 GMT

HI,

I have a column which gives the status of the employee. This column contains null values too.

now the parameter passes null also as one of the status. how to fetch data from the table using this parameter?

re: "Failed to Enable Constraints" Error, and the Zen of DataSets

Mike — Sat, 07 Jun 2008 13:34:08 GMT

Also, Dave Chamberlain's suggestion is right on the money: check your "default value" properties for each column name in the TableAdapter GUI. Set them to a default value where possible. As Dave mentioned, the properties default to "throwing an exception" and for the string values you can set that to "empty." That worked for my situation, in addition to setting my default integer values as 0. :)