sql server reporting services: Prevent Postback after selection of parameter -- sql server reporting services

RE: Prevent Postback after selection of parameter

Marc
7/3/2006 3:03:02 AM

Hi Wei

Hmmmm... well there are postpacks are happening within my report and I want
to prevent them. What do you mean by "untill the parameter is based on
another parameter"? Are that parameters which are filtred by other
parameters? Does this happen inside the dataset or at an other place?

My report parameters look like this:
- 2 Comboboxes with non-querried values
- 4 Comboboxes with mdx querried values
- 2 Datepickers

I have 7 datasets (4 ds for the parameters) and 3 result datasets for 3
tables inside the report.

The 4 mdx querries for the parameters do not use any parameter to retrieve
their result.

The 3 mdx querries for the result use all 8 parameters.

Any idea what I'm missing here? Thanks for your reply.

Marc

--
Best regards,

Marc

[quoted text, click to view]

RE: Prevent Postback after selection of parameter

Marc
7/3/2006 3:15:01 AM

another thing I do not understand. I've provided each parameter with a
default value. When I start the report inside of the report manager - why
does it start to render itself imediately?

This is a nice feature, but where can I change this?

RE: Prevent Postback after selection of parameter

weilu NO[at]SPAM online.microsoft.com
7/3/2006 6:39:24 AM

Hi Marc,

Thank you for your posting!

From your description, my understanding of this issue is: You want the
Reporting Services does not postback to render the report when you select a
parameter. If I misunderstood your concern, please feel free to let me know.

By design, Reporting Services need to postback to post the parameter to
retrieve the data from the data source.

My understanding of your concern is that the report render is too long. To
make the reporting services perform well and enhance the performance, you
could create a report snapshot and cached it. Then when you try to access
the report, it will be much more quick.

Here are some articles for your reference:

Report Caching in Reporting Services
http://msdn2.microsoft.com/en-us/library/ms155927(d=ide).aspx

Report Snapshots
http://msdn2.microsoft.com/en-us/library/ms157204(d=ide).aspx

Hope this will be helpful!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights

RE: Prevent Postback after selection of parameter

weilu NO[at]SPAM online.microsoft.com
7/3/2006 8:02:05 AM

Hi Marc,

Thank you for your reply!

Based on my scope, when you select a parameter, the report will not
postback untill the parameter is based on another parameter.

If all your parameter is seperated, it will not postback untill you click
the View Report Button.

Hope this information will be helpful.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Re: Prevent Postback after selection of parameter

smithy
7/3/2006 8:10:11 AM

Hi Marc,
This is because when you deployed the reports you had the defaults
filled in.
To overcome this, when you are in report manager, click on the show
details tab (to the right of the screen).
Select your report. Select Properties from the top menu. On the
left-hand side menu, select parameters then uncheck the has default
check box.

Hope this helps.
[quoted text, click to view]

RE: Prevent Postback after selection of parameter

Marc
7/3/2006 8:42:03 AM

I did some testing - it showed when I'm not using a default value I can
prevent the postback behavior. Strange.

RE: Prevent Postback after selection of parameter

weilu NO[at]SPAM online.microsoft.com
7/4/2006 5:20:31 AM

Hi Marc,

Thank you for your reply.

I just wonder whether not using the default value could meet your
requirement.

Based on my research, if you are seeing non-dependant parameters displayed
as dependencies, it may be because the parameter uses a complex expression
and the server can't definitively tell if the dependency exists.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

RE: Prevent Postback after selection of parameter

weilu NO[at]SPAM online.microsoft.com
7/7/2006 12:00:00 AM

Hi Marc,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

RE: Prevent Postback after selection of parameter

Marc
7/7/2006 8:23:02 AM

Hi Wei

thanks for asking. Unfortunately I had other issues to follow - but I still
have not solved this issue. I will post next week.

Have a nice weekend,

RE: Prevent Postback after selection of parameter

Marc
7/10/2006 11:27:02 PM

Hi Wei

Yes, you right. I'm using quiet complex mdx expressions (at least I think
so) with about 50 lines of code.

Can I deactivate this default behavior of Reporting Services so post backs
do not happen when the server can't definitively tell if the dependency
exists?

RE: Prevent Postback after selection of parameter

weilu NO[at]SPAM online.microsoft.com
7/12/2006 12:00:00 AM

Hi Marc,

Thank you for the update. Unfortuantely, we could not prevent this by
design behavior.

As you have mentioned, if you do not use the default value, the report does
not postback. Is this meet your requirement?

If not, and this impacts your business, I would like to suggest that you
contact Microsoft Product Support Services via telephone so that a
dedicated Support Professional can assist with this request. Please be
advised that contacting phone support will be a charged call. However, if
you are simply requesting a hotfix be sent to you and no other support then
charges are usually refunded or waived.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.

http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com
for regional support phone numbers.

Thank you for your patience and understanding.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.