how to display a joined tables data in page template?

Question

User1174340047 posted
how to display a joined tables data in page template? hi,all. by default, dynamic data displays data from only one table in one page template, for example, data from Orders and [Order Details] tables are displayed in two seperate pages. Now i want to display data from both Orders and [Order Details] tables in single page. For example, i want to display data from the following sql result in the List.aspx template: select O.OrderID, O.OrderDate,D.UnitPrice from Orders O, [Order Details] D where O.OrderID = D.OrderID How can i achieve that? Thank you in advance.

Answer 1

User-330204900 posted

Hi My Crystal, have you been able to view my blog, as you were having trouble with it?

If you can now read my blog I have a series of articles regarding page template here:

1. Custom Pages Part 1 - Standard Custom Page based on an existing PageTemplate and customised in the DynamicData\CustomPages folder.
2. Custom Pages Part 2 - A completely Custom Page again in the DynamicData\CustomPages folder.
3. Custom Pages Part 3 - Standard ASP.Net Page with Dynamic Data features added to take advantage of the FieldTemplates.
4. Custom Pages Part 4 - A DetailsView and a GridView using Validation Groups
5. Custom Pages Part 5 - I18N? Internationalisation Custom Page

Also see this article here:

1. The Anatomy of a FieldTemplate.
2. Your First FieldTemplate.
3. An Advanced FieldTemplate.
4. A Second Advanced FieldTemplate.
5. An Advanced FieldTemplate with a GridView.
6. An Advanced FieldTemplate with a DetailsView.
7. An Advanced FieldTemplate with a GridView/DetailsView Project.

Part 7 have a project file you can download with some of the FieldTemplates developed in the series. 

I hope you can view the articles as they repeasent my learning curve on DD.

Hope this helps [:D]

Answer 2

User-1005219520 posted

You should be able to do that with a sproc (stored proc/stored procedure). See this post