Hi Mark,
Without seeing the rest of your macro, I'll guess that the macro loops through a folder containing reports. Each report is opened and passed the prompt value.
If this is indeed the case, are you setting the report object to nothing each time you are finished with it?
ie...
I usually use ADO however ... you might try enclosing the date variable in single quotes.
ie:
"'" + varDate + "'"
If you display the value of the date using a MsgBox, is it in a format that is recognized by Oracle?
Hi Gilles,
I believe you are casting to an ascii character using the asc function rather than to a binary value.
ie:
cslg(asc("A")) = 65 however the binary value of "A" is really 01000001. I suspect you would then want to perform your bitwise operation on the binary value using the xor...
Hi Gilles,
I do not think this is going to be possible with native CognosScript code. To accomplish the converion to binary, you would need to create a byte array. Unfortunately there is no Byte datatype in CognosScript.
Alternatively, you could create a VB COM dll that would perform the...
Should be able to use the "upfcommand" executable to perform a describe DescribeNewsBox. This will output an xml file with all NewsItem Ids.
Check the Upfront developers guide for more info on the command.
You would need to customize your PPWeb environment by modifying one of the javascript files in the webcontent/ppweb folder.
The script file, dbdata.js, defines an array named "dimBarData". Within the array, the item "nowrap" is set to "true" by default. Perhaps setting this value to "false"...
There is no easy way to accomplish this task.
A couple of suggestions.
1. Modify each individual IQD in a text editor
NOTE: Manual modifications to IQD files are not supported by Cognos.
2. Add a new calculated column to the datasources within the Model to reflect the new value.
It is...
Increase the SORT_MEMORY size - should be a setting in Configuration Manager, otherwise the entry can be found in the cer3.ini file under the [Services] section. This value should be increased in increments of 512.
Do you have a namespace in your Access Manager named "Script". If not, objAuthDoc will be assigned a value of "Nothing" and therefor attempts to reference this object will fail.
A couple more options ...
1. You could create Hotfiles against one of the databases (must be a seperate catalog) and join the hotfile to your table(s). Access "may" have troubles large amounts of data.
2. Add your Oracle connection as a "Linked Server" in SQL Server and use SQL Server Views...
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.