VB Crystal Report >> Subreport for cross-tab

by Baris Erg » Tue, 02 Sep 2003 21:56:14 GMT

In the cross tab report in each row is a date and the numerical values next
to that date as the coloumns..

A B
01.01.2003 230 750
02.01.2003 890 750
.....

I want to put a subtotal row to show the month totals but I don't know how
to add such a group in a cross tab

A B
01.01.2003 230 750
09.01.2003 230 750
25.01.2003 890 750
JANUARY 1340 2250
06.02.2003 450 230
.....



Similar Threads

1. Inserting a subreport in a crosstab report - VB Crystal Report

2. Executing SQL from Cross Tab Wizard in VBA

Hi -

Any idea why the SQL queries that are created by the Cross Tab Query Wizard 
cannot be ran in VBA?

It starts off with the 'TRANSFORM' statement, as opposed to the usual 
'SELECT' statement
IS this the reason why? Or is it because I have 'PARAMETERS' defined in the 
SQL statement?

How would I ran a Cross Tab query in VBA?

Please Advise

3. cross-tab query for SQL server DB - VB.Net

4. cross-tab query and combine 2 dataGridView

5. Cross tab Crystal Report Problem ( Column Heading) - VB.Net

6. VB code to get data from table like cross tab

I have a sql table with four column named Availability, Performance,
Quality and OEE. I am wanting to make a simple bar graph with each of
the columns having its own bar in the graph. However this is not
exactly the x and y relationship that the .net graph control is
looking for since it wants to see the value and name in separate
columns such as...

COLUMN 1/name         COLUMN 2/value
Availability                              .5
Performance                           .75
Quality                                  .88
OEE                                     .75

Off course if I had the information in a table like above I would have
no problem making the chart since the .net chart control is looking
for this x and y format. However my data is in the table like so...

Column 1/ Availability
.5

Column 2/ Performance
.75

Column 3/ Quality
.88

Column 4/ OEE
  .75

So you see I have to figure out a way to get the chart to read my
table in this format. Do you have any suggestions or examples on how
to get around this. Another program is putting the data into sql this
was so I cannot just change the sql table structure without totally
reprogramming so I have to find away to pull the data out of the table
while in this format.

Your help is much appreciated.

7. Cross-Tab sorting manually in reports

8. How to Format Rows and Columns of Cross-Tab