Search results for query: *

Hi, I have a catalog that had no creator password set. I logged in as creator, went to user profiles, user class tab, and gave the creator user class a password. Now when any user opens the catalog, the creator password is auto completed (albeit stared out). This is the only class it is...

Thanks for that, I'll give it a try. Our DB does support First-word, but for some reason, Last word does not seem to be supported.

Hi, Does anyone know of a way to split a text column into separate columns in Impromptu. For example, in our DB we hold Forename(s) and Surname. The Forename(s) column needs to be split for anyone with more than one forename. i.e : Before split: Fornames | Surname...

Is there anyway that Impromptu can select a percentage of the results randomly. For example, we have say 12,000 active employee's on the database, and we need to create a list to show 1% of these employee's, but the list must be randomly generated each time the report is run. Thanks.

We currently have a catalog that has had tables added to it from 3 different databases. Although these databases are identical, they have different names. When adding tables in the catalog there is now only 1 database on the left hand side but the left hand side (catalog tables) is still...

Thanks, I will give that a try. J.

Bruce, I am aware of the content Overview report, but this will show a list of all the tables in the catalog, where as I only want a list of the tables used in our reports. There are a lot of tables in our current catalog that are not needed, and I need to compile a list of tables that are...

Hi, My company is currently upgrading impromptu from v5 to v7. We will be building a new catalog as the database is also being upgraded. I have been tasked with compiling a spanning tree (ie. all the database tables used in our reports of which we have over 600 !) Apart from running the...