I am new to this. I have ReportingViewer in my toolbox, and the report is set up and running correctly. However, the 3 parameters should be provided by the web page and not entered by the user in the report itself.
View 8 RepliesBelow is the result set when I execute my stored procedure. Based on condition no.of rows will change. I am using typed dataset to store result set.
NSV QTY MONTH/YEAR
264.95 31248
APR/07
273.23 34044
MAY/07
230.96 22232
JUN/07
711.93 81992
JUL/07
427.23 50345
AUG/07
297.90 36961
SEP/07
495.37 43079
OCT/07
648.48 52428
NOV/07
622.06 46364
DEC/07
407.02 46461
JAN/08
605.45 73439
FEB/08
224.81 28121
MAR/08
308.12 33356
APR/08
328.22 35605
MAY/08
372.41 34107
JUN/08
I have to show above result in RDLC file Like below.
APR/07 MAY/07 JUN/07................JUN/08
264.95 273.23 230.96.................372.41
31248 34044 22232 ...............34107
When using parameters in an ObjectDatasource for an RDLC report, how can you get the parameter values and display them in the report?
View 1 RepliesI have a stored procedure that works fine for classic asp, but how can I get my output parameters data back from in /MVC 2 / linq/ entities framework model . I have inported the function also, but when i try to code it i dont get results ...i know this is a matter of lack of / knowledge or exmple because i have been scouring the web for it and cannnot find into that accually works.
here is the stored proc.
[Code]....
Here was the one of the few tries I did:
[Code]....
but it executes fine does not give me an error, but also does not return the info i need to the viewmodel
I keep seeing stuff about "ref" on the net but "ref" shows " arbument # should not be passed with the ref keyword.
So i am not sure if there is a problem with the model, or with my understanding this, Now for your info I can do the same step with returning a dataset from a stored procedure fine, but I dont want a data set I just want excatly the data in the output parameters from the stored procedure.
I'm having trouble figuring this error out. I have a grid on an ASPX page that displays data from a stored procedure in an SQL Server 2008 database. When the page loads, I get the following error:
"Procedure or function <sp_name> has too many arguments specified."
Here is the code for the grid and the datasource:
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" ShowFooter="True" OnRowDataBound="GridView1_RowDataBound"
AllowSorting="True">
[code]....
Here's the code from the stored procedure:
ALTER PROCEDURE [dbo].[sp_GatewayMerchants]
-- Add the parameters for the stored procedure here
@StartDate DateTime,
[code].....
The datasource is passing 4 parameters, and the stored procedure is accepting 4, but when the page displays I get the error mentioned above.
EDIT: Here's the code behind for the template column. But I'm not sure how this could be causing extra parameters to the SP.
protected void Command_Click(object sender, EventArgs e)
{
var merchantID = Convert.ToInt32(((LinkButton)sender).CommandArgument);
[code].....
If I remove the ASP:LINKBUTTON the code works. So why would a LINKBUTTON be causing this?
I need to update a table with values from a listbox. I am trying to create as many parameters as there are items in the list, my code below, but how do i name them differently? so that they dont' overwrite each other?
For Each item As ListItem In ris
Dim pID As New SqlParameter("@userid", SqlDbType.Int)
pID.Value = objFormat.CheckSQL(item.Value)
myCommand.Parameters.Add(pID)
Next
and on the SQL side, is it possible to write an update statement, that will take a dynamic number of parameters?
so for example, i need to update multiple users with the same value in the "active" field...
I have a working controller for another stored procedure in the database, but I am trying to test another.
When I request the URL; http://host.com/Map?minLat=0&maxLat=50&minLng=0&maxLng=50
I get the following error message, which is understandable but I can't seem to find out why it occurs;
Procedure or function 'esp_GetPlacesWithinGeoSpan' expects parameter '@MinLat', which was not supplied.
This is the code I am using.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web; [code].....
i have a stored procedure to update a table. not all fields are required and some can be blank.for example, title is not required, but when it's blank i get an error
Dim ptitle As New SqlParameter("@title", SqlDbType.NVarChar, 20)
ptitle.Value = objFormat.CheckSQL(title)
myCommand.Parameters.Add(ptitle)
ex {"Procedure or Function 'sp_UpdateUser' expects parameter '@title', which was not supplied."} System.Exception
how can i fix it so that it allows for nulls if the data field is blank?
We have a requirement where date time values would be passed to the report parameter which is of
View 2 RepliesIn Report Viewer report, I have two DateTime parameters that I would like to appear in a textbox of my report. How can I format like this? Currently this comes out blank.
= "Date Range: From: " + Parameters!dtFromSelect.Value + " - To: " + Parameters!dtToSelect.Value
I am working on LINQ. I am calling a SQL Stored Procedure with 2-3 parameters it's working fine. When i am going to call Stored Procedure with 8 to 9 parameters the auto generated column is not comming automatically. So i am unable to use LINQ with Stored Procedure with multiple parameters.
View 4 RepliesI have created a stored procedure shown below ,how will i call this from c# code behind to get the result and results are stored in dataset.
USE [Test]
GO
/****** Object: StoredProcedure [dbo].[tesproc] Script Date: 09/01/2010 13:00:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[tesproc]
-- Add the parameters for the stored procedure here
@a float, @b float, @c float,@d int
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
select Id, Name1,ZipCode,StreetName,StreetNumber,State1,Lat,Lng, ( 6371 * ACOS( COS( (@a/@b) ) * COS( (Lat/@b) ) * COS( ( Lng/@b ) - (@c/@b) ) + SIN( @a/@b ) * SIN( Lat/@b ) ) ) as distance from business_details where ( 6371 * ACOS( COS( (@a/@b) ) * COS( (Lat/@b) ) * COS( ( Lng/@b ) - (@c/@b) ) + SIN( @a/@b ) * SIN( Lat/@b ) ) )<@d
END
If i execute this stored procedure in sql server its working fine with this following call
exec dbo.tesproc 12.9216667 ,57.2958,77.591667,1
I have a stored procedure which handles a SELECT query on an SQL 2005 table. Works fine. Now I need to add a bunch of parameters to the query--these are all boolean, with checkbox web controls on the .aspx page to set the parameters true or false, and bit columns in the SQL table. These parameters need to be optional, so that parameter doesn't filter out any records unless it's checked. Here's the original sproc:
[Code]....
Can I just add on all those boolean parameters like so?
[Code]....
I have a table with 4 columns.The first column is a list of teams.The other three columns specify whether the team member with the particular id is present on any particular day .Say for example in the third row the running Team has 2 and 3 which means team member with the id 2 and 3 are present.Multiple values are seperated by the pipe symbol '|'.I have a Query like this
Select Teamname from tblTeam where Running not like '%|2|%' and Running not like '%|3|%' and Running not like '%|7|%' and Biking not like '%|1|%' and Biking not like '%|4|%' and Biking not like '%|7|%' and shooting not like '%|3|%' and shooting not like '%|4|%' and shooting not like '%|7|%' Basically i am searching the columns with like clause.The search criteria for each column may vary.In the above query i am searching for Teams where Running column does not contain 2,3 and 7,Biking column does not contain 1,4 and 7 and the shooting column does not contain 3,4 and 7. I would like to set a stored procedure where i would be able to pass 3 set of parameters from the code behind(I am using VB.net) for Running column search,Biking column search and the shooting column search.
Can someone tell me writing a simple stored procedure.I have a table with 4 columns.The first column is list of teams.The other three columns specify whether the team member with the particular id is present or not on any particular day .Say for example in the third row the running column has 2 and 3 which means team member with the id 2 and 3 are present.Multiple values are seperated by the pipe symbol '|'.
Instead of dynamically building an sql to update data based on certain fields that are filled in, I would like to try and do it via a stored procedure I have three fields passing potentially passing to a stored procedure
myCommand.Parameters.AddWithValue("@Field1",
Field1.Text)
myCommand.Parameters.AddWithValue("@Field2",
Field2.Text)
myCommand.Parameters.AddWithValue("@Field3",
Field3.Text)
Stored Procedure accepts 3 parameters
@field1 nvarchar(20), @field2 nvarchar(20), @field3 nvarchar(20)
I want to be able to pass parameters in a variety of ways
field1, field2, field3
or
field1, field3
or
field2, field3
When I attempt thsi, it provides an error of a missing parameter when I do not supply all three. Is there any way to pass exclude parameters at times. The most important thing is that I do not want to update the field to a null when a parameter is not passed, I want it to exclude updating that field altogether
I am trying to create a method which will access the database via a SqlDataAdapter. I have passed two parameters month and year. When I run it, I get the error "Object reference not set to an instance of an object". I have posted the complete code below. Please take a look..
[Code]....
I have a web page that displays some data. When they click a submit button, I want to run a report. But I would like to pass the start year/month and end year/month values that the user already entered on the web page to the report. Here is what my url looks like when the report is displayed:
http://xyzserver/Reports/Pages/Report.aspx?ItemPath=%2fReports%2fDevicesAllNew&rs:Command=Render&StartYYMM=201007&EndYYMM=201008
But my report displays the 2 textboxes for my StartYYMM and EndYYMM parameters as empty. What am I doing wrong? I did a google search and I saw something about using ReportServer instead of ReportManager. I notice at the top of the browser when I run my report, it reads "Report Manager - Windows Internet Explorer". Is this correct?
I am developing a web app containing an embedded Reportviewer control, a dropdownlist and Ajax TabContainer. The ReportViewer refreshes the report for every tab click in the TabContainer or for every SelectedIndexChanged event of the dropdownlist. The report I am generating is a 6-month trending report displaying statistical data for the last 6 months from the month and year selected in the dropdownlist. I have used Report Parameter to pass the selected date value (from dropdownlist) from the code to the Report (.rdlc). Using Expressions in report file I have displayed last 6 months names from the passing date value. The C# code looks like this.
ReportParameter p1 =
new
ReportParameter("ReportParameter1", [code]....
The problem is I am not able to set parameters more than once using SetParameters. I will need to pass the parameter value for (a)Everytime the dropdownlist item for month is changed (b) Everytime the TabContainer ActiveTab is changed (c) When the page loads for first time displaying the report for first time. Can someone advise how to pass different values for the same report parameter under different scenarios? Can we change the parameter value passed once it has been set using SetParameters?
Can we do Cascading parameter without having dataset.
In the report parameters for SSRS 2005
I am have two columns
one column second column
two wheeler cycle
scooter
herohonda
three wheeler Auto
four wheeler car
sumo
Jeep
I have a question. How do we define date output parameters for a stored procedure?
before you answer,I should mention that I am not referring to the sql syntax definition ,which is @mydate datetime output.
This is ok,what i am asking is HOW DO I SPECIFY IT IN LINQ WHEN I NEED TO CALL THE STORED PROCEDURE IN THE SERVER SIDE CODE. I am repeating that I do I am not referring to the sql definition .
How do you turn this, into a stored procedure:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionStringNEW %>"
SelectCommand="SELECT * FROM [Insert] WHERE ([Sellername] = @Dogname)">
<SelectParameters>
<asp:QueryStringParameter Name="Dogame" QueryStringField="ID" />
</SelectParameters>
</asp:SqlDataSource>
I'm having difficulty with the querystringparameters.
Ive tried a few ways of doing this without success and got together a simplified example so hopefully I can get an answer. When I try to INSERT using a stored procedure InsertTest (normal SQL works OK) I cannot. I need to know how to pass the @Model parameter to the Stored procedure
Have a Stored procedure which can be executed and after entering string for @Model through wizard a new record is created
My asp:SqlDataSource includes InsertCommand="InsertTest" InsertCommandType="StoredProcedure"
Also my <InsertParameters includes the asp:Parameter Name="Model" Type="String"/>
My drop down (and I think this is where the problem is ). Record is Inserted after choosing Model and pressing enter
Do I have to set one of the properties in the drop down to tell the Stored procedure the parameter being passed is the parameter Model ??
[Code]....
I need to create stored procedure to use it for multi value parameter.. I createdd new data set and changed the type to stored procedure but how can I write my select statement in it?
View 4 RepliesI need to link 2 stored procedure in crystal report, passing same parameter id, i tried but getting error
"Unable to connect: incorrect log on parameters."
in this way i'm creating report.
1) Create Dataset(myTable.xsd) in App_Code folder
2) Create a blank Crystal Report, Field Explorer getting Database Fields, from Database Expert (ADO.Dataset Objects), selecting the
myTable.xsd Dataset
3) Drag the fields in Crystal Report n Execute
I have several reports that I have published to a SQL 2008 report server with parameters that are dates (DateTime format). For these parameters, a calendar icon is displayed next to the textbox to allow users to select the date via mouse. Some of my reports are used by people overseas (England), where the date format is dd.mm.yy (instead of mm/dd/yyyy).
I went to the report properties, and changed the Language property from "un-US" to "en-GB". The affect of this is that all of the dates that are displayed on my report now show the date format of [dd.mm.yy] (which is good). However, the textbox where they specify the report parameter still shows the old mm/dd/yyyy format.
Can this be changed somehow? I have looked around, but could not find a setting that would apply to this. Or is this a client-side setting (in other words, when viewed overseas, it takes the "native" date format)?