Reporting Services Subscription Table DataSettings field cut off at 256 characters!

Does anybody know why when i create a subscription using rs.CreateDataDrivenSubscription, the datasettings that is saved in the subscriptions table is cut off at 256 characters.

can anyone help?

Is the column defined as an ntext? If so then somehow your DB is corrupt. Otherwise, I have never seen this issue before.

-Daniel

Reporting Services rolling sub-total in report

Any ideas on how to add a rolling sub-total within a group of rows? Essentially I want a report to show the sum of one field up to that row.
From http://www.developmentnow.com/g/115_2005_1_0_20_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comJohn,
Try the runningvalue function in SSRS. The 3 parameters for the
function are expression, aggregate function, and scope. You ought to be
able to use this to create a running sum column, either for the report
or within your groups.
-Josh
John Marcus wrote:
> Any ideas on how to add a rolling sub-total within a group of rows? Essentially I want a report to show the sum of one field up to that row.
>
> From http://www.developmentnow.com/g/115_2005_1_0_20_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.comsql

Reporting Services Rendering

We use Reporting Services for most of our reporting needs internally. However, we do have several products that we ship out into the field that run off local databases. These applications require reporting but often are not big enough for SQL Server and rarely run on a server with IIS.

Since MS has made .RDL an open xml standard does anyone know if there are any client rendering engines being developed? We would like the ability to develop all of our reports in .RDL and have them rendered in Reporting Services or in our standalone apps that run off MSDE or Access. Currently this is not possible. But, I think that someone could write a client renderer (like Crystal Reports has) to allow the use of .RDL files off a local data source without SQL Server and Web Services.

Thanks for any info on the subject.

SmokeAs far as I understand it, the .rdl files can only be put onto a SQL Server. Basically, it seems that Microsoft wants to give you the ability to access those reports through just about anything (ASP.Net, jsp pages) that can connect to an XML web service, but the actual files themselves are proprietary to just SQL Server boxes with the reporting services installed. Have you ever thought about creating those reports on a server and connecting to them through those programs across the internet and encrypting them?

Reporting services parameter([rsFieldReference] The Value expression for the...)

@.StartDate is a report parameter and CustomerNo is the field I want to render on the report,I want to combine the sql ,but it display the error message below when I preview the report.If I query in the design form and input the value of the parameter ,it run correctly .

Data sql:

declare @.sql nvarchar(4000)
declare @.sqlWhere nvarchar(4000)

set @.sql='select CustomerNo from table1 '
set @.sqlWhere=''

if @.StartDate<>''
begin
set @.sqlWhere =@.sqlWhere + ' StartDate=''' +@.StartDate + ''''
end

if ltrim(rtrim(@.sqlWhere))<>''
begin
set @.sqlWhere =' where ' + @.sqlWhere
end
set @.sql=@.sql+@.sqlWhere

exec sp_executeSQL @.sql

Error message:

[rsFieldReference] The Value expression for the textbox ‘CustomerNo’ refers to the field ‘CustomerNo’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

I'm a beginner .Help me.

|||

Please give me a answer.

|||

I wrote a procedure and the problem is resolved.

Reporting Services Matrix

Hello
Can you add a grand total row to a matrix like a pivot table. Can you sum
up results from a column in a matrix? Maybe add a calculated field to a
matrix?Hi Randy,
Right click on the "Rows" cell of the matrix and select "Subtotal".
take care!
Michelle|||Thank you very much. This worked
"Michelle@.bwalk.com" wrote:
> Hi Randy,
> Right click on the "Rows" cell of the matrix and select "Subtotal".
> take care!
> Michelle
>|||Does anybody know how to create a calculated field in a Matrix using a
subtotal value from a matirx against another value? I have a subtotal that
is taking 2 results from a column on a matrix. I want to take the subtotal
and divide it by a value returned from the other two fileds resulted from the
column on the matrix. To get a percentage. For example:
Matrix
Held Calls Calls Total Calculated FieldIn Matrix
20 50 70 HeldCalls/Total "to get %
"Randy" wrote:
> Thank you very much. This worked
> "Michelle@.bwalk.com" wrote:
> > Hi Randy,
> >
> > Right click on the "Rows" cell of the matrix and select "Subtotal".
> >
> > take care!
> > Michelle
> >
> >|||I'm looking for a way to do this with RS as well. I haven't found a way.
I'm going to write a Stored Proc that produces these types of results and
I'll just presesnt them in a grid.
"Randy" wrote:
> Does anybody know how to create a calculated field in a Matrix using a
> subtotal value from a matirx against another value? I have a subtotal that
> is taking 2 results from a column on a matrix. I want to take the subtotal
> and divide it by a value returned from the other two fileds resulted from the
> column on the matrix. To get a percentage. For example:
> Matrix
> Held Calls Calls Total Calculated FieldIn Matrix
> 20 50 70 HeldCalls/Total "to get %
>
> "Randy" wrote:
> > Thank you very much. This worked
> >
> > "Michelle@.bwalk.com" wrote:
> >
> > > Hi Randy,
> > >
> > > Right click on the "Rows" cell of the matrix and select "Subtotal".
> > >
> > > take care!
> > > Michelle
> > >
> > >

Reporting Services Formatting Fields from whole minutes to hours

Dear All,

I have a problem formatting a field in Reporting Services (minutes to hours).

I have a field called duration which stores time in whole minutes only. I can format this into hours within mssql using the following:

cast(sn.duration/60 as varchar(5)) + ':' + RIGHT('0' + cast(sn.duration%60 as varchar(2)), 2)

But I need to have totals and average columns in my report, which means that the data must come through to RS in the minutes format so I can perform the calculations there.

I have the first part (I think!!):

=string.format("{0:0}",Fields!SalesTime.Value / 60) + ":"

But I cannot get the minutes part working!

Any help would be gratefully received.

Dan

note direction of the slash!

635

= (635\60) & ":" & 635 - ((635 \ 60) * 60)|||

Thank you,

with a little formatting it has worked a treat!!!

Dan

Reporting Services Engineering Notation

In Reporting Services, is it possible to display a field in Engineering Notation or Scientific notation? I guess can do it by adding a format code, can somebody tell me the format for those notations.

Thanks

e is the code.

By the way, you can click the ellipses (...) next to format code and see all kinds of cool codes.