Showing posts with label v10. Show all posts
Showing posts with label v10. Show all posts

Tuesday, March 20, 2012

crystal reports

I have vb.net 2003 and crystal reports v10.

1) how shall I add component of crystal reports in my vb.net?

2) In crystal reports how do you find the number of the days in a particular month.(e.g. aug has 31 days & sept has 30 days). (e.g in vb.net MYDAYS_MONTH = DateTime.DaysInMonth(Now.Year, Now.Month)

3) what shall i do in order that my reports shall be displayed in vb.net while running the program. (i.e If I run the program it does not display the report but if I run the report separately then I can view the datas).

Note:
a) the database is in access.
b) it has the database password.

ThanksI'm using Crystal Reports XI, but I think the code is just about the same.

To view a report using code:

1) Add the "Crystal Report Smart Viewer" control to your project (crviewer.dll)
2) Create a form, and add a CRViewer control to the form.
3) In order to view the report in the form, your would look something like the following (I haven't had much expirience with VB.NET, but I'm sure the code would look quite similar):

Declarations:
Private crxApplication As New CRAXDRT.Application
Private crxReport As CRAXDRT.Report

This goes in your Form_Load event:
Set crxApplication = New CRAXDRT.Application

When you need to display your report:
Set crxReport = crxApplication.OpenReport(ReportFile)
crxReport.DiscardSavedData

For X = 1 To crxReport.Database.Tables.Count - 1
crxReport.Database.Tables(X).Location = FullDBPath
Next X

CrViewer.ReportSource = crxReport
CrViewer.ViewReport

I hope this helps.
-- Heather|||Dear Heather,

Thanks for your help.

I would like to inform you that I followed all your steps as you have said put still all my reports are not been displayed in my application.

Can I have your help please.

Thanks|||Did you get error or the page is not displayed properly?

Thursday, March 8, 2012

Crystal Report Distribution - Newbie

I am a newbie at this and I have gotten myself very confused, someone please HELP!

I have V10 Pro installed and I have been teaching myself how to create report using it's features. I do not seem to have Crystal Enterprise so all of the repository features are not available.

I have been tasked to build reports that will be distributed to others within my company either as stand alone files or viewable with Internet Explorer. I need to have drill down and parameter capabilities at the users end but none of my users have any Crystal Products. How do I go about doing this?

Eventually, I will be building VFP applications that will run these reports and distribute them to my users.

The vast number of products offered by Business Objects for Crystal makes it a little confusing on a first time user. Will it be possible for me to make and distribute reports to my users without having them install any Crystal products or without me having Crystal Enterprise? I was thinking it would work something like creating a PDF and the end user viewing it with a free Adobe Reader...I actually located Crystal Enterprise 9 on my network, however, I am unable to connect to it, I get a CMS not on PORT 6400 error. Will this work with Crystal Reports 10 Pro? What do I need to do to connect to it?|||See if you find solution at support section of this site
www.BusinessObjects.com

Crystal Report Chart

Dear All,

I was wondering if it was possible to combine two graphs in crystal reports v10 into one.

I have a line graph that is showing a budget over a year and a graph that is showing how much money different people are spending over a year. Both of these graphs are based on seperate store procedures, and making one transparent and sticking it over the other wont work because the y - axis is not static but a dynamic number,

Can you please help??

Thanks

ChristovPls. write in details.|||Instead of using two sps why cant you write one sp having the code of two sps?