αρχάριος - All Comments

re: The “ALL” Parameter In SQL Server Reporting Services 2005

marl — Tue, 21 Oct 2008 06:16:08 GMT

@Keith

"I try not to add a parameter called 'ALL' in my reports. I learned from experience that users tend to think that they are selecting everything if they don't specify any parameter thus i make use of a NULL check on my scripts."

Lol! You're right! I changed the "ALL" into "<None>" in the production report. <None> is still lame, but it is more "politically" correct than "ALL".

Please expound more on "eliminating ALL-like feature". What I originally wanted to do was just to deal with it will NULL checkbox; but I lost the checkbox when I added a "From Query" values to the parameter.

Your thoughts on this?

Thanks.

Regards,

Marl

- See you at the Code Camp @ USC

re: The “ALL” Parameter In SQL Server Reporting Services 2005

keithrull — Mon, 20 Oct 2008 23:19:12 GMT

Hi Marl,

I try not to add a parameter called 'ALL' in my reports. I learned from experience that users tend to think that they are selecting everything if they don't specify any parameter thus i make use of a NULL check on my scripts.

I agree with you that COALESCE is better than ISNULL. What i pointed out on my previous comment is just to show how to do this without 'ALL'-like feature without using a UNION ALL.

Thanks,

Keith

re: The “ALL” Parameter In SQL Server Reporting Services 2005

marl — Mon, 20 Oct 2008 20:27:35 GMT

@Keith

Thanks for the tip there! That will be helpful in my other tasks.

The data source of my drop down column is from "Select Distinct" statement (which is returning 3 columns). I do not have the "ALL" word in my column; hence, the union all:

Select 'ALL' as column1, NULL as column2, Null as column3

UNION ALL

Select Distinct column1, column2, column3

The post above pertains only to that one dropdown parameter I have in that report. So I do not need the "Where" clause because I only need the list that I needed for the parameter.

For optionality, which I will discuss later, I use COALESCE rather than ISNULL.

-Marl

re: The “ALL” Parameter In SQL Server Reporting Services 2005

keithrull — Mon, 20 Oct 2008 16:11:38 GMT

Hmmm... The better approach would be to have an ISNULL check on your WHERE clause:

WHERE Name = ISNULL(@NameParameter, Name)

This way the Name field always matches the Name value if @NameParameter is null and you don't need to write the same query over again.

;)

re: PDF to TEXT Using open-source library (PDFBox): Another Sample for Grade 1 Pupils

Bhagat — Fri, 19 Sep 2008 13:09:08 GMT

Thank you.

Provided much help.

Thanks again.

Work at home moms.

Work at home moms. — Sat, 06 Sep 2008 07:54:44 GMT

Work from home moms. Top work at home moms. Moms work from home. Work for stay at home moms.

Lexapro medication.

Lexapro. — Tue, 26 Aug 2008 20:23:42 GMT

Lexapro forum. Lexapro. Side effects of drug lexapro. Lexapro withdrawal.

Lipitor.

Lipitor banned. — Mon, 25 Aug 2008 17:50:39 GMT

Stomatitis associated with lipitor. Benefits of lipitor. Lipitor. Genaric lipitor.

Cheap zolpidem.

Zolpidem. — Thu, 07 Aug 2008 07:06:10 GMT

Zolpidem.

Cephalexin.

Cephalexin prices. — Wed, 30 Jul 2008 00:11:55 GMT

Cephalexin. Cephalexin and herpes. Cephalexin dog instructions.

Cheap zolpidem.

Zolpidem next day delivery. — Sat, 26 Jul 2008 12:31:05 GMT

Cheap zolpidem. Cheap zolpidem persriptions. Zolpidem fedex. Zolpidem with alcohol. Zolpidem abuse. Zolpidem.

Valium.

Valium. — Wed, 16 Jul 2008 08:43:16 GMT

Valium.

Vicodin and valium mix.

Valium liquid form. — Sat, 28 Jun 2008 08:28:36 GMT

Valium without prescription. What does valium look like. Valium.

Propecia.

Compare prices on propecia generic mg pill. — Sat, 28 Jun 2008 08:03:32 GMT

Propecia. Pill propecia. Propecia moins cher. Propecia side effects fre.

Valium.

Buy valium online. — Sat, 28 Jun 2008 08:02:42 GMT

Roche valium for sale. Valium no prescription. Barmeister com drink recipe italian valium. Valium.