Answer for your second question is

TargerServerURL ? http://remoteserver/ReportServer

Copy the solution to remote server and deploy

Use subscription table in Reportserver database

select * from subscriptions

Hope this will help you

Hi,

Use the below VB.Net code in Report ? Report Properties ? Code

Public Function TestFunction(ByVal Names() As Object, ByVal CompareString As String)

Dim i...

Use this

=Format(CDate(DateAdd(DateInterval.Month, -1, Fields!Next_Payment_Due_Date.Value)),"yyyyMMdd")

Use the below expression

=DateAdd(DateInterval.Month, 1, Fields!Date1.Value)

Hope it will help you

Refer http://forums.asp.net/t/1464160.aspx

Thanks a lot steve. I can understand you.

Now i clicked the process and i got the detailed error. I try to solve this myself. If i can't, i'll come back...

Thanks Steve.

I tried it but its showing the following error

Error4Errors in the OLAP storage engine: An error occurred while processing the 'SOP10200' partition of the 'SOP10200' measure...

Its Okay. Thanks Marianne.

Thanks a lot Marianne.

I tried your solution and its working fine for me.

Now another task for me is to retrieve a particular value(Measure) from cube and pass that to...

Its better to keep the seperate column (SortOrder) in your table for sorting. and assign the values in table like below

Transactions ...

Use

Properties ? Sorting ? Expression (Fields!Transaction.Value) ? Direction (Ascending)

Hi jneff,

This is possible.

Use the below function to calculate the date difference

=DATEDIFF("m", Parameters!FromDate.Value,Parameters!ToTime.Value)

Thanks Ells

Thanks GSquared