Date Parameter

Hi there,
My report needs 4 parameters. So as normal the report opens up and you fill
in the parameters at the top. Fill in the parameters. Generate report and
all is good. But now, Is there a way to fill thouse top parameter fields
when populating the report initialy? The problem comes in with the date
parameter field. I don't want the user to type it in and Im working on 2000
so I dont have the calendar Control. So I want to pass it through from a
normal web app. In my Web App I have an IFRAME. In my IFRAME is my report.
Now I was thinking to put a calendar control in my web app and pass that date
value through. Is this possible? Any help would be much appreciated.
Thnx in advanceReplying on my own post but hopefully this helps someone.
I wanted to pass values from my asp.net to my Reporting Service. It is very
easy once you know but if you're new like me this can be tricky.
Well all you need to do is add the parameters at the end of your URL.
For example if you have a date field called BeginDate in you report your URL
should look something like this:
http://serv/reportserver?/path&BeginDate=myParamValue
So when you populate your report that value will be there.
While I was searching for this answer I found some other usefill tips. This
is for inside your report and if you want to use a parameter.
Parameters!BeginDate.Value
Hope this helps
"Joe" wrote:
> Hi there,
> My report needs 4 parameters. So as normal the report opens up and you fill
> in the parameters at the top. Fill in the parameters. Generate report and
> all is good. But now, Is there a way to fill thouse top parameter fields
> when populating the report initialy? The problem comes in with the date
> parameter field. I don't want the user to type it in and Im working on 2000
> so I dont have the calendar Control. So I want to pass it through from a
> normal web app. In my Web App I have an IFRAME. In my IFRAME is my report.
> Now I was thinking to put a calendar control in my web app and pass that date
> value through. Is this possible? Any help would be much appreciated.
> Thnx in advance

Date Format in expression

Hi all,

I would like to generate a file name according to the current date, like 20070716.TXT. In expression, the function Month(Getdate()) will return 7 instead of 07.

How can i do it.

TIA

Patrick

Try this... Going by memory.

RIGHT("00" + (DT_WSTR,50)MONTH([DateColumn])),2)

|||

Start for using this...

=Format(cdate(Fields!Dia.Value),"dd-MM-yyyy")

and concactenate with string you want!!

regards

|||

PedroCGD wrote:

Start for using this...

=Format(cdate(Fields!Dia.Value),"dd-MM-yyyy")

and concactenate with string you want!!

regards

In SSIS? Looks like Excel or something to me.