Search results for query: *

Ok, I have a pretty complex report to create. Actually they are a type of label - more or less. I created a form frame with specific information such as Emp ID and I have it configured to have 3 columns and 3 rows of this form. Then I need a subreport to appear in each form that has only 1...

Hi, Here's an odd/absurd question. If you have a Windows 2000 web server, do you need to have some sort of 2000 licensing for the computers that access that 2000 web server? My situation is kind of unique in that i'm a developer and a higher-up is telling me this. How can you disprove the...

Hi, I'm looking to automate an update query in an Access database and i'd like it to run as a Chron job. Is there a way to set it off using VB?

Hi, I have an excel spreadsheet that i'm trying to mail merge with a form letter. The spreadsheet is setup with a field called, "Location". There can be multiple records for that location. I want the Form letter to be able to list all records for that location on 1 letter. When...

That would be great if I had an Edit button. I only have a Copy button. Anybody know what configuration needs to be changed so I can see it. My boss & I are new at this and any help would be appreciated. Thanks.

Hi All, I am writing some reports based out of an Informix database. The catalogs were built for us when our original system was setup. Basically, I need to connect several different tables and it's using a propietary way of joining them. I have gone into my profile settings and looked at...

Hi Everyone, My boss and I are looking to take some advanced training in Cognos/Impromptu. Does anyone know of a place that gives _good_ advanced training in the Philadelphia/Valley Forge area? Any help would be great!!! Thanks....Shearbec :)

It sounds like you want to filter your criteria. All you need to do is add the field that you want to the query. For example, say you wanted to find all the Smiths in your table. Add LastName to your query. Then click on the filter tab and do the following: 1. Double click on report...

Hi All, I have a condition that is as such: if (A<>0) then ((B-A)/A) else Null. I get the error message stating this: Error number -51: DMS-E-MATHEXCEPTION, An arithmetic exception was detected. EXPENG-E-ZERO_DIVR, <Floating point> divide/mod by zero is invalid. However, if I change the...

Hi, What happens in the type of merge you are explaining is that a Word document is linked to an excel spreadsheet to retrieve it's information. So typically, one of two things has happened: A) You moved or removed the excel file for it's original location. B) You have taken out the column...

Has anyone ever had the problem where you format cells to specifically be time, no date and it still force that date to be associated? For example, I've formatted a cell to be hh:mm and when you enter in a time, it now defaults the date as what ever it'd like to pick, ie 1/9/04 1:23 AM Excel...

Hi Jezmondo, This is pretty simple to do. If you begin setup the calculation as you have stated: Date Ordered = (Today - Then click on Values, Interval, and you'll get 000 00:00:00.000 Change it to look like 001 00:00:00.000 Your final calculation should appear to be: Date Ordered =...

Hi, I'm having a problem in Impromptu 6.0 and am fairly new at using this report tool. I need to create a report with approximately 570 objects that are to be shown or hidden based on data in my query. I've used conditional formatting on each object and it's worked beautifully so far...