Search results for query: *

I've got a SQL Server 2000 stored procedure that returns data to be used in a crystal report in Visual Studio 2005. Most of the stored procedure works well, but there is a point where I need to calculate an average number of days been a group of date pairs. I'm not familiar with cursors, but...

I'm using Crystal Reports for VS 2005. I have a report with a subreport (which is another crystal reports file) and I'm having trouble with the page footer. My main report has one page and my subreport has 9 pages - they will always be this length. For some reason, I get a page 11 that only...

I've built a custom web-based CRM in ASP.NET 2.0 on Sql Server 2000. I would like to make the CRM available on the internet, right now it is only available through the intranet. To do this, I want to have the main web server simply redirect a user to the server where the CRM resides rather...

I've built a custom web-based CRM in ASP.NET 2.0 on Sql Server 2000. Currently updating a contact is very inconsistent. If I go into a contact through http://MyServer/secure/allcontacts.aspx or http://MyServer/secure/allcontacts.aspx?contactid=6151 then the updatecontact() sub that I have...

I have a formview control (.NET 2.0/VS2005) in which users enter company contact information. When a user enters a postal code in the appropriate text box, the territory for that company needs to be calculated and displayed in a territory drop down list. I know how to calculate and retrieve...

This is really weird and I just can't seem to get it figured out. I have a page with a formview control. When users insert a record, they type a name into the very first textbox in the form and click a search button. This name is passed via querystring to a search page. After a search is...

Hopefully someone can point me in the right direction, I've been searching on the net for the answer to this question and can't seem to come up with anything. First, I'm using ASP.NET 2.0 and Visual Studio 2005 with a SQL Server 2000 backend. My SQL database is relational and is used to...

I'm using Visual Studio 2005 with VB.NET and have created a form with a multi-select enabled listbox control. The listbox's datasource is a table in sqlserver. The listbox is not databound. To determine which items from the datasource should be selected in the listbox, I created a dataset...

I'm using Crystal Reports in Visual Studio 2005. I need to be able to trigger some code to run after a report is printed. My report is set up in a CrystalReportViewer with the toolbar and print button enabled in the viewer. Is there any way to catch the print event? Thanks!

I have a report set up for printing labels, but the labels require more than just an address. The labels also have the addressee's ID number and a field that holds from 1 up to 15 1-letter codes that we use for mailing purposes. In order to retrieve these multiple codes, I set up a subreport...

I have the following code which is used to select items in a list box: Set tdf = db.TableDefs![Segments] ' Return Index object that points to new index. Set idx = tdf.CreateIndex("REC_NO") Set inds = db.OpenRecordset("Segments") inds.Index = idx.Name For x = 0 To [frmMain]!SegCombo.ListCount...