And by this you mean the service account that's calling the agent jobs correct?

Wow - if so, then to be honest SQL Server 2012 is sure...

Out of curiosity what OS is your server running on?

I had an issue that may be related to this sometime back and it had to do with our current migration...

Can i just add my two cents to this topic. I have never been able to run Agent jobs with any other account aside from a proxy account.

Not sure...

OK thanks Gila and Happy. Sucks this is the only option I have but it is what it is.

Thanks again

So here's the thought process I was thinking of and thanks for bringing that to light.

In the function i create (while not yet coded) i was going to essentially...

Good Morning Happy

Great suggestion on the UDF. To be honest i didnt think about that option. Ill give it a shot this morning and see what the outcome is. To...

So yeah

Thanks - didnt even check to see thats why the parameters were hidden.

So im still at a standstill as to why i am unable to change the child...

First off - need to apologize for posting this question to the wrong forum. This should have been in Reporting Services and not Reporting Services 2005.

Anyhoo. Thanks for getting back....

Not sure if this answers you.

I had a similar request to create a URL on an existing report to download open/render a report directly in pdf. My report had a...

• This reply was modified 5 years, 7 months ago by  ttdeveloper.
• This reply was modified 4 years, 3 months ago by  Dave Convery.
• This reply was modified 4 years, 3 months ago by  Dave Convery.

Yes - thats what im doing.. The value expression of the textbox is set to code...

The format expression for the textbox is my problem.

Hey..

I actually had to do this yesterday.

If you have an action button as a URL link - code to

Action - go to URL

Heres an example of mine

="http://ohtwi1sql002/ReportServer_BGCO/Pages/ReportViewer.aspx?%2fDEV+AND+QA%2fDirector+Scorecard%2fBGCO+Summary+pdf_print&rs:Format=PDF&year="...

Hey Mr Magoo

Thanks for getting back. Yes - in answer to your question, that formatting holds fine.

Heres my report custom code

Dim QuarterTotal As Integer

Function AddQuarterVals (ByVal FirstQuarterVal As Integer)...

So in a nutshell, I am unable to apply textbox formatting using the expression option in the format properties when the value of the textbox is coming from custom code....

So i had this question posted on the MSDN Analysis Server Forum and got some help.

All I was trying to do was evaluate the currentmember of the the Dim Date...

Thanks Martin.

So I started tested with you code before I realised the .currentmember property only works at Hierarchy level.

I modified my code to now look like the below....