your welcome 🙂

good luck on your work

Hi

you can use this two methods:

monthname() and year()

for example:

=monthname(month(Today))+","+cstr(year(Today))

Hi

Maybe you can create 2 new detail lines

Then join the text box on the first detail line to put the static text "Message"

and then do the same with the...

Hello

I don't get it well sorry

Do you want to dispose the cells horizontally or vertically ?

If you want to dispose the textbox freely on a matrix cell, you need to...

You re welcome 🙂

If you want to suppress the empty space, it must be set on the parent report i think

You need a flag coming from the subreport saying "no...

Yes you must set the configuration of the tablix on the subreport

- It is called something like 'no row message'

You have to put a text on it

But I am not...

Why do you use a "Parameter!" ?

Maybe you need to use a "Field!", because the call to the subreport must be linked to a data value that comes from the...

maybe the subreport element has not been correctly configured ?

How do you call the subreport ?

Are the parameters well configured ?

Is the subreport path correct ?

Hi

What element do you use ?

Matrix or table ? (i tablix row grouping only )

Hi,

What extra line are you talking about ?

I don't get it sorry.

Did you use the "group hidden properties" or the "textbox hidden properties" ?

Maybe you need to use the advanced...

Ok i understand

Why did not you used a table populating the user and the associated group ?

So the filtering can be done easily

can you repost all the dataset and the query using this parameter ?

is the parameter used on a data region in the report ?

Hi,

I wrote an article discussing about that

Maybe it can help you ?

http://www.sqlservercentral.com/articles/T-SQL/66218/

Mohamed

Maybe the parameter type is not correct ?

Can you post all the screenshot of the parameter configuration please

And the table definition

Thanks

Hi,

What is the source connection type ?

Is it SQL SERVER or other databses like ACCESS ?

I know Access has issues when using multi value parameters