One of our customers has a report with a single value string parameter that has over 1000+ possible values. selecting single value from 1000+ choices results in bad UI, among other things.create another parameter that acts a filter for the other parameter. So you would have Param1 with say 25 choices and selecting a choice would narrow down the option for the second parameter.Is this the best way. What is the best practice for handling these kinds of parameters?
How do you use the http POST method with a Grid View on another page. I am trying to use the POST method to send the ID from the selected row of a Grid View, I am using a link button set to fire the select command and it has the Post Back URL set, from one page and then retrieve the ID value on another page using an Object Data Source. Also, under the Defining Parameters, I am setting the ID parameter to Form Parameter Source and have entered the Grid Views name in the Form Field.
I am stuck with one issue in SSRS.I have one SP(sql server) that takes Datetime as input parameter. In my report i added one Report Parameter as Datetime and checked Allow Null values and when i run the report its throwing me an error telling that " TITLE: Microsoft Report Designer
An error occurred while executing the query. Failed to convert parameter value from a String to a DateTime. ADDITIONAL INFORMATION: Failed to convert parameter value from a String to a DateTime. (System.Data) String was not recognized as a valid DateTime. (mscorlib) "
ALTER PROCEDURE [dbo].[usp_Search_SSRSReport]( @Servicer_Loan_Number varchar(50), @Completed_Date datetime=NULL, @Doc_Review datetime=NULL ) AS BEGIN SET NOCOUNT ON; DECLARE @strSQL VARCHAR(5000) SET @strSQL = 'SELECT P.Servicer_Loan_Number,P.POOL_ID,P.OrderID,P.Borrower_First_Name+'' '' + P.Borrower_Last_Name AS BWRName, P.Mailing_Address+ CHAR(10) +P.Mailing_Address_City+'',''+P.Mailing_Address_State+'' ''+P.Mailing_Address_Zip AS Mailing_Address, P.Property_Address+ '','' +P.Property_Address_City+'',''+P.Property_Address_State+'' ''+P.Property_Address_Zip AS Property_Address, P.Servicer_Legal_Name,P.Offer_Expiration_Date,P.Document_Package_Complete, P.Counseling_Flag,P.Program_Flag,P.Active_Bankruptcy_Flag,P.Approved,P.Declined, D.Completed_Date,D.Recall_Status,D.Expired_Status,D.Doc_Review ' + ' FROM dbo.Processing(NOLOCK) P,dbo.Document_Exception(NOLOCK) D ' + ' WHERE P.Servicer_Loan_Number=D.LoanNumber ' if(@Servicer_Loan_Number is not null) and (@Servicer_Loan_Number != '') BEGIN SET @strSQL = @strSQL + ' AND P.Servicer_Loan_Number = ''' + @Servicer_Loan_Number + '''' End if(@Completed_Date is not null) and (@Completed_Date !='') BEGIN SET @strSQL = @strSQL + ' AND convert(varchar(11),D.Completed_Date,101) = ''' + convert(varchar(11),@Completed_Date,101)+ '''' End if(@Doc_Review is not null) and (@Doc_Review !='') BEGIN SET @strSQL = @strSQL + ' AND convert(varchar(11),D.Doc_Review,101) = ''' + convert(varchar(11),@Doc_Review,101)+ '''' End EXEC(@strSQL)
We're getting a server error saying "Parameter count does not match Parameter Value count." Anyone have any idea what this could mean?
Our site's on ASP.NET Webforms running DotNetNuke as a CMS.
I've tried uploading an older version of the web.config file but it doesn't seem to have changed since the error came up. It wasn't in any of our recent module file uploads because I reuploaded the old files from this morning that we changed.
Could any changes in the database cause this or would it have to originate from an error in the code?
Ive seen tutorials showing URLs that takes 1 parameter (e.g:http://localhost/nerddinner/edit/10).Which means that 10 is the edit method argument,however,i want to pass a second parameter,how can i do that?I tried http://localhost/nerddinner/edit/10&250 but it failed.
i have a grid with an image column, i want to change images based on data source. if data field for a row is 2 then image will be *.gif and if it is 3 then will be different so it is not fixed that which type of images we will have so i want to do "if..else" on css because in that case we can easily change images on css. i don't want code on code behind file.
I am using ssrs2005.Iwanted to navigates to another report through Jump to Url option. I have another parameterized report (to which I want to navigates). Paramtere are of different datatypes and one of them is null. When I am passing below link I get type mismatch error.
'm constructing a url which in itself has a url, and both are parameterised.E.g. string postUrl = "target_page.aspx?url=post_page.aspx?p1=9&p1=9&post_type=1he url and parameters in bold are the inner url so when i refer to querystring parameter 'url' I want it to bring backurl=post_page.aspx?p1=9&p1=9 and not url=post_page.aspx.hat should I encode and to ensure this comes out correctly
what is the code to access the parameter sent to a view by the urlif i have a url say .../home/index/3the 3 is passed as a variable called id in the controllersay the controller returns a list where all the ids = 3 (in this case) and that list returns no values, i then cant get the value of id from the model because it is emptyI think i would need to get it from the url but i dont know the code to do that
How can I execute a stored procedure that takes in parameters without having to specify the prameters name? The name of the parameter in the stored procedure may change from CustomerID to CustID so I don't want to have to keep changing my code.Rather than doing what is provided below where you specify the parameter name - command.Parameters.Add("@dtStart", SqlDbType.DateTime); command.Parameters["@dtStart"].Value = startDate; command.Parameters.Add("@CustomerID", SqlDbType.NChar); command.Parameters["@CustomerID"].Value = customerID;
It sums by material. So in essence I have 9000 LTV and 4200 HAT. The piece that I am missing that I need to add is the "empty space" available. The empty space is simply the Capacity minus the totals above. So if the total capacity is 15,000, I need to take 15,000-13,200(totals of LTV and HAT above) and add 1800 "empty space" to the pie chart.
As I said before, the pie chart works fine displaying the sum of the materials. I have added a parameter to the report with static capacity numbers. How would I subtract the totals of LTV and HAT from the Parameter and display that number on the pie chart? This was all done with the designer as well so far.