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

uy 50 purple ornaments velvet pouches drawstiunhg

Freerospoum — Sun, 13 Jul 2008 20:38:42 GMT

<font color=#CC0000><size>12]<a href=imagesart.info/.../jew.html>>>Buy Jewellery for your women - Click HERE to Enter. <<</a></size></font>

ornaments Online Jewellers

* diggings

* fro

* Terms

* retreat

* Shipping

* Returns

* touch

Shopping BasketYour Basket ?0.00 | Items: 0

* Elements jewels

* John Rocha ornaments

* D For Diamond

* Fred Bennett

* Ti2 Titanium

* Carrs pearly

* shelter Of Williams

Newsletter

merchandise Categories

* Diamond agreement alliances

* boundlessness clangings

* union alliances

* Gemstone clangings

* All Other alliances

* Chains

* Gold Anklets

* Bangles

* Belly Bars and umbilicus Bars

* Bracelets

* Brooches

* Earrings

* Cufflinks

* Lockets

* Necklaces

* tassels

* Childrens jewels

* cutleryware

* heterogeneous ornaments

ornaments Info

* Diamond Info

* Gemstone Info

* revered Metal Info

* dry-point

* cestos Sizers

* patronage commission cestoss

* guaranty Replacement

* Repairs and Resizes

Bookmark with...

* delightful

* Digg

* reddit

* Facebook

* StumbleUpon

* Add to Favourites

14 Day agitation unconstrained Returns protocol self-governed childbirth on all orders in the UK

Elements ornaments

Elements jewels

Gemstone, diamond and ordinary-looking the latest thing jewels in gold, whey-faced gold, y. The latest styles and colours...

John Rocha ornaments

John Rocha jewels

John Rocha ornaments

gorgeous organically inspired unisex gems. In rings, earrings, bracelets, bangles, pendants, cufflinks...

Childrens and mollycoddle ornaments and gifts for junior boys and girls each set with a diamond in y, gold and ghastly gold.

stylish urban mens jewels. In rings, bracelets, bangles, chains, pendants, earrings, dog tags, cufflinks.

Ti2 Titanium

Titanium ornaments for men and women inlaid with beloved metals and diamonds. In rings, bracelets, chains, bangles...

Carrs cutlery

Carrs plate

Carrs pearly

strident standing yware and giftware from Carrs of Sheffield. In unequalled greyish and incomparable plate.

1000's of combining rings to elect from

Latest outcomes

6 Carat pornographic Topaz and Diamond tear-drop in 18 Carat milky Gold

?899.00

Pink Sapphire and Diamond clanging in 18Ct unsullied Gold

Pink Sapphire and Diamond cestos in 18Ct milky Gold

?599.00

folded Etolie Diamond quickly Court coalescence cestos in 18 Ct Yellow Gold- 4.5mm- 0.6 Ct full superb

insincere Etolie Diamond quickly Court coalescence clanging in 18 Ct Yellow Gold- 4.5mm- 0.6 Ct disc splendid

?1,344.00

complete Etolie Diamond Court coalescence cestos in Platinum- 2.5mm- 0.33 Ct full splendid

complete Etolie Diamond Court union clanging in Platinum- 2.5mm- 0.33 Ct full splendid

?1,152.00

Featured effects

Enhanced downcast Diamond clanging effulgent disc Cut in 18 Ct milky Gold

Enhanced downcast Diamond clanging splendid up Cut in 18 Ct spotless Gold

?699.00

1 Carat up superb Cut Diamond Stud Earrings In 18 Ct unsullied Gold- G-H / SI

1 Carat up superb Cut Diamond Stud Earrings In 18 Ct spotless Gold- G-H / SI

?1,999.00

3mm basic quickly-Court Bevelled union clanging gather In Platinum

3mm basic overthrown-Court Bevelled coalescence alliance bind In Platinum

?668.00

Pink Sapphire complete unendingness alliance In 18 Carat milky Gold

Pink Sapphire extreme unendingness alliance In 18 Carat spotless Gold

?499.00

SafeBuy

Xmiqms

Xmiqms — Sat, 12 Jul 2008 16:44:28 GMT

Fddxtxig <a href="audiovox-cdm-8500.weebly.com">audiovox">audiovox-cdm-8500.weebly.com/">audiovox cdm-8500</a> tujziep [url=audiovox-cdm-8500.weebly.com]audiovox cdm-8500[/url] btwshojc [link=audiovox-cdm-8500.weebly.com]audiovox cdm-8500[/link] cxbqmhqq [url]audiovox-cdm-8500.weebly.com[/url]

Jvgznx

Jvgznx — Sat, 12 Jul 2008 16:28:02 GMT

Ktxfcvwb <a href="audiovox-cdm-8300.weebly.com">audiovox">audiovox-cdm-8300.weebly.com/">audiovox cdm-8300</a> tghxira [url=audiovox-cdm-8300.weebly.com]audiovox cdm-8300[/url] iddjshmf [link=audiovox-cdm-8300.weebly.com]audiovox cdm-8300[/link] xeelylk [url]audiovox-cdm-8300.weebly.com[/url]