Search results for query: *

Did I misunderstand the connection? A quick review of LightPaths website tells me that they do not offer traditional PRI services. You mentioned a 5mb data line with SIP or PRI. This tells me that Lightpath is using SIP all the way to your facility. They are only asking what type of hand off...

The problem was so simple. CHANGE rst.Open cmd.Execute TO Set RST = cmd.execute

Thanks to all who replied. I went back to the database and began working on the queries. What I found was somewhat odd. I typical use the graphically builders when the queries are simple. This time they hosed me. The view was based on a query joined to a sub query that had a TOP 100...

Below is the statement used to execute a stored procedure from VBA using ADO with command parameters. I captured it from the SQL Profiler while debugging my code. exec sp_GrossIntervalSalesReport 1, 0, 'Dec 31 2007 12:00:00:000AM', 'Jan 27 2008 12:00:00:000AM', 3, 0, 2006, 3, 0, 2006, 0, 1, 2...

I am having trouble with a large report and it's run time. It takes almost 2 hours to format 45 pages. First I verified the SQL server 2000 database configuration. The main report and sub report both use views for data. So I ran both at the same time and used that trace data to fine tune...

ranking in the report footer is my only option. I was thinking I would pass the values to an array using some global variables. I have a custom function that can sort the array. Then loop the array to set the text value of a formula field in the footer. Overall it is getting way more...

The Running Totals are reset after the location group. I also have an evaluate formula that counts values for the running total based on day of the week and time of day. For Example: Count record if value1 is less than 10 minutes and Value 2 is Monday - Thursday and Value3 is before 5PM...

I am using Crystal XI. I have a number of running totals. The running total results are than used to calculate a points value for each group which is location. The points formula is supposed to rank the locations. Problem is the formula isn't sortable since it's not based on a database field...

Save them to .dts files. When you are in Local Packages just save as strutured storage file. It will have a .dts extension. Open them and save them locally on your new server. I am sure there is a query that can pull them from a system table, but for 15 this is just as easy.

Thanks it worked great. Never used Coalesce before. It even simplied the query. Thanks again.

This is a simple update query, but it is causing me problems. The inner SELECT returns only rows with matching PLUNum through the INNER JOIN. However when K_Menu and C_Menu are joined there are addtional records returned and the PLUNum values for those addtional records is NULL. QSRCat and...

The application is part of the Squirrel Point of Sale system. In the restaurant industry it is very common to find restaurant running windows 3.11 or DOS with Serial touch screen terminals. Our servers are Windows XP, but the version of software we run is meant for much older systems. Why...

I have a few e-mails out the the sellers on ebay already. Yes the vendor has updates, but it requires us to change platforms. Long story short to get to the version that uses 8.5 my company would have to make a 1.2 million dollar investment in hardware.

I have an old application that use version 6 to create reports. The viewer is embedded in this application and I have to way to upgrade to a newer version. I need to make some simple changes to the a few of these reports. Can I do this from version 8.5 or above? It always want to upgrade the...

The 9.1d progress network client will install the ODBC driver on you machine. If you are using a version prior to 9.1 then progress did not supply a driver. Openlink and Merant both sell drivers for Progress's earlier versions and both have newer better drivers than 3.6. Progress has been...

Thanks to all who responed, except synapsevampire. What's his/her deal. I don't have time to write my life's story to get help with a formula. I gave the formula and what I wanted it to do and I got my answer from lbass. It was really just a brain fart on my part. I needed to seperate the...

I am trying to create a running totals field with an evalute formula. {Y_CheckItem.SaleTime} in DateTime (2005, 06, 25, 15, 00, 00) to DateTime (2005, 08, 30, 18, 00, 00) and {Y_CheckItem.MenuID}=9708 Everything I do seems to get messed up when I use the "in DateTime" function including...

Here is what I have noticed. DateTime parameters do not show in the select options when choicing "is between". I need to use date ranges so I set the parameter to date. Tried datetime and date without any conversions but still error when using "is between". I tried to convert date to...

That's what I tried first and it doesn't work either. All the date conversion functions and no date conversion function works. It errors when I allow range values only. If I just needed one date I can make it work.

I am using a sql sever that has a datetime field I would like to use in my record select. So I create a datetime parameter field and add it to my select statement. The problem is that as soon as I set the parameter to allow ranage vales and the select to be "is between" the formula produces an...