Thanks you very much. It works this time.

I have tried it, but I didn't work

The report execute successful, but the format is not effective. Actual it views the format as default (original)

Hi,

Make your enddate dataset to reference plus 30 days of the startdate:

Select date

from Table_Date

where Date BETWEEN Startdate AND (Startdate+ 30)

ON the Enddate prompt parameter put the note...

Please google "Downloads SSRS manual"

I have done that but it does not show the vertical line.

In the past I did numeorus two type charts and it worked fine but with a 100% stack...

I tried that already but the subresport was still giving me the same problem. I sorted the problem by including my selected parameters on the select query and point my...

Create report datasets for each select, then your problem will be simple solved just like that:-D

Perfect answer, actual i was trying to insert =Today() on the report subscription date parameter without thinking on making it a default value on my report design.

Thank you very much....

For myquery, it should read

SELECT *

FROM Mytable

WHERE Country IN (@Country)

rather than

SELECT *

FROM Mytable

WHERE Country =@Country

It is only necessary to do it this way when using multiple parameter values.

Hi,

My Parameter is a multi select parameters and when I declare my parameter on the WHERE Clause is not allowing WHERE IN @Company , it only allows single select parameter...

Thanks for the respond. This is too much for me to understand. I still new in SQL.

When I try to create the table it complained but did managed to fix...

Hi Thanks you very much for the respond.

I just have a problem with your code. When I try dates that includes weekends, I got this message:

(Start Saturday 12H00 and End...

I have learned to convert the field values data types. I was wrong when I thought you can simple convert it from the property window format portion.

Thank, It worked perfectly

All the best