Showing posts with label property. Show all posts
Showing posts with label property. Show all posts

Friday, March 23, 2012

Point in time restore

Hi All
I have database that has Recovery Model property set to Full
since creation.
I have never performed backup of this database.
Is it possible to do "Point in time" restore for this database?No. All restores are based on that you have done a backup in the first place.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Denis" <trud81@.hotmail.com> wrote in message news:027701c3c486$e373e170$a001280a@.phx.gbl...
> Hi All
> I have database that has Recovery Model property set to Full
> since creation.
> I have never performed backup of this database.
> Is it possible to do "Point in time" restore for this database?
>

Saturday, February 25, 2012

Please help. How to set a Parameter in SSRS in runtime? Parameters!myParam.Value property is rea

You can set the default value of a reporting services parameter by any expression.

But with code I'm NOT allowed to do:

Parameters!myParam.Value = CDate("01.01.2007")

This is cause Value property is read-only.

So the question would be:

Are there any way I set a parameter value in runtime ?

Hope anyone can help...

Use VB.Net or C# code (Report -> Report Properties -> Code tab) to store the parameter in some shared variable. Use this variable to set and retrieve value whenever and wherever you need in the report by using the syntax Code.MySharedVar

Shyam

|||

Hi Shyam,

I have tried that also, but the problem is that the calendar control turn into a drop-down combo control when you apply either code or connect it to a dataset.

The parameter is a datetime type. As long as you add logic to the "default value" it showns the calendar control, if you add anything to "available values" the calendar disappears and a combo is shown. Any ida what I can do to keep it displaying the calendar control ?

|||

I guess you are raising a new issue now. I dont think your issue can be solved at the reporting services level.