A way to maintain such a bridge table with the various combinations is to build it based on known diagnoses already in the source data rather than all possible combinations...

Thanks to all for offering to help.

It turns out that another person from one of the Kimballgroup.com discussion forums, where I posted a similar question, offered up an explanation that...

David -- what would you recommend? I'm not attempting to swallow the Kimball pill blindly; I'm merely taking a moment to understand how this technique actually works.

GSquared -- yeah,...

I appreciate the quick feedback, steve.

The NDC scenario is slightly different, I think, from something like a claim with multiple diagnoses. Rather than having a fact table with multiple diagnosis...

Turns out that the problem has nothing to do with SSRS.

The data I pull from is based on a concantenation of values using FOR XML. Whenever FOR XML encounters "<"...

Thanks for the reference info, but none of the default choices are suitable.

What would the custom format string be for ensuring the string value that exists in the data...

Jack, I figured I'd find a reply from you at some point -- seen you helping others with SSRS quite a bit - very cool.

Actually, I was able to implement...

Steve Jones - Editor (12/1/2009)

I'm not sure what my passion is. It's a question I ask myself constantly, but so far nothing has struck me.... One of our plans was...

I can empathize with Steve's thoughts and feelings about his job. Having a position where the work isn't a threat to my immediate health, where I am intellectually challenged, work...

Never mind -- I discovered that the flat file source has a checkbox for "retain nulls" which I didn't notice at first. Null values are now coming through as...

Thanks, looks do-able.

I'll give it go.

--Pete

Robert Bruckner wrote a terrific article on charting for SSRS that you should read. For your particular case, he has a section on how to create your own custom set...

How about using a two-column table?

On the left column header, put your original textbox.

In the right column, populate the header and detail of the table.

Everything should lineup now.

--pete

Dave, thanks for the link to the article on uses/abuses of datetime querying. The author certainly took the time to investigate a myriad of pitfalls. Surprisingly timely!

--Pete

Bob, thanks for the heads up on the date Between gotcha. Fortunately, we've got that covered -- we store all clinical related dates (e.g., admission, discharge, date of diagnosis) as...