Sorry, probably I have explained badly. I'm looking for something like "justify" in Microsoft Word.

The ReportServer and ReportServerTempDB built with a differente version of SQL Server.

1) Backup your EncryptionKey

2) Backup ReportServer DB

3) Delete old ReportServer and ReportServerTempDB

4) Create new databases from Reporting Services...

Honestly i've never buil datasource programmaticaly but you can look at this:

http://stackoverflow.com/questions/2360992/binding-a-datasource-to-a-rdl-in-report-server-programmatically-ssrs

I don't know if this is the best solution....sorry

The DataSourceID depends on your Reporting Services Instance.

It's not so simple. Are you using the SQL Connection Wizard for building the connection String?

You are missing two elements: SecurityType and DatabaseID. Take a look at this:

<DataSources>

...

Sorry but i don't undestand. Do you need 3 pages, one for tom, one for jerry and one for jim with a chart inside?

So use a list and a chart...

Can you attach a Design View of your Report?

Mmhhhh, strange. At Report level, take a look at InteractiveSize and PageSize properties. Interactive size is for HTML Rendering. PageSize is for PDF, Word, Excel, ecc....

Set a page break after...

You have a problem with category Axis. Change Group Expression from longDateTime to this one:

=DateSerial(Year(Fields!logdatetime.Value),

Month(Fields!logdatetime.Value),

Day(Fields!logdatetime.Value))

It will work

Thanks Martin

Little better:

select A.[Product Id] as ProductId,

'-' as SubProductId,

(

select exp(sum(log(quantity))) from product_table B

where isprimary = 0

and patindex(ltrim(rtrim(A.[Product Id]))+'.%',B.[Product Id]) > 0

) as Value

from product_table A

where

A.isPrimary = 1...

A Simple solution:

select A.[Product Id],

(

select exp(sum(log(quantity))) from product_table B

where isprimary = 0

and charindex(ltrim(rtrim(A.[Product Id]))+'.',B.[Product Id]) > 0

) as Value

from product_table A

where

A.isPrimary = 1

Union

select A.[Product Id],Null as Value

from...

It'easy with a Pie Chart.

With a Bar Chart you have to rearrange your Dataset and aggregate your small data in a single slice.

Hope that it' works.

Merry Christmas to you 🙂