|
|
i using crystal report in my project. i want to add page wise total for a column(stock) please give me a idea.....
|
|
|
|
|
This can be acheived by Implementing three different formula's in the crystal report.
--------------------------------------------------
Formula 1: -- create a shared variable and initialize it to 0
Shared numberVar pgTotal :=0 ;
Formula 2: -- create a shared variable with the same name to have the running total
Shared numberVar pgTotal := pgTotal + {Amount};
Note: Amount is the report field that total is to be calculated.
Formula 3: -- Create a shared variable with the same name and assign the same to have the page total
Shared numberVar pgTotal := pgTotal;
--------------------------------------------------------
after creating the formula's
1. place the formula1 field in the page header section of the crystal report
2. place the formula2 field in the detail section of the report
3. Supress the formula1 and formula2 field in the report
4. place the formula3 feild in the page footer to have the page total in each page.
Regards
John
|
|
|
|
|
try this:
On the gridview theres a small arrow on the upper right, click that then choose edit columns. by that you can change column orders or do it on the Source.
|
|
|
|
|
Good Day!
I am using ASP.net 2005 (Visual Basic Code)
the table I bind with the gridview has too many fields, therefore, i want to display Other details of the gridview when mouseovered or when a expand button is clicked. i have googled this for about 1 week. unfortunately, Never found a article that could solve my problem.
Does anyone knows how to display extended details of a gridview? or does anyone know any working article?
|
|
|
|
|
cometburn007 wrote: Other details of the gridview when mouseovered or when a expand button is clicked.
This can be done using javascript and nesting grid view. You can put one more gridview for the extended details and find that on gridview on parent gridview's data binding event.
By default you can set the inner gridview's display style to none. When link is clicked, call a javascript function which makes this visible.
Hope this helps
|
|
|
|
|
Hi all,
I am trying to fill a GridView with data from a MySql Table.
The gridview is defined in the ASP-file. In the code behind the next code should fill the gridview with data via a Stored Procedure combined with an Array of Parameters.
Codebehind:
<br />
private void SetGridChooseServices()<br />
{<br />
<br />
MySqlParameter[] arrParameter0 = new MySqlParameter[0];<br />
String StoredProc = "GetServices";<br />
gridChooseServices = db.WerkGridViewBij(gridChooseServices, gridChooseServices.PageIndex, StoredProc, arrParameter0);<br />
PlaatsveldenInGridView();<br />
}<br />
Method WerkGridViewBij (means updateGridView):
<br />
public GridView WerkGridViewBij(GridView gv, Int32 paginaNummer, String DataSourceSelectCommand, MySqlParameter[] sqlParameters)<br />
{<br />
MySqlDataReader reader;<br />
<br />
try<br />
{<br />
MySqlCommand cmd = BaseDatabaseData(DataSourceSelectCommand, sqlParameters);<br />
cmd.Connection.Open();<br />
reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);<br />
gv.DataSource = reader;<br />
if (paginaNummer > gv.PageCount) paginaNummer = 0;<br />
if (gv.AllowPaging)<br />
gv.PageIndex = paginaNummer;<br />
gv.DataBind();
reader.Close();<br />
}<br />
catch (Exception err)<br />
{<br />
gv.ToolTip = err.Message;<br />
}<br />
finally<br />
{<br />
if (gv.Rows.Count.Equals(0))<br />
gv.ToolTip = "Geen data gevonden!";<br />
}<br />
return gv;<br />
}<br />
Method BaseDatabaseData (used in WerkGridViewBij):
<br />
private static MySqlCommand BaseDatabaseData(String StoredProc, MySqlParameter[] arrParameters)<br />
{<br />
String connection = System.Configuration.ConfigurationManager.ConnectionStrings[1].ConnectionString;<br />
MySqlConnection con = new MySqlConnection(connection);<br />
<br />
MySqlCommand cmd = new MySqlCommand(StoredProc, con);<br />
cmd.CommandType = CommandType.StoredProcedure;<br />
cmd.Parameters.AddRange(arrParameters);<br />
<br />
if (cmd.Connection.State == ConnectionState.Open)<br />
cmd.Connection.Close();<br />
<br />
return cmd;<br />
}<br />
In the method WerkGridViewBij the result from the DB is no records strange enough, while in the database 14 rows are selected. Why do these rows not show up ?
-- modified at 5:12 Wednesday 22nd August, 2007
Error occurs when doing gv.DataBind();
The error says:
{"De gegevensbron biedt geen ondersteuning voor gegevenspaginering op de server."}
The DataSource does not support datapaging on the server.
|
|
|
|
|
Datareader does not support paging.
I Changed the WerkGridViewBij-method to:
<br />
public GridView WerkGridViewBij(GridView gv, Int32 paginaNummer, String DataSourceSelectCommand, MySqlParameter[] sqlParameters)<br />
{<br />
try<br />
{<br />
<br />
<br />
MySqlCommand cmd = BaseDatabaseData(DataSourceSelectCommand, sqlParameters);<br />
cmd.Connection.Open();<br />
<br />
if (gv.AllowPaging)
{<br />
DataSet dset = new DataSet("GeneralDataSet");<br />
DataTable tabel = new DataTable("GeneralTable");<br />
MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);<br />
adapter.Fill(tabel);<br />
gv.DataSource = tabel;<br />
if (paginaNummer > gv.PageCount) paginaNummer = 0;<br />
<br />
if (gv.AllowPaging)<br />
gv.PageIndex = paginaNummer;<br />
gv.DataBind();<br />
}<br />
else<br />
{<br />
MySqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);<br />
if (reader.HasRows)<br />
{<br />
gv.DataSource = reader;<br />
gv.DataBind();<br />
}<br />
reader.Close();<br />
}<br />
}<br />
catch (Exception err)<br />
{<br />
gv.ToolTip = err.Message;<br />
}<br />
finally<br />
{<br />
if (gv.Rows.Count.Equals(0) && gv.ToolTip.Equals(String.Empty))<br />
gv.ToolTip = "Geen data gevonden!";<br />
}<br />
return gv;<br />
}<br />
problem is solved
|
|
|
|
|
Hi,
I have a login control in my ASp.NET application. I use 'Users' table in SQL Server 2005 to authenticate the login. If the username & password are correct, I want to display the username in the loginview control. How can I do that?
|
|
|
|
|
put in a login view and put the login name in it .
if you want to display a message before the username use the format string in the properties window just don't remove the {0} at the end.
BiG RaLpH
|
|
|
|
|
can u pls put down a sample code here?
thanks in advance.....
|
|
|
|
|
first did you try to login successfully if not I will tell you what to do
BiG RaLpH
|
|
|
|
|
Yeah! Please Tell me from scratch how to do it.
I tried to use Login1_Authenticated() method to manually check the username & password but it didn't work.
Please tell me how to do the login & Display the username in the login view control.
Also How to handle LoggedInTeTemplate & AnnonymousTemplate...
Thanks
|
|
|
|
|
How to use flash and integrate it into ur website
www.2advanced.com
This website rocks
|
|
|
|
|
You can start by creating a flash movie.
For integrating into website, just use the object tag.
Point to note: Not all websites that use flash are "Wow". A badly designed flash interface can be irritating, difficult to maintain and may turn away users. Also its client-heavy.
Ajax should suffice unless you're creating a website for a las vegas condo.
SG
|
|
|
|
|
Hi,
I have a textbox that accepts numbers. I need to extract just the numbers in the orders as what they were entered, irrespective of what other text is entered.
I have the following:
Dim r As New Regex("^\d+$")
Dim matches As MatchCollection = r.Matches(strNum)
Response.Write("matches.Count = " & matches.Count)
When I enter "123-456", matches.Count is 0, but when I add "123" then the count is 1. How do I modify the regular expression so that it extracts the numbers, if "123-456" or "123/456" is entered then the end result must be "123456".
Please can someone help?
Regards,
.NET Enthusiast
|
|
|
|
|
write your own code, like
Protected Function SelectNumbers(ByVal alphaText As String) As String<br />
Dim num As String = ""<br />
Dim c As Char<br />
For i As Short = 0 To alphaText.Length - 1<br />
c = alphaText.Chars(i)<br />
If Char.IsDigit(c) Then<br />
num &= c<br />
End If<br />
Next<br />
Return num<br />
End Function
|
|
|
|
|
hi ..
i want to know how to access database and insert row in datagrid using javascipt.
this is my existing code
<columns>
<asp:templatecolumn>
<headerstyle width="10%">
<itemstyle font-underline="True" horizontalalign="Center" width="10%">
<itemtemplate>
<asp:hyperlink id="Hyperlink1" cssclass="bluelink" runat="server" navigateurl="<%# "../CareHistory/CareEpisodeDetails.aspx?CareId="+DataBinder.Eval(Container.DataItem,"CareId").ToString() %>" width="16%">
View
<asp:boundcolumn datafield="CareCategoryName" headertext="Care Group">
<headerstyle horizontalalign="Center" width="25%">
<asp:boundcolumn datafield="CareStartDate" headertext="Date From" dataformatstring="{0:dd/MM/yyyy}">
<headerstyle horizontalalign="Center" width="10%">
asp:BoundColumn DataField="CareDateTo" HeaderText="Date To" DataFormatString="{0:dd/MM/yyyy}">
<headerstyle horizontalalign="Center" width="10%">
asp:BoundColumn DataField="ReasonForChange" HeaderText="Reason For Change">
<headerstyle horizontalalign="Center" width="15%">
asp:BoundColumn DataField="FundingAuthority" HeaderText="Funding Authority">
<headerstyle horizontalalign="Center" width="15%">
asp:TemplateColumn HeaderText="Risk at Home">
<headerstyle horizontalalign="Center" width="15%" verticalalign="Middle">
<itemstyle horizontalalign="Center" verticalalign="Middle">
<itemtemplate>
<asp:label id="lblRiskAtHome" runat="server" width="125px" text="<%# DataBinder.Eval(Container.DataItem,"HomeVisitingSafetyIssues") %>">
i need existing from to javascript like below
var grid = new AW.UI.Grid;
grid.setId("myGrid");
grid.setHeaderText("header");
grid.setCellText(function(col, row){return col + "-" + row});
grid.setColumnCount(10);
grid.setRowCount(1000);
grid.refresh();
how to get that row please help me
thank u
nantha
|
|
|
|
|
It's not a datagrid, it's a table on the client side. You need to add rows to the client side table. A repeater is probably better for you to control how things are laid out for the javascript.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
hi..Christian Graus
thank u soo much i will try that . thank u once again..
reg
nanth
|
|
|
|
|
Hi..
Friends.
I'm getting this error while changig in 'httpHandler' section in web.config
by following code..
Configuration objConfig = WebConfigurationManager.OpenWebConfiguration(Request.ApplicationPath);
HttpHandlersSection sec = (HttpHandlersSection) objConfig.GetSection("system.web/httpHandlers");
sec.Handlers.RemoveAt(0);
HttpModulesSection sec2 = (HttpModulesSection)objConfig.GetSection("system.web/httpModules");
sec2.Modules.RemoveAt(0);
objConfig.Save(ConfigurationSaveMode.Full);
When, I m executing this code, I m getting this types of error message,
Access to the path 'c:\inetpub\wwwroot\FinalUploadProgress\web.config' is denied.
Please help me ASAP
Thanks in Advance..
Regards,
Abhi
|
|
|
|
|
check the authorization of ASP.NET and NETWORKSERVICE users. i got this error 6 days ago.
|
|
|
|
|
This code block is run on my developer pc. but i upload files to server then
I get an error "Object reference not set to an instance of an object"
on "dr.close"
whats wrong with this code?
Protected Sub Login1_Authenticate(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.AuthenticateEventArgs) Handles Login1.Authenticate
Dim conn As New System.Data.OleDb.OleDbConnection(MyConstants.sqlConnString)<br />
Dim cmd As New System.Data.OleDb.OleDbCommand("", conn)<br />
Dim dr As System.Data.OleDb.OleDbDataReader<br />
Dim msG As String = ""<br />
Try<br />
conn.Open()<br />
cmd.CommandText = "SELECT * FROM MD_USERS WHERE U_USERNAME='" & Login1.UserName & "' AND U_PASSWORD='" & Login1.Password & "' "<br />
dr = cmd.ExecuteReader<br />
If dr.Read Then<br />
Dim mu As New MyUser<br />
mu._ID = dr.Item("U_ID")<br />
mu._Name = dr.Item("U_CLASS") & " " & Myuser.SayDignity(dr.Item("U_DIGNITY")) & " " & dr.Item("U_NAME") & " " & dr.Item("U_SURNAME")<br />
mu._CATEGORY = dr.Item("U_CATEGORY")<br />
mu._AUTHORITY = dr.Item("U_AUTHORITY")<br />
Session("MYUSER") = mu<br />
e.Authenticated = True<br />
End If<br />
Catch ex As Exception<br />
msG = ex.Message<br />
Finally<br />
dr.Close()<br />
conn.Close()<br />
End Try<br />
If Not msj = "" Then<br />
Session("msG") = msG<br />
Response.Redirect("Messages.aspx")<br />
End If<br />
End Sub
also What do u offer to improve this code?
|
|
|
|
|
greekius@hotmail.com wrote: dr.Close()
#1. You should check like ~
If dr IsNot Nothing Then If Not dr.IsClosed Then dr.Close()
#2. You should check whether dr is nothing or not before "dr.Read" too.
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. 
|
|
|
|
|
Declare this statement : Dim dr As System.Data.OleDb.OleDbDataReader
above of the function
Dim dr As System.Data.OleDb.OleDbDataReader
Protected Sub Login1_Authenticate(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.AuthenticateEventArgs) Handles Login1.Authenticate
{
................
..................
..............
}
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
