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

    Impromptu 6.0 in XP

    Hello guys, I was trying to do some joins in Impromptu 6.0 under win xp and the joins wouldn't show up. I powered up a Windows 2000 machine and it worked fine. I came across some info on the internet: "Impromptu must be set to Windows 2000 compatibility mode with an XP operating system" Does...
  2. achaaran

    Maximum value without grouping?

    Just wondering if it is at all possible to not group a field but try to find the maximum of it using Report Studio. ie. Dept Name Salary IT Bob 10,000 Tony 5,000 Sam 6,000 Max 10,000 HR Amanda 10,000 Jill 4,000 Jane...
  3. achaaran

    Supress Detail and Pulling Max associated fields

    I know, I'm just full of questions... In Report Studio 8.1, I have a report that I'd like to surpress the detail (just want the summaries)...I can't find anywhere to surpress it. My other quesiton is (and I have posted about maximum functionality before)...how do I pull the maximums associated...
  4. achaaran

    Report Net and Maximum Function

    Ok, well I figured it out. Turns out that I am referencing a date in my catalog that isn't defined in the catalog... Wierd huh, ok, well what I mean is: There is something in the catalog called emp.datetime, I know for a fact there is a field called emp.date, but it's not defined in the...
  5. achaaran

    Report Net and Maximum Function

    Hey, thanks for the response, but alas it still isn't working. It ignores the grouping all together and just gives me the max for everything. Why is it that the MAXIMUM function is causing difficulties but COUNT works flawlessly? Is there something else I'm missing here? (Impromptu 7 was...
  6. achaaran

    Report Net and Maximum Function

    Oh, furthermore, count does work...fyi.
  7. achaaran

    Report Net and Maximum Function

    Hello, I'm fairly new to reportnet, I used to work on Impromptu 7.0 beforehand. My question for the community is how to use the MAXIMUM function. I know this seems easy, but I have one field that is grouped, and I want to get the maximum # for that group, so ideally, I want this: Dept. Name...
  8. achaaran

    Transformer Cubes Doubling in Size?

    Thanks billnted...I'll look into that and try it out.
  9. achaaran

    Transformer Cubes Doubling in Size?

    Are you serious? I would expect this on a Nintendo forum, but not here.
  10. achaaran

    Transformer Cubes Doubling in Size?

    Hi everyone, just a quick question and I hope someone can help. We have cubes that generate weekly, and they increment slowly by the week, until one day, the size (in MB,) just doubled out of no where. Is there a particular reason for this? Thanks!
  11. achaaran

    Date Conversions

    Sorry...I forgot to mention I am using Impromptu 7.0
  12. achaaran

    Date Conversions

    Hello, Anyone out there know how to convert a string to a date? The string would look something like this: "2004-01-31" Thanks!
  13. achaaran

    Detail and Summary report building

    Sounds like a join problem. The reason I say this is because you use "DISTINCT" and it works. I know this isn't the answer you want to here, but in my experience, 99% of the times, a DISTINCT would suffice. Sorry I couldn't be of more assistance.
  14. achaaran

    Transformer Problems

    Hey drlex, thatnks for the idea, I checked it out, but it was there. I know this is a tricky problem to defuse. Any other quick ideas? Thanks!
  15. achaaran

    Transformer Problems

    Hmmm...thanks for the help. Try telling my stupid boss that though.
  16. achaaran

    Transformer Problems

    Hello, I've got a problem with Transformer and how it's building my cube. I'm using ver. 6.0 of Transformer, and every time I try to build a cube, it misses 3 dimensions. But when I look at the pyh file in Transformer, they are there! But it's missing from the cube. Any ideas would be...
  17. achaaran

    Re: RPT to IWR Problems

    I need some help. I can open up a report in Cognos ver. 7.0, but when it's posted, I enter the EXACT criteria and it generates a blank report. This report has Cascading prompts, but all the prompts are working correctly. Any suggestions please? Thx.
  18. achaaran

    Re: Repeating Cascading Prompts

    Hello, I've got a report in ver. 7.0 that has a cascading prompt. The report that makes up the cascading report is distinct, however when it is displayed in the prompt it is duplicated. Now the values are correct, but it's just very misleading to the user. Any help would be greatly...

Part and Inventory Search

Back
Top