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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.