Tuesday, March 20, 2012

report starts processing immediately

Hello,
my report starts processing immediately when I switch to preview window in
VS (or click on it in the Web Browser).
I know it's because it has some string parameters (with list of available
values and default value defined) & 2 datetime parameters that allow null
values. When I remove default values or uncheck "allow null value" the
report waits untill I specify params. I suppose it is not convenient to work
with. Happily, my report calculates fast.
Are you going to fix this in the future releases?fix what?
This isn't desired behavior?
"Lesha Akulinin" <leshaakulinin@.mail.ru> wrote in message
news:ew9ITm$bEHA.2812@.TK2MSFTNGP11.phx.gbl...
> Hello,
> my report starts processing immediately when I switch to preview window in
> VS (or click on it in the Web Browser).
> I know it's because it has some string parameters (with list of available
> values and default value defined) & 2 datetime parameters that allow null
> values. When I remove default values or uncheck "allow null value" the
> report waits untill I specify params. I suppose it is not convenient to
work
> with. Happily, my report calculates fast.
> Are you going to fix this in the future releases?
>|||Ok, suppose, I want a report that can be for the last week, last month or
any other period that the user can specify (the fisrt two options is for
subscription). I'm creating 3 params: period type (last week, last month,
other) and two datetime parameters -- start date, end date (checking "allow
null value" to use them in subscriptions. Did I do anything wrong? May be
there is a better way?
"G" <brian.grant@.si-intl-kc.com> ñîîáùèë/ñîîáùèëà â íîâîñòÿõ ñëåäóþùåå:
news:OxrbQu$bEHA.808@.tk2msftngp13.phx.gbl...
> fix what?
> This isn't desired behavior?
>
> "Lesha Akulinin" <leshaakulinin@.mail.ru> wrote in message
> news:ew9ITm$bEHA.2812@.TK2MSFTNGP11.phx.gbl...
> > Hello,
> >
> > my report starts processing immediately when I switch to preview window
in
> > VS (or click on it in the Web Browser).
> >
> > I know it's because it has some string parameters (with list of
available
> > values and default value defined) & 2 datetime parameters that allow
null
> > values. When I remove default values or uncheck "allow null value" the
> > report waits untill I specify params. I suppose it is not convenient to
> work
> > with. Happily, my report calculates fast.
> >
> > Are you going to fix this in the future releases?
> >
> >
>|||I too have seen this behavior and agree that it is not the best. Just
because I have assigned defaults to the parameters does not mean I want it
to execute without any intervention on the users part. They should need to
click, hit enter. I.e. they should have to do the same thing they do after
selecting a parameter for the report to run. So, I did as you did. I leave
at least one report without a default so it waits for user interaction
before running.
Bruce L-C
"Lesha Akulinin" <leshaakulinin@.mail.ru> wrote in message
news:e0e%23mJAcEHA.3300@.TK2MSFTNGP09.phx.gbl...
> Ok, suppose, I want a report that can be for the last week, last month or
> any other period that the user can specify (the fisrt two options is for
> subscription). I'm creating 3 params: period type (last week, last month,
> other) and two datetime parameters -- start date, end date (checking
"allow
> null value" to use them in subscriptions. Did I do anything wrong? May be
> there is a better way?
> "G" <brian.grant@.si-intl-kc.com> ñîîáùèë/ñîîáùèëà â íîâîñòÿõ ñëåäóþùåå:
> news:OxrbQu$bEHA.808@.tk2msftngp13.phx.gbl...
> > fix what?
> >
> > This isn't desired behavior?
> >
> >
> > "Lesha Akulinin" <leshaakulinin@.mail.ru> wrote in message
> > news:ew9ITm$bEHA.2812@.TK2MSFTNGP11.phx.gbl...
> > > Hello,
> > >
> > > my report starts processing immediately when I switch to preview
window
> in
> > > VS (or click on it in the Web Browser).
> > >
> > > I know it's because it has some string parameters (with list of
> available
> > > values and default value defined) & 2 datetime parameters that allow
> null
> > > values. When I remove default values or uncheck "allow null value" the
> > > report waits untill I specify params. I suppose it is not convenient
to
> > work
> > > with. Happily, my report calculates fast.
> > >
> > > Are you going to fix this in the future releases?
> > >
> > >
> >
> >
>|||It would be good to have an option to execute the report automatically
or not when the parameters are all valid.
In my case - after the user has selected all the parameters, he still
has to click 'view report' in the browser. I wish I could set it that
any parameter he changes, as long they are valid... execute the query.
My queries are small.. and go to OLAP... so are very quick.
People like to see action without much effort!!
And of course - sometimes it is better to click the view report -
specially if the query is large...

No comments:

Post a Comment