default values

Is it possible to set report parameter of type datetime on current date in case when user don't specify value?
Thx.Yes you can and it's dead easy.
In the Report Parameters dialog, in the Default Values section at the borrom of the form, select Non-queried and use the following expression:
=Globals!ExecutionTime
That'll insert the exact date and time of when the report is run as a default value if one isn't entered.
DF
"AG, NLB d.d." wrote:
> Is it possible to set report parameter of type datetime on current date in case when user don't specify value?
> Thx.|||is it possible to make yesterday as default value?
>--Original Message--
>Yes you can and it's dead easy.
>In the Report Parameters dialog, in the Default Values
section at the borrom of the form, select Non-queried and
use the following expression:
>=Globals!ExecutionTime
>That'll insert the exact date and time of when the report
is run as a default value if one isn't entered.
>DF
>"AG, NLB d.d." wrote:
>> Is it possible to set report parameter of type datetime
on current date in case when user don't specify value?
>> Thx.
>.
>

Default value for lookup

How can I specify a default value to return into the lookup field for Lookup Transformation - if the value did not found on the Reference Table?

Do I have to this another way? (after doing the lookup)

/Yossi D.Perhaps you could go to the Advanced tab and adjust the lookup query SQL to return a default value. (I haven't tried it.)

Or

Set the error option to ignore, so your rows that failed to return a value just flow down the main output with null values. You can then use a Derived Column to test for NULL and assign the default value.

Default rendering by report.

Hi All,
Is it possible in RS 2000/2005 to specify a default rendering by
report, within the report manager web page. For example i have a data
extract that users will dump into execl/access so they never want to
see a pretty html rendering so i want that to go straight to csv, other
reports may render straight to pdf or html. I realise i could acheive
this by creating my own report manager, but i think this is quite a
sensible option to expect from the MS report manager.
Thanks for any assistance.
BenI have a user who only likes Excel.
So I created a report that doesn't read any data but consists of some
textboxes. They're formatted in a fancy way to look like buttons. In
the properties | Navigation tab of the textbox I navigate to a URL
which is the "URL access" form (look this up in BOL) for running
reports, from which you can specify parameters, rendering formats, how
much of the RS interface is shown (i.e. parameters, toolbars, document
maps etc.)
It's easy to do and requires no more than for you to look up the URL
access syntax. My user is very happy with this arrangement!
--
Regards
Chris
benaud@.gmail.com wrote:
> Hi All,
> Is it possible in RS 2000/2005 to specify a default rendering by
> report, within the report manager web page. For example i have a data
> extract that users will dump into execl/access so they never want to
> see a pretty html rendering so i want that to go straight to csv,
> other reports may render straight to pdf or html. I realise i could
> acheive this by creating my own report manager, but i think this is
> quite a sensible option to expect from the MS report manager.
> Thanks for any assistance.
> Ben|||Thanks Chris, This is a nice workaround cause it maintains the security
of the report manager... If theres no in-built way of doing what i
want then I will set it up like you suggest. But don't you agree that
the default rendering should be configurable by report?
Ben|||Oh yes, I do agree. There is a wishlist somewhere on microsofts web
site!
--
Regards
Chris
benaud@.gmail.com wrote:
> Thanks Chris, This is a nice workaround cause it maintains the
> security of the report manager... If theres no in-built way of doing
> what i want then I will set it up like you suggest. But don't you
> agree that the default rendering should be configurable by report?
> Ben