Liveware Publishing Support Forum

Thanks for the prompt response.__I have to create a filter report that passes the account number and then run the final report based on the output of the filter report.__Another question - RI_SORT - for SQL is this functionality available? I tried hardcoding RI_SORT1=fieldname it is complaining that...

Kathleen,__I was able to get the RI_REPLACE working. __If there are 4 table unions, even though I define only one variable <<^EACCOUNT^>>, RI_REPLACE needs 4 entries ..__RI_REPLACE=<<^100060^>>,<<^10060^>>,<<^10060^>>,<<^10060^>>__The last question - how do you pass the parameter during runtime?__Ca...

Kathleen,____I found the Application documentation in the web.__The <<^EACCOUNT^>> does not work when using RI_REPLACE=10060 or RI_REPLACE=^10060^ in the rss input file.__Maybe this functionality is not available in SQL unions(4 separate unions with single common where clause using accounts=<<^EACCO...

Hi,__How do you get around ...I am using SQL unions.____Say .. select aa__ FROM fin_accounts__ WHERE accounts = ^&Enter_Account^__ union__ select bb__ FROM fi_accounts__ WHERE accounts = ^&Enter_Account^____when I paste this to Arpeggio new user sql, it would say that the column is invalid._...

Workstation: Arpeggio Report v 2.0 Build 923.0.0__OS : Win 95____I am getting this error when we ran an Arpeggio Report..____"Error running report DB access specific driver could not be loaded due to system error 1157"________I tried to re-install Arpeggio intersolv oracle driver but it di...

I am running Arpeggio for Desktop Report Designer 2.0 SQL version 9.0.9.____I am joining two tables with two different ODBC drivers. __One is Oracle ODBC driver and the other is Microsoft dbf driver. If I go to File/Data Source Connection, I can see both Oracle and the dbf connection sources. Howeve...

I am running R&R for Windows SQL version 9.0 build 9.0.009.____Can I use R&R to create reports using Clarion database 2.1 version. The file extensions are dat. What drivers do I need?____Thanks____Bert