Hi Ragavendra,

Thanks for your response.
The problem was with the driver. The client had the rpt refering to the Oracle drive provided by Cr and i had it refering to the ODBC driver. I made it point to ODBC driver and things are fine now.

However, I have other queries now. As I had mentioned i am developing the CRs in 10 from 4.6. So, I need to make changes to my VB6.0 code accordingly which calls for certain mapping as shown below.

CR4.6-VB6.0 = CR10-VB6.0
Report1.SQLQuery = Report1.SQLQueryString
Report1.SortFields(Index)=?
Report1.GroupCondition(Index)=?
Report1.SelectionFormula=?
Report1.Formulas(0)=?
Report1.Destination=?
Report1.Action=?

Please help me out with this!!

Thanks & Regards,
Prashanth

Hello prashant

check the following...

a.DataDefinition.SortFields(0)
DataDefinatione has all options for groups, formul

a.ExportOptions.DestinationOptions()
Dim c As DiskFileDestinationOptions
c.DiskFileName()

a.Load()

where a = your Report Object

I got this from the version of CR FOR .NET 2003, and it will be same as the
class structure and arc of the CR is all one.

Hope this helps..


With Regards,
Raghavendra Mudugal

Raghavendra,

looks like DataDefinition is not supported by VB6.0. However I have got the mapping right but I am not able to execute them successfully.


I created a report wherein I grouped using a field by ascending order.
I am trying to override that in the VB code as shown below
Report.GroupNameFields(1).GroupNameConditionFormul a = "GROUP1;{MN_COMPANY.STATE};ANYCHANGE;D"

But when I view the report I still see it in ascending order only.

The net information says this
GroupNameConditionFormula - Gets or sets the group name condition formula.Can be written only when formatting idle.

It’s clear that we can set the formula in the code but I don’t understand “Can be written only when formatting idle”

Do u have any idea?

Hello Prashant,

Dim c As New CRAXDDRT20.Application
Dim d As Report
Dim e As GroupNameFieldDefinition
d = c.OpenReport("c:\c.rpt")
e = d.GroupNameFields(0)
e.GroupNameConditionFormula [it returns the condition formula name]

d.FormulaFields(0).Value [just try this]

well, this concept is completly RnD one, hope we will figure it out
soon. :)

hope this helps


With Regards,
Raghavendra Mudugal

Ragavendra,

check out this link http://www.mahipalreddy.com/cr/crcodes1.htm#crfrm
I got all answers to all my queries from here.
Once again thanks for your quick responses.

Hi prashant,

i saw that link, looks liks a good resources for beginners like us.
well thanks alot for that link. anyway you got your problem solved.



With Regards,
Raghavendra Mudugal

Raghavendra,

Is it enough if i just open the crystal report(developed in v6) using CRv10 and save it in order to convert it to v10. does all the formating features and other stuff gets converted as it is or shud i do some thing else?
I am just talking about converting stand alone CRv6 to CRv10 not the Vb interfaces.

Hello Prashant,

to my previous experience, i and reports build in CR4.6 version and later i needed
them to convert to CR8.5 (not much idea on CR10), what I have done is, i opened the
report in new CR 8.5 designer and refreshed the report and saved them to the
diff location with same report name. And I also made sure that data is comming
correctly from the mapped access database.

Well it was working fine with no problem.

Even i tried opening this new report which is converted to CR8.5 and from
VB also I did'nt see anuy problem. It opened properly and showed the data correctly.

TO be sure, I did'nt used CR10 at all. But upgrading the report from lower to
higher version is always possible. Just open the old ver report in CR10 and,
refresh, and save the report in diff loc. It must work, else, then in CR10 you
have to check the way to conversion ro higher version, must be there will be a
tool to do this.

Hope this helps.


With Regards,
Raghavendra Mudugal

Raghavendra,

This VB6-CR6 that i am upgarding as VB6-CR10 is accessed by many users for pulling reports. Should the users install CR10 or is it enough if they just install the appropriate CR controls?

Hello, Prashant.

If my guess is right, you are using

a) A stand alone vb app, with CR10 and ms-access or any other db.
OR
B) A client vb app and CR10 with central db like ms-sql2k or other

In both the cases, TO MY KNOWLEDGE, just by the component, its not going to
help. If you look into CR10 documentation, you will the list of file (used
at runtime) need to be deployed and registered for successful execution of CR10
without any problem.

In my case, I used all CR8.5 runtime files which i got from documentation
and used VSI 1.1 (Visual Studio Installer with MSI) is the best for such
scanerio to deploy and register your complete app without any problem.

After this, you can see the reports propely.

Well, this is my way.

Hope this helps.


With Regards,
Raghavendra Mudugal