Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB How-To
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #21 (permalink)  
Old June 12th, 2006, 01:40 AM
Authorized User
 
Join Date: May 2006
Location: Chennai, TN, India.
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Prashu
Default

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

Reply With Quote
  #22 (permalink)  
Old June 12th, 2006, 04:45 AM
Friend of Wrox
Points: 687, Level: 9
Points: 687, Level: 9 Points: 687, Level: 9 Points: 687, Level: 9
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2004
Location: Chennai, Tamilnadu, India.
Posts: 221
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #23 (permalink)  
Old June 12th, 2006, 07:50 AM
Authorized User
 
Join Date: May 2006
Location: Chennai, TN, India.
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Prashu
Default

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?


Reply With Quote
  #24 (permalink)  
Old June 12th, 2006, 08:49 AM
Friend of Wrox
Points: 687, Level: 9
Points: 687, Level: 9 Points: 687, Level: 9 Points: 687, Level: 9
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2004
Location: Chennai, Tamilnadu, India.
Posts: 221
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #25 (permalink)  
Old June 13th, 2006, 05:15 AM
Authorized User
 
Join Date: May 2006
Location: Chennai, TN, India.
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Prashu
Default

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.

Reply With Quote
  #26 (permalink)  
Old June 13th, 2006, 05:30 AM
Friend of Wrox
Points: 687, Level: 9
Points: 687, Level: 9 Points: 687, Level: 9 Points: 687, Level: 9
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2004
Location: Chennai, Tamilnadu, India.
Posts: 221
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #27 (permalink)  
Old June 15th, 2006, 12:54 AM
Authorized User
 
Join Date: May 2006
Location: Chennai, TN, India.
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Prashu
Default

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.

Reply With Quote
  #28 (permalink)  
Old June 15th, 2006, 01:05 AM
Friend of Wrox
Points: 687, Level: 9
Points: 687, Level: 9 Points: 687, Level: 9 Points: 687, Level: 9
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2004
Location: Chennai, Tamilnadu, India.
Posts: 221
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #29 (permalink)  
Old June 22nd, 2006, 12:07 AM
Authorized User
 
Join Date: May 2006
Location: Chennai, TN, India.
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Prashu
Default

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?

Reply With Quote
  #30 (permalink)  
Old June 23rd, 2006, 12:40 AM
Friend of Wrox
Points: 687, Level: 9
Points: 687, Level: 9 Points: 687, Level: 9 Points: 687, Level: 9
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2004
Location: Chennai, Tamilnadu, India.
Posts: 221
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
VB6 wont display crystal Reports 10.0 cnobles VB How-To 2 September 7th, 2014 10:21 AM
About Crystal Report 10 Suhas VB How-To 2 April 10th, 2007 12:27 AM
Vb6 with crystal reports 10 Eleakim Cribe Pro VB 6 0 June 22nd, 2006 10:20 AM
good book for crystal report 10 swati_joshi ASP.NET 1.0 and 1.1 Basics 1 April 20th, 2006 04:09 AM
crystal report 10 santwan Classic ASP Professional 0 December 16th, 2005 05:58 AM



All times are GMT -4. The time now is 07:31 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.