Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ravula2000

    AVG based on no of columns

    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...
  2. ravula2000

    AVG based on no of columns

    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...
  3. ravula2000

    Data Filter in Crystal Reports Viewer

    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
  4. ravula2000

    Accessing Database internally

    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 =...
  5. ravula2000

    Write to TextFile

    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...
  6. ravula2000

    Write to TextFile

    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...
  7. ravula2000

    Datagrid output to Excel opens in Browser itself.

    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...
  8. ravula2000

    Datagrid output to Excel opens in Browser itself.

    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)...
  9. ravula2000

    Copy files from Server to client machine on clicking button on webpage

    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...
  10. ravula2000

    Copy files from Server to client machine on clicking button on webpage

    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...
  11. ravula2000

    Copy files from Server to client machine on clicking button on webpage

    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.
  12. ravula2000

    Copy files from Server to local machine on pressing a button

    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...
  13. ravula2000

    Questions on Certificate server implementation

    I found out the option.. its working fine. Thanks chris Srini
  14. ravula2000

    Questions on Certificate server implementation

    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
  15. ravula2000

    Questions on Certificate server implementation

    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...
  16. ravula2000

    Questions on Certificate server implementation

    Hi Chris, Can you please explain me what happens if I remove port 80. Which port no should I give then.. Thanks Srini
  17. ravula2000

    Questions on Certificate server implementation

    I have Certificate server setup on a website. I had given Portno as 80 and SSL No as 443. Iam able to access the application webappl1 in the website from Browser by giving https://webappl1/login.asp where login.asp is a page in the site. Iam getting a Security alert perfectly first time. Now...
  18. ravula2000

    Horizontal bar help

    Hi, I have two horizontal frames. 1st Frame has headings and 2nd frame has data like in a table. When I move the Horizontal scrollbar of the 2nd frame the 1stframe horizontal bar should be moved so that the headings should appear for the data. I posted and got answer 1year back in this forum...
  19. ravula2000

    DataGrid column widths enlarging

    Thanks man.. It is working fine now.. Thanks a lot for your help.. SRini
  20. ravula2000

    DataGrid column widths enlarging

    Iam specifying the columns at design time.. This is the code behing code.. fgrdRecovExtSumm.datasource = ldds fgrdRecovExtSumm.databind() After this databind statement Iam putting the width statement. Do u want me to put in OnItemdatabound event..? I cant generate the columns at runtime as I...

Part and Inventory Search

Back
Top