Search results for query: *

I have never ever even thought about using DTS but I think I need to now and really have no idea about the specifics. Here is my problem: We are using ADP for our payroll system (SQLBase 7.5) and I need to import the payroll information into one of our SQL Servers (SQL 2000) so that I can write...

Hello all I've got a few questions Using: CR 9 Standard with SQL Server 2000 using Stored Procedures I work for a CPA firm and have been given the task to build a very large and complex hours analysis report. I am building it in sections, obviously, so what I have so far is the following...

Platform: SQL Server 2000 I work for a CPA firm and the managers and Partners want to know that their staff are not only working a desired amount of hours but that the hours they are working are considered billable time. The following Stored Procedure tries to perform an hours analysis for...

CR Version: 9 Developer Platform: Win XP Pro Datasources: SQL Server 2000 & SQLBase 7 I am wondering if it is possible to share individual values from a subreport to a main report as opposed to summary values Sample Data From Time & Billing System (SQL Server 2000) --Tkinit is timekeeper...

I have a SQL statement as follows 'dw_xaraged = Data Warehouse table 'clients = Clients table 'matter = Services for each client 'relationships: client 1..N matter | matter 1..N dw_xaraged 'mmatter = Specific service for each client (ie Tax Return, Financial Statement, etc.) 'arage1, arage2...

My firm uses a Document Management System called SIAN that essentially eliminates all paper within the organization. Just a little background, SIAN is a SQL based ASP.Net application that runs on our local intranet. People are allowed to save documents to it either through the ASP interface or...

I tried to do a search for this topic as I figured that someone else would have asked this question but I couldn't get the search function to work... Back to the question at hand; I would like to create menus that have images in them much like you would find in Office or other MS apps. I'm...

I am wondering how I might go about ignoring certain keystrokes but not others. Example: I want a user to only enter a 10 digit telephone number without dashes and other non numeric info I tried coding in the KeyDown event to look for any non numeric info and ignore it Private Sub...

I have recently created an application that reads data from a tab delimited text file and puts it into a non-delimited (is that even a word??) text file for uploading to a mainframe. I got the code to work and it works perfectly, however I know there has to be a better way to do this. Any...

Good morning Gurus, I was wondering if I may enlist your help to solve a problem that I am having.... I am new to .NET but have been coding VB6 for about 2.5 years and am wondering how to do a for...each loop to iterate through all the controls on a form as you know, in VB6 the code is...

Hello all, I have yet another quandry... I have developed 2 applications, both of which use VB6 SP6 for the front end, Access 2003 as the back end, and Crystal Reports 9 Developer as the reporting engine with the CRViewer control displaying the reports from within VB...Both are being installed...

Hello again, I have yet another question for all of you Crystal Reports Messiahs... I have developed a date driven reporting system for my firm that tracks our conversions of clients from paper based tax returns/financial statements to new electronic based (CaseWare) returns/statements. Each...

I posted this message in the ASP section also, so right away I apologize for double posting...I am new to the whole web/intranet development circle and my employer wants me to develop a corporate intranet site...My first question is how do I do this?? I want to develop it using ASP/ASP.NET and...

I am new to the whole web/intranet development circle and my employer wants me to develop a corporate intranet site...My first question is how do I do this?? I want to develop it using ASP/ASP.NET and of course IIS. I am very well versed at developing desktop applications with VB6 so I can...

I know I posted this yesterday, but I only got 1 response and I can't figure it out...this procedure takes in 4 values for conversion from string data type to smalldatetime (mm/dd/yyyy)...I keep getting the error "Server: Msg 296, Level 16, State 3, Line 0 The conversion of char data type to...

I apologize for the length of this post but I need some advice on how to shorten it and make it more efficient...also please note the bolded text towards the bottom of the code, after looking over the procedure will that do what I'm wanting it to do (convert the string value to a datetime)...

Is there something that I am missing about Crystal 9 that I should know?? The reason I ask is if I create 2 different reports with the exact same selection criteria, database links, formulas, and groups I get different results...why would this happen???

Ok so I don't know if any of you have used Elite before, but it is a pain in the you know what...anyway, this is what I'm trying to do using CR 9... It's a Year To Date report that takes in 5 criteria for record selection: 1) Joint Billing Group Id cannot be NULL 2) Matter Number cannot start...