Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. WondersWhy

    Link to table with value from calculation

    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...
  2. WondersWhy

    Link to table with value from calculation

    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...
  3. WondersWhy

    Constants for Lunar Calander Calculations

    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...
  4. WondersWhy

    PC Power Survey; Where is the Constraint?

    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...
  5. WondersWhy

    Impromptu Sub-Report vs. Crosstab Puzzle

    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...
  6. WondersWhy

    How do you control user access in Upfront?

    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.
  7. WondersWhy

    Form Subform Question / Problem

    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...
  8. WondersWhy

    Adding IQD Datasources???

    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...
  9. WondersWhy

    Adding IQD Datasources???

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

    Impromptu Report Sum by Lunar Months

    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...
  11. WondersWhy

    USB issues with XP?

    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...
  12. WondersWhy

    Problem burning copy of Documents and Settings

    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...
  13. WondersWhy

    Problem burning copy of Documents and Settings

    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...

Part and Inventory Search

Back
Top