Showing posts with label defaults. Show all posts
Showing posts with label defaults. Show all posts

Wednesday, March 28, 2012

Report Parameter Defaults not being used in deployed reports

When I set the default properties under Report Parameters in some
reports, it works perfectly, in other reports, the parameters specified
in Visual Studio under Report Parameters seem to have no effect when
the report is deployed to the ReportServer. The toolbar for the
parameters displays, and that is OK, but the default values don't
appear in the toolbar like they do in the other reports, and the report
doesn't run until the parameters are selected with the dropdowns. What
is causing the parameters to behave differently from one report to the
other?I have found that although you may change 'defaults' in the Report Designer,
they sometimes do not seem to take when I 'deploy' the modified report. I
don't understand why, bu my solution thus far has been to delete the report
off the report server and then redeploy it. The new/modified default values
appear.
"Kelly Gross" wrote:
> When I set the default properties under Report Parameters in some
> reports, it works perfectly, in other reports, the parameters specified
> in Visual Studio under Report Parameters seem to have no effect when
> the report is deployed to the ReportServer. The toolbar for the
> parameters displays, and that is OK, but the default values don't
> appear in the toolbar like they do in the other reports, and the report
> doesn't run until the parameters are selected with the dropdowns. What
> is causing the parameters to behave differently from one report to the
> other?
>|||Make sure your default value is your available value, otherwise it is
not working.
Kelly Gross wrote:
> When I set the default properties under Report Parameters in some
> reports, it works perfectly, in other reports, the parameters
specified
> in Visual Studio under Report Parameters seem to have no effect when
> the report is deployed to the ReportServer. The toolbar for the
> parameters displays, and that is OK, but the default values don't
> appear in the toolbar like they do in the other reports, and the
report
> doesn't run until the parameters are selected with the dropdowns.
What
> is causing the parameters to behave differently from one report to
the
> other?

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
>