I don't think it's possible to control the availability (visibility) of parameter prompts, conditionally, in SSRS.

At best, I think you can control only the values available in the parameter prompts....

I think the combination of LESS_THAN_60 and EpisodeGroup will give you a unique group, so try combining them

SELECT ROWNUM,FROM_DATE,TO_DATE,DAYS,LESS_THAN_60,

LESS_THAN_60 + 2*(ROW_NUMBER() OVER(ORDER BY...

Argh! Mark's solution almost works....

I've discovered a scenario where the distinct EpisodeGroup misses the mark. Below is the sql script to create/populate the sample data that ends up with incorrect...

Mark (9/2/2009)

---

Try this

SELECT ROWNUM,FROM_DATE,TO_DATE,CNT_DAYS,LESS_THAN_60,

ROW_NUMBER() OVER(ORDER BY FROM_DATE)-

ROW_NUMBER() OVER(PARTITION BY LESS_THAN_60 ORDER BY FROM_DATE) AS EpisodeGroup

FROM #tbl_EpisodeGroup

ORDER...

drew.allen (9/2/2009)

---

peterzeke (9/2/2009)

---

To Drew Allen: if you look carefully at the data, you'll see that the datediff ("DAYS") between FROM_DATE (March 4, 2005) and TO_DATE (June 6, 2005) for row...

Thanks for taking a look, J F: Here's the code to create the sample table and populate it.

IF OBJECT_ID('TEMPDB..#tbl_EpisodeGroup') IS NOT NULL

DROP TABLE #tbl_EpisodeGroup

CREATE TABLE #tbl_EpisodeGroup(

[ROWNUM] int NULL,

[FROM_DATE] [datetime]...

Hello Achiever:

Here are some basic steps to take (which work in SSRS2005, probably will work in 2000 or 2008 too).

1) First, add your watermark image as an embedded image...

I "tweeked" Jack's attached report example to look a little closer to a treeview.

--Pete

Although your question asks how to parse out the various choices from the comma-delimited list, I can only assume that you don't have IDs associated with these various choices. By...

Based on your screenshot, it seems to me you could accomplish your goal by doing a couple of things:

1) Extend the height of the table footer by making its bottom...

What exactly are you trying to do?

Based on your request, I imagine you're trying to create either a horizontal or vertical line that is a border to a table.

What's the...

I've witnessed the same problem in SSRS 2005 Report Manager, too. The report is designed and displayed perfectly in BIDS, but fails to render the same in Report Manager. Viewing...

Just a thought... double-check if your data is uppercase/lowercase. I've sometimes run into issues with SSRS being case-sensitive when evaluating values (i.e, If..Then).

jcrawf02 (6/12/2009)

---

I wish I hadn't blown five years of college on a Jazz Performance degree that I now don't use, as much fun as it was....

Professionally, no regrets, I've been...

Try using an exclamation point (bang= !) at the beginning of your input mask. The ! should force data entry to begin at the left of the field.

here's a...