Click here to Skip to main content
12,354,543 members (62,379 online)
Rate this:
 
Please Sign up or sign in to vote.
Hi,

I'm working on designing a crystal report.
I need to display two tables on one page. (In other words, two details sections on each page).

Both the tables have independent records of each other.
e.g.
Table 1 columns are - Item No, Item Name, Date, Qtty Sold, Selling Price
Table 2 columns are - Item No, Item Details, RemainingQtty


Table 1 has 30 rows and table 2 has 5 rows

Can someone help me out how to achieve this?

Many thanks,

Best Regards,
Tarun Suneja
Posted 17-Mar-12 1:41am
Edited 17-Mar-12 5:05am
v2
Comments
Tarun.Suneja 17-Mar-12 9:33am
   
Please reply. I am not able to find any solution for this.
Please help.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 5

it is not possible to make a report in Crystal Report using multiple database

i've been looking for a sulution for more than 6 months now.

i need to make a report from 2 tables (not linked)
on table for header and EST information and one table for contnts
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Comments
Tarun.Suneja 17-Mar-12 8:45am
   
I want to display two tables in my report and not combined single table.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 4

hi,

is it possible to achieve this?
coz i want both the tables to be displayed separately on the report.

Many thanks,
Tarun Suneja
  Permalink  
Comments
NMathur 29-May-12 8:21am
   
Hi Tarun,

Did you find any solution for this, I have similar situation.

Please reply if you have solved this.

Thanks in advance.
Tarun.Suneja 29-May-12 13:42pm
   
No dear, I'm still not able to find its solution. I believe its not possible.
Let me know in case you have any idea. We both can work on it.
NMathur 30-May-12 1:08am
   
Hi Tarun,

Thanks for reply.

I think you are right, it is not possible in CR. So my idea is to use subreport when we are showing reports and I will merge PDF files of both reports to show tables one by one.

I hope this will work.
Tarun.Suneja 30-May-12 13:51pm
   
Hi,

I had tried using two subreprts in one report.
That worked for me.
If you want I can send you a sample code.

But my issue was that both of my subreports have group by clause.
So instead of getting outputs as:
Page 1:
Table 1
Table 2

Page 2:
Table 1
Table 2

I'm getting the output as :
Whole Report of subreport1 followed by whole report of subreport2.

Best Regards,
Tarun Suneja
NMathur 31-May-12 6:34am
   
Hi tarun,

Actually the output you are getting, is according to my requirement. And I was looking for something similar to this, while searching on web I reached to your post.

Yes, please send me sample code, if you can. I will be very thankful to you.

And the solution which I have shared in my last reply, I worked on that. I was not able to show report and its subreport because I don't know how to bind subreport dynamically. But I was able to download merged PDF by loading both reports separately. Table1's reportdocument and Table2's reportdocument.

Here, see this post .. which I have followed for PDF merging:
http://stackoverflow.com/questions/6778721/merging-memory-streams-to-create-a-http-pdf-response-in-c-sharp/10831499#10831499

Thanks and Regards,
Namrata Mathur
Omkar Hendre 3-Oct-14 6:36am
   
Hi Tarun,
Did you find any solution for this, I have similar situation.
please help me to solve me problem

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160621.1 | Last Updated 6 Oct 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100