Liveware Publishing Support Forum

Is there a way to print the server name from where the report is getting the data from?____Tried the following expressions:__a) SQLEXP( "host_name()" )__b) SQLEXP( "SERVERPROPERTY( ^SERVERNAME^ )" )__*R&R will not even preview the report having the above calculated field expr...

Yes Kathleen, that did the trick. Thanks.____I would think that people would have seen something like this before...is this a work-around? __Or is that the intended way R&R SQL works?__

Yes, that worked...but now it prints a square block at the end of each line.

For a ^text^ field type in a table on our SQL Server, we noticed that it is ignoring a single Carriage Return (CR) and Line Feed (LF) unless there is a pair of them. Is this intended to work this way?____For example, a field containing a single CR/LF and displaying:__First line break here!__Next Lin...

So when distributing reports, the client workstations which print the reports do not have to have a DSN?____The report will use the data source stored with the report?____Roger

For a client/server platform, is there a way to specify a SQL connection string in the R&R INI files? ____Or does each workstation need a system data source name (DSN) for R&R to determine the report data source?____Roger

I am trying to implement the R&R OCX control in our CA-Visual Objects Application. I can load a report, change properties, and print/view with no problems. ____What I would like to do is load a report and interrogate the properties that were saved with the report. This would be similar to using ...