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

Parameter Error on Deployment

New to report services and trying out my first report. I have a report with a simple parameter lookup. When I preview it in Visual Studio it works fine. I can select the parameter value and it returns back the correct information.

When trying to preview the deployed version of the report I get the following error after selecting the parameter value and clicking preview. I am not sure where I need to declare the variable @.owners.

Thanks

Reporting Services Error

---

An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for data set 'ANDON'. (rsErrorExecutingCommand) Get Online Help ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the variable '@.Owners'.

---

Microsoft Reporting Services

I guess you are using @.Owner in your sql query and not defined it as a parameter for that dataset.

So in Data tab, select the dataset Edit the dataset by clicking on "..." button. and go to Paramaters tab. Type @.Owner under Name column and type "=Parameters!Owner.Value".

I'm asssuimg that Owner is already defined as one of the report parameters (Report -> Report Parameters). If not, create this parameter and then do the above.

Shyam

|||

Thanks for the response.

I have my SQL query defined as

SELECT idfld, andon, createdate, issuetype, origname, owner, notes, outcome, responded, resolution
FROM dbo.issue
WHERE (owner = @.Owner)

I went into the Data Tab/Parameters Tab and @.Owner = Parameters!Owner.value was already set

In my report parameters I have Owner defined and it is pulling information from a Select Distinct owner query.

Still works in the view mode and I still get the error when I look at the deployed report.

|||

I guess you have set Available values for your parameter from a query. Try setting a default value for your parameter.

Shyam

|||

Yes, I am getting the values for my parameter from a query. I tried setting a default value and I still get the same error.

|||

Is your parameter multi-valued?

Also check the following link:

http://msdn2.microsoft.com/en-us/library/aa337223.aspx

What is the provider type you are using on your report server and on your local machine (from visual studio)? Based on that check how you should handle as described in the link above.

Shyam

|||

"What is the provider type you are using on your report server and on your local machine (from visual studio)? "

That was the key. I had to modify the data source on the Reports Server to match what I was using on my report. Thanks!

|||make sure that the parameter is consistent throughout your code. Parameters are case sensitive - In your post, the error message referred to @.Owners - with an "s". In your posts it was referred to as @.Owner and @.owner. Reporting services sends the error when there is any difference between the report parameter in the parameter drop down and its references in the underlying code.

Parameter Error on Deployment

New to report services and trying out my first report. I have a report with a simple parameter lookup. When I preview it in Visual Studio it works fine. I can select the parameter value and it returns back the correct information.

When trying to preview the deployed version of the report I get the following error after selecting the parameter value and clicking preview. I am not sure where I need to declare the variable @.owners.

Thanks

Reporting Services Error

---

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Query execution failed for data set 'ANDON'. (rsErrorExecutingCommand) Get Online Help

ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the variable '@.Owners'.

---

Microsoft Reporting Services

I guess you are using @.Owner in your sql query and not defined it as a parameter for that dataset.

So in Data tab, select the dataset Edit the dataset by clicking on "..." button. and go to Paramaters tab. Type @.Owner under Name column and type "=Parameters!Owner.Value".

I'm asssuimg that Owner is already defined as one of the report parameters (Report -> Report Parameters). If not, create this parameter and then do the above.

Shyam

|||

Thanks for the response.

I have my SQL query defined as

SELECT idfld, andon, createdate, issuetype, origname, owner, notes, outcome, responded, resolution
FROM dbo.issue
WHERE (owner = @.Owner)

I went into the Data Tab/Parameters Tab and @.Owner = Parameters!Owner.value was already set

In my report parameters I have Owner defined and it is pulling information from a Select Distinct owner query.

Still works in the view mode and I still get the error when I look at the deployed report.

|||

I guess you have set Available values for your parameter from a query. Try setting a default value for your parameter.

Shyam

|||

Yes, I am getting the values for my parameter from a query. I tried setting a default value and I still get the same error.

|||

Is your parameter multi-valued?

Also check the following link:

