αρχάριος - All Comments

Generic viagra.

Generic viagra. — Sat, 04 Jul 2009 13:14:04 GMT

Viagra. Uk viagra sales. Viagra soft without a prescription.

Viagra hgh.

Buy cheap viagra online uk. — Sat, 04 Jul 2009 13:13:38 GMT

Viagra. Free viagra.

Buy viagra online.

Viagra studies women. — Thu, 09 Apr 2009 17:20:37 GMT

Buy viagra. Viagra prices. Compare stay erect and viagra. Viagra sale. Viagra generic. Viagra online. Viagra for women. Viagra hgh.

re: FrancisM - The Man From Manila

dee-u — Fri, 20 Mar 2009 20:37:45 GMT

The guy will surely be missed. His untimely death is just shocking.

re: FrancisM - The Man From Manila

modchip — Fri, 20 Mar 2009 05:00:49 GMT

I like his songs, especially during his days with the Hardware Syndrome.

re: FrancisM - The Man From Manila

jangilbertyniguez — Tue, 10 Mar 2009 00:04:26 GMT

FRANCIS M. ROCKS!!!

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.