Do you mean it will only work if the report viewer is used? I thought it rendered HTML so potentially a browser could be used? Is that the only way...

Hi

Currently it just renders in a browser - would be open to anything that works though as the sound is quite an important part of this.

Thanks

No but they are linked to the children of 13, or the grandchildren of 11.

Essentially I am trying to achieve the drill down effect so as long as there are...

Ah yeah that was hard coded when I was testing!

I still can't get it though to step through :

Screwdrivers > Phillips / Slotted > Big / Small

Using your execution examples,...

Sorry I missed the @level variable completely somehow. That seems to work well for the 3 tier scenario.

I tried it on the 4 tier and I can't get it to...

Jeff Moden (2/7/2012)

fahey.jonathan (2/7/2012)

What I am suggesting is that you create a...

No worries thanks for your perseverance!

I can't seem to get it to produce the correct results though.

If @levelID is set to null and h.ID is set to 1 then I...

I can't do that unfortunately as this is to be driven from user searches which I can't predict.

Thanks for all your efforts much appreciated.

It does seem to mostly work with the example data - I even put in a 4th category level and it returned that.

However it...

Ah sorry I need the next level down of category not the product level itself, so if we pass the category id of 3 (Drills) that needs to grab "Twist...

It is yep - sorry it's hard enough for me to wrap my head round what I need this to do let alone expect someone to pick up the pieces...

No I think it's me being dense sorry.

So in my result set I just want the categories that match.

So if I feed in search critera and the selected category id,...

Here goes I hope this helps - I have way oversimplified it but hopefully enough info is here :

My Category table :

CREATE TABLE [dbo].[tblCategory](

[ID] [int] NOT NULL,

[ParentID] [int] NULL,

[Name] [varchar](150)...

Don't worry all sorted - thanks anyway

It was more an approach / theory question than the actual coded answer I was after, but as I said the answer has since...

No problem - I discovered the delights of the Script Component after being crafty and searching inside one of the Wrox books on Amazon!!

Have ordered the Pro and Expert books...