Search results for query: *

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

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

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

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

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

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

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

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

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

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!

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

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

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.

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!

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

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

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.

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