Wrox Programmer Forums
|
Pro VB Databases Advanced-level VB coding questions specific to using VB with databases. Beginning-level questions or issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 7th, 2007, 03:47 AM
Authorized User
 
Join Date: Jun 2007
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ivanlaw Send a message via Yahoo to ivanlaw
Default Urgent:Report

Hi all pro,
May I know how to generate a report(not Crystal report) which got the recently related information what I want only to display out???Please tell me how to write the code for the report...
Waiting for your advice~

Thank you.
 
Old September 7th, 2007, 07:10 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

If you are not using Crystal.. what will you be using to display a report?? the code will vary a lot depending of your idea.. it's not the same to show it in a form, MS word or any other way...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
 
Old September 12th, 2007, 02:06 AM
Authorized User
 
Join Date: Jun 2007
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ivanlaw Send a message via Yahoo to ivanlaw
Default

Hi pro,
I want to ask that if I want to display a variable value in the form to the report,then how is the coding???Please teach me...
Waiting for your advice~

Thank you.

 
Old September 12th, 2007, 07:31 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

that's depends on the type of report you are using, but a value in a form is another variable in your code...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
 
Old September 13th, 2007, 03:57 AM
Authorized User
 
Join Date: Jun 2007
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ivanlaw Send a message via Yahoo to ivanlaw
Default

I use the data report to produce my report.I know that so I need to know that got any code to solve the problem...
Waiting for your advice~

Thank you.

 
Old September 13th, 2007, 08:02 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

I don't understand what type of code are you asking.. the data report has fields inside so you can just pass the value to it.. where exactly is your problem???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
 
Old September 14th, 2007, 02:00 AM
Authorized User
 
Join Date: Jun 2007
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ivanlaw Send a message via Yahoo to ivanlaw
Default

I want to ask you that why my output is display "0",although the actual output is "0.333" after I update the database.Coding are below:
...
DataEnvironment1.rscmdPremium.Fields("Total Annual Premium") = Val(txtPPaid.Text) * 4
curAvg = FormatCurrency(((Val(txtPPaid.Text) * 4) / 12), 2)
DataEnvironment1.rscmdPremium.Fields("AvgPremium") = curAvg <==Here difference
DataEnvironment1.rscmdPremium.Update
...
I waiting for your advice...

Thank you.

 
Old September 14th, 2007, 07:31 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

let's see.. maybe is an error in what are you sending?? try sending a default value (instead of curavg try sending 4 to see what happens) maybe the field is not accepting the thing you are sending?? take in mind that formatcurrency adds a currency simbol to the string...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
 
Old September 14th, 2007, 08:21 PM
Authorized User
 
Join Date: Jun 2007
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to ivanlaw Send a message via Yahoo to ivanlaw
Default

Hi there,
I know where is the problem that is I used long integer in the database.It should be use currency format in the database.I need to know how search a information to display in the data report???Anyway thanks for your helping...
But I am very curious that why you can provide the advices to people like me???
Is it you are an programmer in this web site???Because I think that you are very pro....:)
 
Old September 16th, 2007, 01:31 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

well.. im not involved in any way with wrox (althuoug i have a couple of they books)...
but thanks :)

and now I don't understand your problem...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========





Similar Threads
Thread Thread Starter Forum Replies Last Post
V V V Urgent::Crystal report format issue narayanark2003 Crystal Reports 0 July 6th, 2006 07:58 AM
Groupby Reports in Data Report - Urgent Kaustav VB How-To 0 October 26th, 2005 06:33 AM
Save crystal report as image [URGENT] usamaalam Crystal Reports 1 February 18th, 2005 07:03 PM
Urgent help regarding Data Report Kaustav VB Databases Basics 1 September 29th, 2004 10:48 AM
Data Report help - urgent Kaustav VB How-To 1 January 9th, 2004 10:29 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.