Recent content by vtj

Is it possible the "_" is a reserved character on your system? If so you may have to enclose the name in qoutes. VTJ

Dear Sync, Thanks for the response. I'll let you know how I make out. VTJ

Hi, I've been asked to enable a direct connection to Impromptu from within a java created program. The users want to be able to open Impromptu without reentering their logon information. Does anyone know of any links to documentation on this subject. Thanks, VTJ

The execption join may be database specific which is why I offered the second example. The term is exception join on the AS/400. VTJ

Try an exception join or left outer join. Select a.key1 from tbl_1 a exception join tbl_2 b on a.key1 = b.key1 or Select a.key1 from tbl_1 a left outer join tbl_2 b on a.key1 = b.key1 VTJ

I had the same issue with DB2. I was told to add the line: NOSCAN=0 in each of the Schema entries in the DB2CLI.INI file. The Cognos case number was 3094378 I hope this helps VTJ

While you can't rename the column in the database, you can rename the field in the report or a new file by using a SELECT field1 AS newfieldname. VTJ

Try removing the table qualifier ("A") from your filename. The system may think cuno is a variable as opposed to the column name (A.cuno). VTJ

You can also use a subselect in your where clause. where childid in (select a.childid from maintable a where a.therapist = therapistid) VTJ

Thanks for the help. I'll try it and let you know. You may be right about the mapi. Thanks VTJ

Sorry if I seem a bit dense. This is my original script. Function Email(Message as String) Dim objSession As Object Dim objMessage As Object Dim objRecipient As Object Dim sProfile As String 'You can specify any name you desire sProfile = "Company Exchange&quot...

I should have realized that you would want it to be dymanic. An alternative is use the Catalog description object. Set this description to the name of the catalog and insert that object into the report. You can change the description by clicking on the catalog menu item and select the...

Thanks for your reply. Unforunately I've not been able to get it to work. When I past it into the script and try to compile I get an error objOutlookEMail.cc is not a valid object. I'm trying different combinations of your solution and will let you know if anything changes. I'm using Outlook...

This is a bit convoluted but it works. Insert the catalog name then select it and copy it. Open Notepad and paste in the name. Delete what you don't want then copy that. Insert a text frame into the header and paste in the string you want to see. Delete the catalog name from the header...

I've created an email script to email pdfs to multiple users. I would like to add a cc to those emails. Does anyone know how to do this? We use Outlook as our corporate email system. Thanks, Vtj VTJ