Search results for query: *

JonFer said: "when selecting from a single table without an ORDER BY clause, Access uses the primary key to sort the records ...but a WHERE clause removes the default sorting as you saw." This is exactly what happened. I validated JonFer's point by removing 'ORDER BY' and 'WHERE', the query...

Try a 2-step approach first. 1) SELECT productID count(productID) FROM orders GROUP BY productID. Make it a query. 2) From the first query, SELECT productID countx ORDER BY countx DESC WHERE COUNTX <= 5. Note, the above is not real syntax, just a logic. COUNTX is the name of the count field in...

Thanks! PH. I guess this is true in all SQL based databases. Dave

I have a simple query 'select * from fact where ...'. The fact table has a primary index and loaded with several batch of data files in appending way. When I run the query, the result is not ordered by the index. Why? I added ORDER BY in the query and all is fine. But I do like to know how does...

An IMS file is called a "Hot file" in Impromptu. It is a result set, a created file you saved in a Windows/Explore folder. You can then use it as the data source instead of an "Impromptu Catalog" to create your main query (report). The IMR that creates the Hot File is like your 'supporting...

Try this: 1)create an impromptu report, save as A.IMR. Save it again as a hotfile A.IMS. 2)In your new report change the data source from Hotfile instead of the standard default of 'catalog'. Pick A.IMR (not A.IMS). Hope it works for you.

I do not think Impromptu can handle CSV file. Instead you may want to save the CSV to Dbase. Then try your ODBC connection. Good luck. Sorry I do not have access to Impromptu Admin to verify what kind of data sources are supported.

Thanks to Flex13 and DoubleD. Does Cognos still sell Impromptu/Windows to new clients? You can hardly see "Impromptu" mentioned in Cognos.com. Cognos seems to want you pay attention to ReportNet only. It is a big ticket item and small clients will be suffered in the future. I hope PowerPlay has...

I read about Impromptu is being replaced by ReportNet. I have a few questions and hope you can share your thought or fact. 1)When do you think Cognos will stop developing Impromptu? 2)When will Cognos drop Impromptu support? 3) Same questions for PowerPlay for Windows. Thanks!

I used PowerPlay for Windows to create a crosstab report with for example, prodct line/product across all measures. The prodcct line/product is a defined 'subset' from the All Product dimension. I saved the report as 'Microsoft Excel Workbook' for a user who does not have PowerPlay. My problem...

These are good questions. I gave the post a red star to highlight an unanswered post. I am also need to know the answers before I recommand PP/Web as the choice to the next project. Someone please help! Thanks! David Liang

Thanks for the posted question. I tried to ask the same question and found out that it is already posted. So I second it with a red star. Can someone please help us? I am considering use PowerPlay Web for a big project, but would like to know what do I have to sacrifice from say...

Yes! You can do it in PowerPlay. Put &quot;State&quot; in [LAYER] and the scope of [ranking] is within each layer. David Liang

I believe when you display a 'prompt' value, for example in the title box, it will show all the time regardless the resulting answer set. David Liang