http://msdn2.microsoft.com/en-us/library/aa337223.aspx

What is the provider type you are using on your report server and on your local machine (from visual studio)? Based on that check how you should handle as described in the link above.

Shyam

|||

"What is the provider type you are using on your report server and on your local machine (from visual studio)? "

That was the key. I had to modify the data source on the Reports Server to match what I was using on my report. Thanks!

|||make sure that the parameter is consistent throughout your code. Parameters are case sensitive - In your post, the error message referred to @.Owners - with an "s". In your posts it was referred to as @.Owner and @.owner. Reporting services sends the error when there is any difference between the report parameter in the parameter drop down and its references in the underlying code.sql

Pagination Help Please

I have a report that has several tables. Each table is to begin on a new page. When I preview the report with the report viewer everything is on one page. When I go to print preview I get the desired page breaks. How do I get the page breaks without going to print preview? Is there a config file setting? Right now, for each table, I have checked the "Insert a page break before this table" box. I have also tried the "Insert a page break after this table" without success.

Any help would be appreciated.

Thanks

-JW

In general, page breaks explicitly set on Tables should be consistent between renderers.

Do you have conditional visibility set on any of the tables? Page breaks on conditionally visible report items is not supported.

-chris

|||

Thanks Chris, that change made the page breaks work. Now it prints a blank page for each tables without data.

-JW

Page Size

Hi,
In crystal reports, I can define page size (letter size or legal size) and
page orientation (Langscap or Prortrait) so the preview exactly looks like
the final print.
Is it possible to do that in MSRS?
To re-word the question, How can I define the page size (letter size or
legal size) and page orientation (Langscap or Prortrait) at design time in
Microsoft Reporting services ?
Thank you,
AlanIn VSNET, open a report in designer, click menu "Report->Report
Properties...", then "Layout" tab.
"A.M" <nospam1@.online.nospam> wrote in message
news:e5y7M7KoEHA.1308@.TK2MSFTNGP14.phx.gbl...
> Hi,
> In crystal reports, I can define page size (letter size or legal size) and
> page orientation (Langscap or Prortrait) so the preview exactly looks like
> the final print.
> Is it possible to do that in MSRS?
> To re-word the question, How can I define the page size (letter size or
> legal size) and page orientation (Langscap or Prortrait) at design time in
> Microsoft Reporting services ?
> Thank you,
> Alan
>
>

Page problem when exporting to pdf format.

I have a main report that contains charts and sub reports. When i see in preview mode it shows ok but when i export it in pdf format it does not show the way i want one relevant remains on previous page and other are gone to next page etc...

Another problem i am facing is if i make the page size greater than 7.5 it exports to one page blank and one page data.

One more thing i want to show table data vertically not horizontally due to restriction of 7.5 inches width.

Thanks in Advance

Muzaffar Ali

Hi Muzaffar,

Regarding report items getting shifted to next page in pdf and getting a blank page check this post -

http://blogs.msdn.com/chrisbal/archive/2006/08/10/694892.aspx

and what exactly you mean by showing data vertically, having header as rows and data as columns(then the number of columns will depend on the numbers of rows in dataset). I think you can try matrix to do that -http://blogs.msdn.com/chrishays/archive/2004/07/23/HorizontalTables.aspx

Page Numbers in Excel

Hi,
When I export to Excel and Print Preview I get page numbers like 1 of 1 even though there are 2 pages.In both pages I get 1 of 1.
What should to do to correct it.
I don't have this problem with pdf.
ThanxFrom an "Export to Excel" perspective, there is only one page (sheet). When
you actually print (which is outside of Reporting Services), you may have a
different page count.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sudha" <Sudha@.discussions.microsoft.com> wrote in message
news:755CFDD0-2980-4AD7-BDB8-DE5DB7635606@.microsoft.com...
> Hi,
> When I export to Excel and Print Preview I get page numbers like 1 of 1
> even though there are 2 pages.In both pages I get 1 of 1.
> What should to do to correct it.
> I don't have this problem with pdf.
> Thanx