How mand crystal designer report can be in one vb6 project

I have one vb6 application and using crystal report 8.5 designer. I have 150 reports are there in project. I want to more reports in project but it give all different error and does not allow me to select crystal report file (.rpt). This menu is not enabling. what could be the reason. Thanks in advance
Nitin ShahAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Add a Crystal Reports Viewer control?  Can you then add reports?
Sounds like you are adding them as part of the application rather than using the report files separately and just adding the viewer.

We did that and ran into an issue at around 60 reports but then the application had a lot of other forms and controls.  We found partially but the final solution was to rewrite the reporting part of the application to use the RDC and the viewer.  We had to install the reports separately from the application but that had the benefit that if a report changed we didn't have to recompile the program.

I may have that VB6 upgrade but I suspect you will just delay the inevitable.

What code are you using to call the reports?

Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Nitin ShahAuthor Commented:
dear mimcc

This is part of application.

Crystal Reports Viewer control is already added.

I am adding in Designers by add - Crystal reports 8.5  - add already tested crystal report (.rpt) file will be added and save as .dsr file.


It is the dsrs that are causing the issue.  There is a limit to the number of controls and files in a VB6 application.  I don't know what it is.  

We got around the issue by using another method for calling reports.  Instead of bringing the reports into the application we used the rpt files directly from the viewer.  It takes a different set of code to do that but it works quite well.  If done properly you can use a single viewer form for all the reports.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Nitin ShahAuthor Commented:
while adding report, it is CRAXDDRT.DLL which is giving problem. it does not allow me to add report (.dsr) to system.

You don't want to use CRAXDDRT.  Use CRAXDRT.  CRAXDDRT can require runtime licenses for the end users.

You don't use dsrs with CRAXDRT.  You use the rpt files..  I'll try to find my source code.

Here is code that should work

Option Explicit
     Private crApp As CRAXDRT.Application
     Private crRpt As CRAXDRT.Report
 '   Open report
     Set crApp = New CRAXDRT.Application

     Set crRpt = crApp.OpenReport("C:\Reports\Crystal\MyReport.rpt", 1)
 '   Set flags for CRViewer
     crRpt.MorePrintEngineErrorMessages = False
     crRpt.EnableParameterPrompting = False

 ' Set the viewer's report source to the Report object
     Me.rptCRViewer.ReportSource = crRpt

Open in new window

Nitin ShahAuthor Commented:
Dear mlmcc

Thanks for your kind suggestion.

I have break project into 3 part.  The Maximum .dsr no is 250.  That what i able to test it.

Thanks all for kind support.

Nitin Shah
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.