Parameter is not getting defauilt value

I have a numeric parameter that does not get its default value when I deploy
the report. It works fine in report designer preview.
Is that a bug?Mark,
This behaviour is by design.
Once a report has been deployed, if you reconfigure the default value for a
particular parameter through the Report Manager then that will take
precedence over any default values that you subsequently include in the RDL
that you may re-deploy.
The rationale behind these kind of things is that the Report Administrator
is King - if the Report Administrator has manually set something on the
Report Manager to be overridden then it is not welcome that a Report
Developer comes along and overwrites such a setting.
Bill and my book gives in-depth treatment of Report Parameters on pages
283 - 292 and p286 explains the feature you are experiencing.
Best Wishes.
Peter Blackburn
Hitchhiker's Guide to SQL Server 2000 Reporting Services
www.sqlreportingservices.net
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:72E5761D-D8FA-42D4-8B03-FC7FDB83C466@.microsoft.com...
>I have a numeric parameter that does not get its default value when I
>deploy
> the report. It works fine in report designer preview.
> Is that a bug?|||What I dont understand is it's by design.
For it looks like a bug.
Let's say I have a report with a parameter that has to be entered by the user.
Later on the user decides to have a default value for that paramter.
But I cannot do it because the has entered the value for the parameter at
least once.
Am I correct?
"Peter Blackburn (www.sqlreportingservice" wrote:
> Mark,
> This behaviour is by design.
> Once a report has been deployed, if you reconfigure the default value for a
> particular parameter through the Report Manager then that will take
> precedence over any default values that you subsequently include in the RDL
> that you may re-deploy.
> The rationale behind these kind of things is that the Report Administrator
> is King - if the Report Administrator has manually set something on the
> Report Manager to be overridden then it is not welcome that a Report
> Developer comes along and overwrites such a setting.
> Bill and my book gives in-depth treatment of Report Parameters on pages
> 283 - 292 and p286 explains the feature you are experiencing.
> Best Wishes.
> Peter Blackburn
> Hitchhiker's Guide to SQL Server 2000 Reporting Services
> www.sqlreportingservices.net
>
> "Mark" <Mark@.discussions.microsoft.com> wrote in message
> news:72E5761D-D8FA-42D4-8B03-FC7FDB83C466@.microsoft.com...
> >I have a numeric parameter that does not get its default value when I
> >deploy
> > the report. It works fine in report designer preview.
> > Is that a bug?
>
>sql

Paging of Records

Hi all,

I have a stored procedure which takes 4 parameters

@.Page Numeric, @.Size Numeric, @.SQL VARCHAR(75), @.COUNT = 0 NUMERIC OUTPUT

In @.SQL variable a SQL querry is passed on which I don't know. Based on this sql querry page and the size I have to return the recordset with limited records and total rows in the fetched from SQL Querry as OUT parameter. Please help me out.

Thanx in advance

AmitI was doing paging like this:

-SP does have parameters - show page#, lines per page;
-create temporary table with identity;
-insert data to temporary table (include sorting);
-select and return page (not big deal if you know page# )
- select and return totals for columns (if it needs)
- output parameter- total pages.

It is very simple and very effective method (it does have potential problems but it works for many cases).|||Hi Snail,

Thank you for your reply. But I think one thing you are missing is that we have a dynamic querry. So please consider this point and help me out.

--Amit|||Originally posted by amitarora7
Hi Snail,

Thank you for your reply. But I think one thing you are missing is that we have a dynamic querry. So please consider this point and help me out.

--Amit
I had dynamic query too. I will try to find code for this sp and post it.

Anyway check this query - how it is possible to create temporary table:

SELECT *,IDENTITY(int, 1, 1) AS newid
INTO #tmp
FROM sysobjects|||Check this code: sp and asp page with paging. It is a little complicated but you could find the main idea.