Field names were used in the SQL statement, and the SQLs are tested. The parameter names are same in the page thats passing their values and in the report page and in the SQL statements. Yeah, sure it's something subtle.

Sorry, Please ignore the previous one. When invoking the .aspx, I'm using: ----------------------------------------------------------------------------

........ /form> <!-- document.frmSQLReport.submit(); //--> -----------------------------------------------------------------------------------

[Message Deleted]

Hi, I have a converted rdlc file that uses 3 datasets, all of which takes the same two parameters being passed from the requesting page. But when I run it - I get "parameter 'Parameter1' is missing a value" error. FYI, I set default values for both of them. Any ideas? Thanks. Ekjon

Hi, I have a converted rdlc file that uses 3 datasets, all of which takes the same two parameters being passed from the requesting page. But when I run it - I get "parameter 'Parameter1' is missing a value" error. FYI, I set default values for both of them. Any ideas? Thanks. Ekjon

Thanks so much Christian. It was really helpful. I thought there could be a better way that I don't know, but looks like there isn't. Off course I'll not use ViewState, probably, I'll use the Session.

Hi Christian, Thanks for the reply. I worked mostly with non-web-based apps, so I thought if I create the ArrayList in the costructor, its always the same List unless the page is disposed. So, what would be the solution? How do I get the same Even if I use a DataSet, is it gonna behave the same way? Please help. Thanks. Ekjon

I am creating this page where I am reading from the database using a SqlDataReader and Loading the info into an ArrayList. The ArrayList is a class member and the ArrayList object has been created in the class constructor, therefore, this object should be visible to all other members of the class. However, if I add some objects to the ArrayList in a MenuItem_Click and then try to read those added objects from a Button_Click, it shows the ArrayList is empty - which seems quite surprising. Obviously I am missing something. Any help? Thanks. Ekjon

When I try to run my report from the ReportServer, I get the above-mentioned error, but it runs fine from the ReportManager, any idea? Thanks. Here's the full thing: Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified. Source Error: Line 33: <sessionState mode="Off" /> Line 34: <httpHandlers> Line 35: <add verb="*" path="Reserved.ReportServer" type="Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler, ReportingServicesWebServer" /> Line 36: <add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" /> Line 37: </httpHandlers> Source File: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config Line: 35 Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.

Hi, I have this old Web Application built using ASP. There is a common page for some reports where the users make the selections. Then it goes to the specific pages, where the user provides input for the report, then submits them (document.form1.submit()). I am adding a new report using SQL Reporting. the Page is already there, built by that common page. The problem is: if I put it in the Form's action - it goes to that specific location, like - my report is in "http://abc/ReportServer/blabla/reportviewer.aspx.." and when I run it, it tries to run from "http://www.xyz.com/reports/**abc/ReportServer/blabla**........" See the problem? Because I can not change the common page where there are all the layouts and codes to process user inputs for all the report pages. On the other hand, I want to send the user inputs for processing as well, but to my SQL ReportServer. Is there any way around it? At least, I want to directly run the SQL Report without worrying about the user inputs for now. Thanks. Ekjon.

Hi Michael, In the MenuItems Click event handler, I did already set the ActiveViewIndex to the appropriate index depending on the MenuItem Click, so that should not be a problem. After I read your suggestions, I used SetActiveView instead of ActiveViewIndex. I did EnableViewState="true" for all of them, I even did EnableCaching="true" for the SqlDataSource. Everything works fine as they used to - Except the GridView disappears with edit, update, cancel, insert button clicks. You need to click on the MenuItem again to see it. I was also thinking that its happening because of the MultiViews. But interestingly, even if I move my GridView out of the MultiView, still does the same. What a puzzle!!! I am confident though that you can give me more clues! Thanks so much. Ekjon

