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