Connecting Tech Pros Worldwide Help | Site Map

functions in data report

  #1  
Old May 30th, 2007, 07:43 AM
Newbie
 
Join Date: May 2007
Location: Mumbai
Posts: 7
Hi,

I need to create manipulated fields in a data report based on a column data. But all I can currently do is calculate sum. Do I need to manipulate data using sql query in access?

Nikita
  #2  
Old May 31st, 2007, 02:42 AM
Dököll's Avatar
Moderator
 
Join Date: Nov 2006
Location: Upstate NY - US
Posts: 2,224

re: functions in data report


Quote:
Originally Posted by Nikita0303
Hi,

I need to create manipulated fields in a data report based on a column data. But all I can currently do is calculate sum. Do I need to manipulate data using sql query in access?

Nikita
Greetings, Nikita!

Right on point. If you are comfortable with VB 6, provided this is the version you are referring to, yes you can do what you need. If not, I would suggest attemtping in Access then have VB load results in.

If you need to achieve this using VB, add your information in for all to see, get better hits that way.

Good luck and welcome!
  #3  
Old May 31st, 2007, 05:55 AM
Newbie
 
Join Date: May 2007
Location: Mumbai
Posts: 7

re: functions in data report


Quote:
Originally Posted by Dököll
Greetings, Nikita!

Right on point. If you are comfortable with VB 6, provided this is the version you are referring to, yes you can do what you need. If not, I would suggest attemtping in Access then have VB load results in.

If you need to achieve this using VB, add your information in for all to see, get better hits that way.

Good luck and welcome!
Hello!
Thanks for the input. Yes I was refering to VB 6 version. As I am not familiar with queries, I was wondering if there was another way out. Thanks anyways.

Nikita
  #4  
Old June 1st, 2007, 01:37 AM
Dököll's Avatar
Moderator
 
Join Date: Nov 2006
Location: Upstate NY - US
Posts: 2,224

re: functions in data report


Quote:
Originally Posted by Nikita0303
Hello!
Thanks for the input. Yes I was refering to VB 6 version. As I am not familiar with queries, I was wondering if there was another way out. Thanks anyways.

Nikita
Let's hear it Nikita!

What do you hope to achieve via VB, at least, what sort of calculation are you trying to do?
  #5  
Old June 1st, 2007, 01:04 PM
Newbie
 
Join Date: May 2007
Location: Mumbai
Posts: 7

re: functions in data report


Quote:
Originally Posted by Dököll
Let's hear it Nikita!

What do you hope to achieve via VB, at least, what sort of calculation are you trying to do?
Well, I am working on the reports module for a project. I am passing parameter/s from VB6 to Access (pardon my language, this is the first time I am working on VB6) and retrieving data grouped by certain fields.
I require sub totals in the Data Report, also I wanted something like a
new column = column A / column B * 100
new column = column A - column B
That’s essentially what I am trying to do. Please let me know if you have any suggestions.

Thanks,
Nikita
  #6  
Old June 2nd, 2007, 01:26 AM
Dököll's Avatar
Moderator
 
Join Date: Nov 2006
Location: Upstate NY - US
Posts: 2,224

re: functions in data report


Quote:
Originally Posted by Nikita0303
Well, I am working on the reports module for a project. I am passing parameter/s from VB6 to Access (pardon my language, this is the first time I am working on VB6) and retrieving data grouped by certain fields.
I require sub totals in the Data Report, also I wanted something like a
new column = column A / column B * 100
new column = column A - column B
That’s essentially what I am trying to do. Please let me know if you have any suggestions.

Thanks,
Nikita
Start here, Nikita:

http://www.thescripts.com/forum/thre...st2488451.html
  #7  
Old June 2nd, 2007, 09:20 AM
Newbie
 
Join Date: May 2007
Location: Mumbai
Posts: 7

re: functions in data report


Quote:
Originally Posted by Dököll
Thanks. This is exactly what I have done.

Can you help me with MSFlex grid. I am able to populate the flexgrid from a table in access. What i now want to achieve is update certain cells in the flex grid and save updated changes to table. is this possible. can u help me with the code.

Thanks,
Nikita
  #8  
Old June 2nd, 2007, 12:18 PM
Dököll's Avatar
Moderator
 
Join Date: Nov 2006
Location: Upstate NY - US
Posts: 2,224

re: functions in data report


Quote:
Originally Posted by Nikita0303
Thanks. This is exactly what I have done.

Can you help me with MSFlex grid. I am able to populate the flexgrid from a table in access. What i now want to achieve is update certain cells in the flex grid and save updated changes to table. is this possible. can u help me with the code.

Thanks,
Nikita
Groovy, I am glad you've gone this far. I think you will find some hits here that'll cater to your needs; did a quick search of this forum using search grid in search terms. Give it a go:

http://www.thescripts.com/forum/sear...3&pp=25&page=1
  #9  
Old June 5th, 2007, 07:49 AM
Newbie
 
Join Date: May 2007
Location: Mumbai
Posts: 7

re: functions in data report


Quote:
Originally Posted by Dököll
Groovy, I am glad you've gone this far. I think you will find some hits here that'll cater to your needs; did a quick search of this forum using search grid in search terms. Give it a go:

http://www.thescripts.com/forum/sear...3&pp=25&page=1
Hi! needed some more help with data reports..I have added dataenvironment to my proj. and added a command to it with the sql query
SELECT A, COUNT(B) AS C, SUM(D) AS E, SUM(F) AS G, SUM(H) AS I
FROM table1
WHERE (K=[?]) and (A=[?])
GROUP BY A;

I have linked a data report to this command. But while passing parameter to the report from a Form I am getting an error "Expected: ="

Private Sub Command1_Click()
DataEnvironment1.Connection1.Open
DataEnvironment1.Command1 (combo1.Text, text1.text)
DataReport7.Show
Unload Me
End Sub

I am able to run reports while passing a single parameter, but not 2.

Thanks,
Nikita
  #10  
Old July 5th, 2009, 01:33 PM
Newbie
 
Join Date: Jul 2009
Posts: 1

re: functions in data report


dear Nikita,

i didn't find any answer for the problem at
http://www.thescripts.com/forum/sear...3&pp=25&page=1



please help me...


i have a problem with calculated object at grouping data report .

exp.

header grouping 1
fields g1 -------------------------> grouping by this field
-----------------------------------------------------------------
field1 field2 field3
-----------------------------------------------------------------
a 5 20 ---------------> detail report
b 7 21
c 8 22
d 4 15
----------------------------------------------------------------
total 24 78 -----------------------footer grouping
calc 78/24 -----------------------footer grouping

how to generate data report with this condition.

i'm sorry for my language..
Reply


Similar Threads
Thread Thread Starter Forum Replies Last Post
Classes: Reading in data? Using constructors? fakeprogress@gmail.com answers 7 May 2nd, 2006 07:47 PM
Data subset in report header MoreQsThanAs answers 1 November 23rd, 2005 07:55 PM
removing last letter in data for a report Karlwasley answers 2 November 12th, 2005 08:32 PM
running functions in parallel on multiple processors Michael Schmitt answers 2 July 18th, 2005 05:46 AM