Hi,

I am new to this blog.....

I am facing a problem, which is very very....... I dont know....

I have a query where I am using inline parameter in SQL query like '{?Academic_Year}'

and I am using another parameter called property_name as a dynamic parameter and mapped to the command through Select Expert.

My problem is:

if I am using one inline parameter in SQL query, which is not mapped through Select Expert and another is dynamic, which is mapped through Select Expert. After deployment this on Cyrstal report server and completing all the database settings, When I view this report it asks for the database passwords. Although all database details are already saved.

When I run the same report without inline parameter in SQL query like '{?Academic_Year}' and another parameter both are mapped to the command through Select Expert. It does not ask for any details like database password.

I dont know Why...??

Can anyone help me to resolve the drastic problem?

Thanks in Advance....
Sanjay Sharma