You have been hit with the most common issue with Reporting Services. Reporting Services encrypt all passwords by default. Otherwise it won't store them. The default behavior is...

What is the datatype of the "Delta" field? I suspect that it is a real or a float. If so, it is possible that what you think of...

See if the following help:

Report format:

http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/Santa+gets+an+RDL+present/61782/

Getting information from msdb about the jobs

http://www.sqlservercentral.com/articles/SQL+Server+Agent/67726/

http://www.sqlservercentral.com/articles/SQL+Agent/67815/

Where does the variable "User::Content" get populated? Maybe there is where the version number needs to be added.

SQL assumes that you want all of the columns to be part of one element.

It is very similar to putting "td/@style" = 'color:red', "td/@width" = "55pt", td = ProductID

When...

Would something like the following help?

declare @t table (xmlcol xml);

declare @add_amount varchar(20);

set @add_amount = 'three hundred';

insert @t values ('<t>

<v>test</v><v>test2</v>

</t>

')

update @t

set xmlcol.modify ('insert <v>test2</v> into (/t)[1]')

update @t

set...

Is D a local drive or a mapped network drive?

Try using the pivot operator. You will have a fix number of columns.

declare @xml xml;

set @xml = '<Answers>

<AnswerSet>

<Answer questionId="q1">4</Answer>

<Answer questionId="q2" />

<Answer questionId="q3">3</Answer>

</AnswerSet>

</Answers>'

declare @t table (num int);

declare @count int;

declare @lastCol...

Is there any relationship between the Qorder 1 items and the following Qorder 2 items or

Qorder Question

1 ...

Are the Report Properties page size and interactive size settings what you expect? Check the margins as well.

Try

Insert into User_Cust (user_id, cust_no)

select distinct user_id, cust_no

from USERS_APPLS left join User_Cust

on USERS_APPLS.user_id = User_Cust.user_id

and USERS_APPLS.cust_no = User_Cust.cust_no

where User_Cust.user_id is null

You should be able to just identify where the report server database is.

Also, you may need to restore the encryption key from the previous server to the current server.

"Cannot insert the value NULL into column 'Ecnounter_Duplicate_ID'" The problem is that your dataflow is not providing a value for the column 'Ecnounter_Duplicate_ID' and a value is required. ...

Another way to handle this is to add an output to your script component. You would add a row to the second output with the information that you want...

I would use a conditional split.

http://sqlblog.com/blogs/andy_leonard/archive/2009/02/20/ssis-expression-language-and-the-conditional-split-transformation.aspx

http://msdn.microsoft.com/en-us/library/ms137886.aspx

Basically if a column has the value you expect then send it to the main output. Otherwise send to your...