Hello, Thank you the response.

The executionLog3 table seems to have all the executions of that report. If I have two subscriptions set up on the same report, how do I...

That makes sense , thank you for the answer.

Was the issue mentioned in this post fixed? I am using a proxy to run and it gives me the exact same error. Please suggesr

Hi,

I used the solution suggested in the link below with few minor changes:

http://www.sqlservercentral.com/blogs/data-adventures/2014/08/27/ssrs-report-multi-value-parameter-going-after-data-driven-subscription/

Thank you,

Veena

The error was with the parameter Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: , Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'column_desc' is not a valid value.;

The issue is that the comma...

Hers is the expression I used to get the average which works:

Format(DateAdd("s",avg(DateDiff(DateInterval.Second,Fields!BeginDate.Value,Fields!EndDate.Value)), "00:00:00"),"HH:mm:ss")

Thank you All

yeah, that makes sense. I think I will go down that route. Thank you very much all 🙂

Would shared data sets be possible for reports in different solutions?

Thank you,

Vena

thank you for the quick reply.

We kind of have a standardized Master Package layout and cannot make much changes to it. If there is anything I could do withing the...

Thank you for the suggestions. Ran a trace and found that the statistics were out of date which caused some partitions to process very slow.

Thank you,

Veena

In addition to the problem stated above, I see that the cube processing times have been increasing rapidly for a process that runs once every month. Every month I see...

Hi Alan/Chris,

Sorry, I did not post my original query since I didn't want to post the orig code. But all those parts are needed for my case. I wrote something...

anyone can think of anything for this one. I have n't been able to figure it. Thanks

thank you neha

herladygeekedness (10/9/2012)

---

I know what that link said, but I can absolutely confirm that when I use script component as a transform that it is called Per Input Row, not per...