Hi LB,
Thanks for your reply. The column is NoOfSales made by that saleman on one day.
Here is the report needed.
SalesPersonNm TotalAvg 1/1/09 1/5/09
David Jones 150 100 200
Mary 250 200 300
1/1/09 1/5/09 are sale dates. Saledate range is...
Hi
Here is the requirement.
The Cross tab has SalesGuyName as rows and each day sale as columns. Now say date range is Jan0109 to Jan3109. The Avg is defined in formula as Totalsales/days between that date range ie 30
So the problem is what happens if the salesguy does not have sale for say 10...
Hi,
I am looking for a data filter in Crystal Reports X1 viewer, want to filter the data (like data filter in excel) on the viewer itself without posting back to server and using Parameter fields.
If any body has any ideas please share.
Thanks
Sr
Hi,
I created a form in the MSAccess database and Iam accessing the database with the following code which is working fine.
=================
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
cn.Open "dsn=csismdb"
Set rs =...
Hi TomThumbKP,
Here is the code that I can use in VB after setting refernces to Ado 2.6 library..
Private Sub CreateTextFile_Click()
Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
Dim rs As ADODB.Recordset
cn.Open...
I have a table where Id and notes fields is stored.
I want to take few records and want to create a text file with the name of the Id.
I want to do this using MSAccess forms.
Can any body please explain me who to create it.
Iam good in VB but not familiar with Ms-Access.
Please advise me...
I got the solution.
In Windows Explorer I went to Tools->Folder Options->FileTypes.
I selected XLS filetype and clicked on Advanced and Unchecked 'Browse in same window'.
Now the excel output is opening with Excel application, so that I can able to save the file to my hard drive
Thanks for...
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
Me.EnableViewState = False
Dim tw As New System.IO.StringWriter()
Dim hw As New System.Web.UI.HtmlTextWriter(tw)
hw.RenderBeginTag("h5")
hw.Write("Case# " & lsCaseNum)
hw.RenderEndTag
fdgdcardslawenf.RenderControl(hw)...
Hi,
I have a webapplication on a server. In this webapplication we have to provide a menu where users can select a list of files from a directory and on pressing download, the files should be automatically copy to users local machine say in c:\. Is this possible using Javascript or vb or asp...
Hi,
I have a webapplication on a server. In this webapplication we have to provide a menu where users can select a list of files from a directory and on pressing download, the files should be automatically copy to users local machine say in c:\. Is this possible using Javascript or vb or asp...
I have a webapplication on a server. In this webapplication we have to provide a menu where users can select a list of files
from a directory and on pressing download, the files should be automatically copy to users local machine say in c:\. Is this possible
using Javascript or vb or asp etc.
Hi,
I have a webapplication on a server. In this webapplication we have to provide a menu where users can select a list of files (in a directory) on the server and on pressing download button, the files should be automatically copy to users local machine say in c:\. Is this possible
using...
I got the redirection working.
I checked all the options for forcing my main site (using tcpport 80 and sllport433) to use only https connection.
I couldnt find it.. Can you please help me..
I really appreciate your help.
Thanks for your time.
Srini
Chris,
I apologize for asking you again.
Iam not able to remove tcpportno 80 from the application. When SSLportno 443 is removed the browser is showing 'page cannot be displayed'.
Please explain me with an example like what TCPPort and SSLPort Nos to use for 2 sites to transfer from Nonsecure...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.