Report parameter - First day of last month/last day of month

can somebody pls. help me with the following report parameter defaults?
for a monthly report I need two dates as parameter defaults:
The first day of the last month
and
the last day of last month
If I run a report on - let's say March 1st, I can get the last day of the
last month with
=Today.AddDays(-1)
and the first day of the last month with
=Today.AddMonths(-1)
However, I need these paramers to work every day. For example, I want to be
able to run the report on March 3rd or March 15th, and the report should also
have February 1st and February 28th as start and end dates.
How can I do this?
Thank you for helping,
MartinHi Martin,
This will work everyday. start and end date of last month.
start date - str(year(today)) + "/" + str(month(today)-1) + "/1"
End Date - dateadd("d",-1, (str(year(today)) + "/" + str(month(today)) +
"/1"))
Now the date format ie dd/mm/yy or mm/dd/yy etc... I hope you can change it.
Amarnath
"Martin" wrote:
> can somebody pls. help me with the following report parameter defaults?
> for a monthly report I need two dates as parameter defaults:
> The first day of the last month
> and
> the last day of last month
> If I run a report on - let's say March 1st, I can get the last day of the
> last month with
> =Today.AddDays(-1)
> and the first day of the last month with
> =Today.AddMonths(-1)
> However, I need these paramers to work every day. For example, I want to be
> able to run the report on March 3rd or March 15th, and the report should also
> have February 1st and February 28th as start and end dates.
> How can I do this?
> Thank you for helping,
> Martin
>

report is always one page regardless of how long it is...could somebody help?

Hi anyone,

my problem is a bit simillar with harry but we are making a report and when viewing it, we still see one page even how long the report is, I had viewed the XML code and search fot the property InteractiveHeight but I found out it has 8.5 by 11in on its page height...but still when viewing it has too long one page report

Can anyone help me with this? thanks a lot... we need to cut the report in pages.....God Speed

Hi,

where are you experiencing the long Report. If you mean within the report HTML view, you might have a look on the PDF rendered format. That differs to the HTMl ouput.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||We are experiencing a long report upon generating the report bu cliking the view report button. the report is generaed successfully but still it has only one page even how long the report is...thank you