Multiple ttx files problem...

[mmaz]

Hello,

I built a report (CR 8) that uses 2 ttx files. The second ttx file will only hold a logo that will be displayed in the report header. This logo will be set at runtime.

I'm calling that report from an ASP and passing it a recordset. The problem is, Memo fields will not be displayed correctly on the web. If, for example, I have a field called "Description" of datatype Memo in CR (but datatype "text" in SQL Server) and the first value for Description in the recordset is "Hello", than the description for all the records will show up as "Hello" on the ASP.

I'm getting the correct values in my recordset, they're just not being passed correctly to the report.

Also, this will only happen if I have dropped fields from both ttx files on the report. If only fields from one ttx file are on the report, the Memo fields will be okay.

Any suggestions as to how to fix this problem? Having 1 ttx file is not an option and I'm now considering building a sub report just for the logo, but would much prefer finding a quick solution.

I've contacted Seagate, they've looked at my queries, reports, ttx and ASP code, everything is okay. HELP!

Marie

 

[kenhamady]

You can't link a recordset to a recordset, so you can't use 2 ttx files in one report (without subreports). They will generate a cartesian, which is probably what is causing your behavior.

I am puzzled becuase you say the second ttx will only hold a logo, but then you say you have fields from both TTX files. A TTX can't hold a logo, and a logo isn't a field.

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[mmaz]

Hi Ken,

The logo is a Blob, and I'm passing 2 recordsets to my report, 1 recordset/ttx.

This seems to be a problem with CR 8. All the other fields are being correctly displayed, except for the Memo fields.
I rebuilt the reports 3 times, to finally realize that a report can have 2 ttx files and all fields will be correctly displayed if only fields from one ttx file are on the report. As soon as you use fields from the other ttx file, then the memo fields are not displayed correctly.

I couldn't solve that problem and Seagate could not help me so I just built a subreport that would have the logo on it in order to have 1 ttx file/report.