Search results for query: *

Thanks Michael, I am a bit of a novice with SQL queries, but this looks simple enough for even me to understand and I do not see why this wouldn't work (at least logically). Unfortunately, I may need to find another way to do this. I am using Cognos Impromptu which has a SQL statement...

Hi, I need to know a SQL statement trick that would identify a record in a table with the value of a a calculation. Can this be done? I have a calendar table that defines for a given date what accounting period the date falls under and whether it is a working day or not as well as give a...

Greetings from Minneapolis! Hopefully one of the experts here can help with a little puzzle and find the missing piece. I have a table that I have created in SQL that contains all of our business calendar information. It has a column for YearNbr, MonthNbr, WeekNbr, WorkingDayNbr, etc. The...

Hi, I am in the process of developing an Impromptu Report that includes several sub-reports, charts and drill through capabilities. It is kind of a central business "health monitor" that shows summaries of quote activity, bookings, sales activities for the last 5 years, and more...

Hi, I have a bit of a puzzle. I am creating a summary report that is a bit like a "balanced scorecard" type. I want to display quote, booking, and invoice for the past 5 years and provide the ability to click on a year and get a display of monthly quote, booking and invoice summary...

Are you using Access Manager as your authentication source? If so, I can tell you what we do... If not I won't offer advice that might be confusing otherwise.

Hi, I bet this problem has a simple solution. It is too complex for me however so I hope one of you experts can help... I am attempting to create a form and subform and I am having some problems getting the controls right. My general task involves creating a main form that is read-only and...

I guess I cannot really help here if you are not able to get over the large resultsets problem. I can only imagine that if you can pull the data in as one table (Access Query, IQD file, whatever) things would be fine. The maximum records I pull into Cognos is about 130000 records. Maybe that...

Do your separate datasources have similar or identical column names? Tony T. in Mpls.

Hi, I need to figure out how to segregate quote, booking, and sales information in Impromptu and I am having problems getting the dates to match properly. I am trying to replace an old "cut and paste" Excel Daily sales report with an automated Impromptu report. We use a Lunar 52...

I temporarily lost my USB ports on my installation of XP Home Edition. I tried everything short of re-installing XP. Luckily after much hacking and searching for the answer I finally just moved my NIC card and Modem out of their slots to un-used slots and my USB ports were finally recognized...

I probably shouldn't be the first to respond to my own message, but in case anyone does a search on XP and USB, I am VERY GLAD to share that if your USB ports conk out and all else seems to fail, BEFORE you do a re-install, try removing your cards and putting them in different slots. I moved my...

Hi, I am trying to do a backup of my Documents and Settings and having troubles in Windows XP Home Edition. I have created a folder for my burnable CD on my E drive. When trying to copy My Documents and Settings to this folder I get the error message "The destination folder is a subfolder...