Peduliar problem in SSRS

Hi all ,

I am encountering a peculiar problem while creating a linked report in SSRS.

The scenario:

My first reports contains 3 columns . The first 3 columns contain data from vendor table in AdventureWorks DB. They are VendorID , Name, CreditRating. The fourth column contains a link to the second report. It is just a link which jumps to the other report and passes the above three values as parameters to the second report.

The second report contains 4 parameters which includes VendorID , Name, CreditRating and one more Postedby parameter which has to be entered manually when the second report is displayed. The three parameters from first report are passed on and one extra parameter has to entered manually then only the second report displays.

It works fine when I check it on Visual Studio preview mode. I click the link for a particular row in First Report and it asks me to enter the Postedby Parameter. After entering it it displays the 2nd report. But the problem arises when I deploy it to report server. When I click the link on first report it throughs an error like " The Parameter 'PostedBy' is missing a value" whereas it should prompt the user to enter the PostedBy Parameter.

I am stuck in this and not able to understand why this happens in ReportServer and not in Visual Studio Preview mode.

Does anybody has any idea why this is happening ?

Any Suggestion will be appreciated.

Regards...

Girija Shankar Beuria

You must specify the default value for the fourth parameter. Visual Studio is an interactive environment, so you get to enter the value on request by the VS. But in production environment, reports are consumed by other applications and the report will not be able to request for an input from the calling application and this applies to Report Manager also which is an external web application that consumes the reporting services.

Shyam

|||

just go to the code and see if there is any parameter hard coded in xml.

Remove that parameter and save it .

This will probably solve your problem.

Vamsi Krishna Korasiga

Password Required on Open of Linked Access mdb file

Any help would be great. I have an mdb file that is linked
to a table on my SQL Server which resides on a corporate
Web Server. I have a non-Windows Authenticated username
and password to the SQL Server database, so I have to
enter the password everytime I open the Access database
that links to the SQL Server. Is there anywhere to store
my password so that I can bypass having to enter it
everytime I open a linked mdb? Thanks!That information is stored in the tabledef properties of the linked
tables. One solution to this problem is to write code when the
application starts up. The code creates new tabledef objects,
supplying the user name and password (which you can collect from a
form). When the application shuts down, delete the tabledef objects.
This way security information persists only for the life of the
application instead of being permanently cached with the linked
tables.
--mary
On Mon, 3 May 2004 16:01:07 -0700, "mj"
<anonymous@.discussions.microsoft.com> wrote:

>Any help would be great. I have an mdb file that is linked
>to a table on my SQL Server which resides on a corporate
>Web Server. I have a non-Windows Authenticated username
>and password to the SQL Server database, so I have to
>enter the password everytime I open the Access database
>that links to the SQL Server. Is there anywhere to store
>my password so that I can bypass having to enter it
>everytime I open a linked mdb? Thanks!

Password Required on Open of Linked Access mdb file

Any help would be great. I have an mdb file that is linked
to a table on my SQL Server which resides on a corporate
Web Server. I have a non-Windows Authenticated username
and password to the SQL Server database, so I have to
enter the password everytime I open the Access database
that links to the SQL Server. Is there anywhere to store
my password so that I can bypass having to enter it
everytime I open a linked mdb? Thanks!
That information is stored in the tabledef properties of the linked
tables. One solution to this problem is to write code when the
application starts up. The code creates new tabledef objects,
supplying the user name and password (which you can collect from a
form). When the application shuts down, delete the tabledef objects.
This way security information persists only for the life of the
application instead of being permanently cached with the linked
tables.
--mary
On Mon, 3 May 2004 16:01:07 -0700, "mj"
<anonymous@.discussions.microsoft.com> wrote:

>Any help would be great. I have an mdb file that is linked
>to a table on my SQL Server which resides on a corporate
>Web Server. I have a non-Windows Authenticated username
>and password to the SQL Server database, so I have to
>enter the password everytime I open the Access database
>that links to the SQL Server. Is there anywhere to store
>my password so that I can bypass having to enter it
>everytime I open a linked mdb? Thanks!

Password assign on linked server.

Hello,
Is it possible to know a password that was assign in the creation of a
linked server?
I have tha hash of the user password in Oracle and if i change user password
its possible to do the rollback. But in SQL Server if i need to rollback the
operation i dont know what was the old password.
Thanks and best regards.
Is it not possible for you to change the password of the account that
the Linked Server is using to connect with? You don't need to know the
previous password to change it. Obviously this may not be feasible in
your environment but I don't know of how you can retrieve the password
directly.
ALI
|||Hi Ali,
I need to know the password before change it because it might be possible
that i need to rollback this operation. So to change the password i need to
know what is the older password.
Thanks and best regards.
"zashah@.gmail.com" wrote:

> Is it not possible for you to change the password of the account that
> the Linked Server is using to connect with? You don't need to know the
> previous password to change it. Obviously this may not be feasible in
> your environment but I don't know of how you can retrieve the password
> directly.
> ALI
>

Password assign on linked server.

Hello,
Is it possible to know a password that was assign in the creation of a
linked server?
I have tha hash of the user password in Oracle and if i change user password
its possible to do the rollback. But in SQL Server if i need to rollback the
operation i dont know what was the old password.
Thanks and best regards.Is it not possible for you to change the password of the account that
the Linked Server is using to connect with? You don't need to know the
previous password to change it. Obviously this may not be feasible in
your environment but I don't know of how you can retrieve the password
directly.
ALI|||Hi Ali,
I need to know the password before change it because it might be possible
that i need to rollback this operation. So to change the password i need to
know what is the older password.
Thanks and best regards.
"zashah@.gmail.com" wrote:
> Is it not possible for you to change the password of the account that
> the Linked Server is using to connect with? You don't need to know the
> previous password to change it. Obviously this may not be feasible in
> your environment but I don't know of how you can retrieve the password
> directly.
> ALI
>

Password assign on linked server.

Hello,
Is it possible to know a password that was assign in the creation of a
linked server?
I have tha hash of the user password in Oracle and if i change user password
its possible to do the rollback. But in SQL Server if i need to rollback the
operation i dont know what was the old password.
Thanks and best regards.Is it not possible for you to change the password of the account that
the Linked Server is using to connect with? You don't need to know the
previous password to change it. Obviously this may not be feasible in
your environment but I don't know of how you can retrieve the password
directly.
ALI|||Hi Ali,
I need to know the password before change it because it might be possible
that i need to rollback this operation. So to change the password i need to
know what is the older password.
Thanks and best regards.
"zashah@.gmail.com" wrote:

> Is it not possible for you to change the password of the account that
> the Linked Server is using to connect with? You don't need to know the
> previous password to change it. Obviously this may not be feasible in
> your environment but I don't know of how you can retrieve the password
> directly.
> ALI
>