Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
|
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 26th, 2009, 10:31 AM
Authorized User
 
Join Date: Dec 2007
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to pannasn
Smile Crystal report with multiple tables

Hi friends,

I have a crystal report with an underlying dataset consisting of 2 tables namely 'reports' and 'organizations' .These tables have no links.

I retrieve the reportname column value from the 'reports' table and place it in the report header section. And I list the organizations in the details section.

When there are records available in the details section, reportname is showing correctly.

But the problem is, when there are no records in the details section, reportname is not displaying in the report header section.

Can anyone suggest how to resolve this issue ?

Thanks in Advance
Panna
 
Old October 27th, 2009, 09:15 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik
Default

dear friend:
I've just gone by ur theory & everything is ok with that.
if u have no link between 2 tables it means, u have no relation between them & if u had its NOT from Detail to master.
anyway, I suggest u to do
1. check ur Database Expert & check if u have any link.
2. drop detail table from report database
3. check dataset passing to report
i guess u might be done a bit mistake or ...

stay in touch
__________________
Always,
Hovik Melkomian.





Similar Threads
Thread Thread Starter Forum Replies Last Post
How can display to different tables in Crystal report? [email protected] Crystal Reports 0 February 4th, 2009 08:18 PM
Crystal Report 8.0 - Working with Temporary Tables deebeedee VB How-To 0 July 27th, 2006 07:30 AM
Create a report from multiple tables in a Dataset verdun Crystal Reports 4 May 12th, 2005 09:20 AM
Multi tables in the crystal report? lovelylife1982 Crystal Reports 1 March 11th, 2005 04:21 PM
multiple tables on one report? lanctotd Access 4 October 8th, 2003 03:41 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.