I can't create a group when using a TTX file.

[raedwa01]

I am trying to create a report using a TTX file and passing an ADO recordset to the report.

My data looks something like the following:

User1 Item 1 Item1Cost
User1 Item 2 Item2Cost
User1 Item 3 Item3Cost
User2 Item 1 Item1Cost
User2 Item 2 Item2Cost
User2 Item 3 Item3Cost

and so on.

Essentially, i have 3 tables here. User List, Item List, User Item Bridge.

When i create a ttx file i get the following
UserName string 50 string sample value
ItemName string 50 string sample value
itemcost currency 1.00

Now, when i create a new report and specify the TTX using active data as the db source the Insert Group menu option is off! I need to make the report group by user name and show the items and so on for that group. I can't do something like multiple detail fields since there's no exact number of items a user will have.

Please Help

Rob Edwards

 

[kenhamady]

Can you post your actual TTX file contents here? Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[raedwa01]

I figured it out. It was a stupid mistake. I selected a ttx file, but didn't "add" it to the report for the datasource. Once i did that, it worked.