functions in data report

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

re: functions in data report

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!

re: functions in data report

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

re: functions in data report

Let's hear it Nikita!

What do you hope to achieve via VB, at least, what sort of calculation are you trying to do?

re: functions in data report

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

re: functions in data report

Start here, Nikita:

http://www.thescripts.com/forum/thre...st2488451.html

re: functions in data report

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

re: functions in data report

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

re: functions in data report

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

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..