Hello 'Get me?'

It is never too late to answer a post and I really appreciate your help on this one. I've successfully tested the code you provided, this is just...

Hello mikehe.info, Ravi,

I am stuck in the exact same step trying to set linked reports default values and such trying to use the SetItemParameters method. My syntax is VB and...

Thank you for this input Craig.

Security matters are definitely a great concern when dealing with user inputs and dynamic SQL.

I doubt the ratio cost/benefice of such an implementation in my...

Hello Lowel,

First let me thank you for such a quick response.

Now before going any further, it is my understanding that the CONTAINS predicate can only be used with a full-text...

This is perfect. Mark, you are very impressive. Thanks again for sharing your knowledge and understanding of the SSRS platform with all of us on this community.

Cheers,

Mark, thank you for your great post.

Both you and Daniel finally convinced me that the 'dataset' approach is way better adapted for my needs.

Regards,

don

Thank you for your answer Daniel, this is another suitable answer, even though I personally prefer to deal with 'consistent' datasets.

What an awesome answer, thank you very much ! Here is what a raw attempt looks like following your tip.

gsc_dba (5/8/2012)

---

This is a very open ended question and if you have the right tools available, maintenance and scalability can be overcome.

I have tried this tool : RSScripter by Jasper...

Thank you for you answer Vedran, I will not have the opportunity to 'insert' any data.

Take care!

Wow I'm stunned - I just tweaked your code a little so that 'CLOSED' statuses are not repeated.

CTE are of great interest - I suspected that someone answering me might...

Good Day Kevin_nikolai,

Ninja's_RGR'us provided with the actual right answer for the matter at stakes here. Using the built-in field User ID seems to the best way to achieve my objective...

Thank you both for your inputs, this is much appreciated.

donbuz

Thank you Stewart.

I followed the different steps in the KB article you provided and it worked like a charm, even though I will have to read more on 'proxy accounts'...

You 'Roc' - I really doubted getting an answer here.

I better understand the behavior of SSIS. Thanks a bunch once again.

@+ JP