[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


How to create crystal report dynamically with dataset

Posted on 2007-08-10
Medium Priority
Last Modified: 2013-11-07
In VB.net application I am generating the dataset which contains several tables these tables have no relation between them, now I need to display all those tables on the crystal report

Also I am not sure about the exact number of tables and number columns in the table because they all are generating dynamically

I really appriciate any code examples

Question by:shieldguy

Expert Comment

ID: 19671734

you can use Temp Table and gather all needed data in that table ... and just
linke your temp Table to your report .
LVL 42

Expert Comment

ID: 19671995
No need to use temp tables, you can pass datasets into crystal reports.  You can find the code samples needed here:  http://www.businessobjects.com/global/pdf/dev_zone/VS2005_Walkthroughs.pdf     Note that Visual Studio help and MSDN have code samples as well.

You will need to define the report structure in advance however - you can for example design a report with 10 columns and if your table only has 6 just pass the six columns and four null columns.

Because there's no relationship between the tables you're going to need to either do separate crystal reports or you can do each table as a subreport and put all subreports into a single 'main' report.  It'll have to be one or the other because Crystal won't support disconnected tables gracefully.

LVL 101

Expert Comment

ID: 19672949
I agree with frodoman.  

You can also do the entire report from an application but that will require a separate license for each user and the stand-alone version of Crystal.  

What is the purpose of this reporting?

I find many times the user thinks he needs maximum flexibilty but after reviewing the requirements, I can build one o more reports that satisfy the requirements even if it means having a few extra fields in a report.  

LVL 70

Expert Comment

by:Éric Moreau
ID: 19673335
>>Also I am not sure about the exact number of tables and number columns in the table because they all are generating dynamically

Normally, a report is bound to a datasource definition (tables, fields, ...). It would probably be better to find another format like outputting to an HTML format.

Accepted Solution

hatem72 earned 2000 total points
ID: 19675522

if are looking for quick way to build reports check this:

Full Series:

Hope this help ...

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses
Course of the Month19 days, 20 hours left to enroll

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question