Hi all
I used to have a macro which contained the PublishHTML Object. This was while using version 7.0 of Impromptu. I've since upgraded to 7.0, and all of a sudden the script won't run. I've noticed that, within Impromptu, the 'Publish as HTML' option has been replaced with a normal Save As...
Hi guys
Banging my head against the wall here: We are helping out a client with their reporting. We extract the data using Impromptu and save it in Excel format, and then we have to create a chart from the data and put it on the same sheet. The problem is that the number of rows and columns...
Hi
I have a text frame with data in it within a form frame in Impromptu 7. However, the size of the data varies radically from record to record. Does anyone know how to make the text frame scrolable?
Thanks
Swathi
One option is to have a table with all the time intervals and then use a Left outer join to join it to the raw data table shown above.
That should solve it, although you sometimes get problems when applying a filter on the crosstab.
I have exactly the sam issue. It seems as if the Macro exports the report to version 3 (!!) of Excel. I am using the following command:
'Save as excel
strExcelFileName = Left$(ImpRep.FullName, Len(ImpRep.FullName) - 4)
ImpRep.ExportExcel strExcelFileName & ".xls"
Anyone out...
Hi there
Maybe you can try the following - it seems to work for me. (I've also unchecked the 'Always display this screen' option on the catalog login screen.)
'Open the catalog
' ImpApp.OpenCatalog "C:\Program Files\Cognos\cer2\samples\Impromptu\reports\", "UserClassID"...
We are in the process of setting up a Shadow Databse (SQL Server) for SC5. However, we can't seem to find any info on how to specify the Database server in the sc.ini file. The sqldb:<database name> paramater works fine when the Shadow Database is on the same server as P4, but not when it...
We are currently consulting at a client who uses SC 5, and at first we also wanted to change the P4 DB over to a RDBMS. However, after doing some investigation, we decided to rather create a shadow RDBMS database. P4 is optimsised for performance, and we use the Shadow database for all our...
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.