"I am using MultiView / View controls which change by MenuItem clicks. Each view has a GridView on it with Edit and Insert features bound with <b>SqlDataSources</b> The problem is: when the edit button is clicked, the GridView disappears and you need to click on the MenuItem again to see it (it happens evrytime you click edit, update, cancel or insert buttons on the GridView)." Solution Suggested: In Page_load - if (!Page.IsPostBack){ //Getting the data from database //Bind the data to Gridview // Add this datasource to cache or session (e.g. Cache["mydata"]= dsProject.Table[0]; ) } else{ //Re-bind the gridview with datasource from cache. (e.g. GridView1.DataSource = (DataTable)Cache["mydata"] } <u>To Michael Sync:</u> Hi Michael - the problem is Im using SqlDataSources with the GridViews not DataSets. If I want to change them - it will be lot of changes. Any other suggestions? Thanks. Ekjon

Hi Michael, Here's what I'm doing: for the common part of the page, I am using dataset to populate some textbox controls, then for the details part - I'm using GridViews with a SqlDataSources. Each of the GridViews are placed on a View control being changed by MenuItem clicks. Here are some code: protected void Page_Init(object sender, EventArgs e) { projectId = Convert.ToInt32(Session["ClickedId"]); string [] dataKeys = {"MethodSID"}; conn = new SqlConnection(); // Get the ConnectionString dynamically conn.ConnectionString = ConfigurationManager.ConnectionStrings["EEM-NEWConnectionString1"].ConnectionString; dsrcMethods.ConnectionString = conn.ConnectionString; Parameter param; dsrcMethods.UpdateCommand = "update tblMethod set MethodName=@MethodName, MethodDesc=@MethodDesc," + "TaxonomicalKeys=@TaxonomicalKeys, TaxonomicalDesc=@TaxonomicalDesc" + " where MethodSID=@MethodSID and ProjectID=" + projectId; dsrcMethods.InsertCommand = "insert into tblMethod (ProjectID, MethodName, MethodDesc, TaxonomicalKeys," + " TaxonomicalDesc) values (" + projectId + ",@MethodName,@MethodDesc," + " @TaxonomicalKeys,@TaxonomicalDesc)"; param = new Parameter("MethodSID", TypeCode.Int32); dsrcMethods.UpdateParameters.Add(param); param = new Parameter("MethodName", TypeCode.String); dsrcMethods.UpdateParameters.Add(param); dsrcMethods.InsertParameters.Add(param); param = new Parameter("MethodDesc", TypeCode.String); dsrcMethods.UpdateParameters.Add(param); dsrcMethods.InsertParameters.Add(param); param = new Parameter("TaxonomicalKeys", TypeCode.String); dsrcMethods.UpdateParameters.Add(param); dsrcMethods.InsertParameters.Add(param); param = new Parameter("TaxonomicalDesc", TypeCode.String); dsrcMethods.UpdateParameters.Add(param); dsrcMethods.InsertParameters.Add(param); gvMethods.DataKeyNames = dataKeys; gvMethods.DataSourceID = dsrcMethods.ID; } protected void Page_Load(object sender, EventArgs e) { txtID.Focus(); txtID.Enabled = false; txtTitle.Enabled = false; txtAbstract.Enabled = false; txtJust.Enabled = false; txtSponsor.Enabled = false; txtStart

Thanks to Abisodun and Mike for answering my previous post. Both of the answers was directed to the 2nd part of my question. On the first part, I still need help. So - here's it again: I am using MultiView / View controls which change by MenuItem clicks. Each view has a GridView on it with Edit and Insert features. The problem is: when the edit button is clicked, the GridView disappears and you need to click on the MenuItem again to see it (it happens evrytime you click edit, update, cancel or insert buttons on the GridView). Any ideas? Thanks. Ekjon

Thanks Mike.

Thanks Abisodun...

Hi, I am using MultiView / View controls which change by MenuItem clicks. Each view has a GridView on it with Edit and Insert features. The problem is: 1) when the edit button is clicked, the GridView disappears and you need to click on the MenuItem again to see it (it happens evrytime you click edit, update, cancel or insert buttons on the GridView) 2) When you click a MenuItem, the page is posted back and displays from the top again, but I want it to stay at the height where it left so that the users dont have to scroll down again to see the GridView. I can probably use javascript, but I was wondering if there is any asp .net way to fix it? All ideas are welcome. Thanx for your help. Ekjon

Hi, I am using MultiView / View controls which change by MenuItem clicks. Each view has a GridView on it with Edit and Insert features. The problem is: 1) when the edit button is clicked, the GridView disappears and you need to click on the MenuItem again to see it (it happens evrytime you click edit, update, cancel or insert buttons on the GridView) 2) When you click a MenuItem, the page is posted back and displays from the top again, but I want it to stay at the height where it left so that the users dont have to scroll down again to see the GridView. I can probably use javascript, but I was wondering if there is any asp .net way to fix it? All ideas are welcome. Thanx for your help. Ekjon