473,438 Members | 1,741 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,438 software developers and data experts.

The grid as a reportwriter

Hi,

I've planned an app where there's a lot of columns in a table and because of
that I'd like to split up the columns when presenting them in a datagrid.

I'll give you an example. It's always one year between every row

row _type descr amount remAmount rate interest accruedInterest
1 1 Claim1 100000 100000 10 10000 10000
2 1 Claim2 100000 200000 10 20000 30000
row _type descr amount remAmount myRemPart taxRemPart accrInt myAccPart
3 2 Paym1 -200000 30000 119000 51000 0
21000
row _type descr amount remAmount rate interest accruedInt
4 1 Claim3 100000 130000 10 13000 ......

As you can see both claims and payments are in the same table (grid) with
different headers. And in row 3 you can see that total amount is first taken
from accruedinterest and then from remainderamount columns.

I'd like to have both claims( demands ) and payments to show up in the same
grid, so to speak.

Any ideas?

TIA

Kenneth P
Nov 19 '05 #1
3 1296
Hi Kenneth,

You can apply crystal reports to create and show
complicated report.

Elton Wang
el********@hotmail.com
-----Original Message-----
Hi,

I've planned an app where there's a lot of columns in a table and because ofthat I'd like to split up the columns when presenting them in a datagrid.
I'll give you an example. It's always one year between every row
row _type descr amount remAmount rate interest accruedInterest 1 1 Claim1 100000 100000 10 10000 10000 2 1 Claim2 100000 200000 10 20000 30000row _type descr amount remAmount myRemPart taxRemPart accrInt myAccPart 3 2 Paym1 -200000 30000 119000 51000 0 21000
row _type descr amount remAmount rate interest accruedInt 4 1 Claim3 100000 130000 10 13000 ......
As you can see both claims and payments are in the same table (grid) withdifferent headers. And in row 3 you can see that total amount is first takenfrom accruedinterest and then from remainderamount columns.
I'd like to have both claims( demands ) and payments to show up in the samegrid, so to speak.

Any ideas?

TIA

Kenneth P
.

Nov 19 '05 #2
Hi Elton,

I know about reports and CR.

They don't apply here in the first place. I need a report to the screen,
most preferable in a grid, perhaps as a drill down gridreport. When that's
ok, I'll go for the report on paper.

Any ideas?

Kenneth P

"Elton Wang" wrote:
Hi Kenneth,

You can apply crystal reports to create and show
complicated report.

Elton Wang
el********@hotmail.com
-----Original Message-----
Hi,

I've planned an app where there's a lot of columns in a

table and because of
that I'd like to split up the columns when presenting

them in a datagrid.

I'll give you an example. It's always one year between

every row

row _type descr amount remAmount rate interest

accruedInterest
1 1 Claim1 100000 100000 10 10000

10000
2 1 Claim2 100000 200000 10 20000

30000
row _type descr amount remAmount myRemPart

taxRemPart accrInt myAccPart
3 2 Paym1 -200000 30000 119000

51000 0
21000
row _type descr amount remAmount rate interest

accruedInt
4 1 Claim3 100000 130000 10

13000 ......

As you can see both claims and payments are in the same

table (grid) with
different headers. And in row 3 you can see that total

amount is first taken
from accruedinterest and then from remainderamount

columns.

I'd like to have both claims( demands ) and payments to

show up in the same
grid, so to speak.

Any ideas?

TIA

Kenneth P
.

Nov 19 '05 #3
I'm not really clear on exactly what you want to do but here's a couple of
ideas...

First, look at how an ASP.NET DataGrid is actually rendered. It's nothing
more than an HTML table where each <TR> contains data from one row in the
DataGrid's data source and each individual item in that row is rendered as a
<TD> within a given <TR>. You can dress that up quite a bit by using item
templates but that rendering scheme still locks you into a set of <TR> tags,
one for each row of data.

DataLists and DataRepeaters both provide more flexibility. Yet, things work
very
similarly in the sense that they are multiple-value databound controls...so
whatever is rendered is rendered n times, depending on how many row of data
are present in the data source.

The example you gave suggests a Data List. In a DataList, you can put item
values into separate <TR>s, even when they are in the same row of data. This
is because the <TR> and <TD> tags are explicitly coded in the .aspx file;
they are not impied as in the case of a DataGrid. Things are, by default,
still rendered in a <TABLE>.

A DataRepeater is even more chaotic. No tabluar form is implied, it just
pretty much just spits out the .aspx code as is, except that repitition
is still impled and data binding still occurs. Your mention of a drilldown
grid
makes me think you might need a repeater that has one or more of user
controls embedded in it. As the user clicks various options within the user
controls, the display is changed - possibly by client-side scripts that open
new windows, make things visible or not visible...or whatever you need it to
do.

MSDN has more information but honestly, you may want to look elsewhere. I
never found the MSDN info. on DataGrids, DataLiasts, and DataRepeaters to be
especially helpful.

Good Luck.

"Kenneth P" wrote:
Hi Elton,

I know about reports and CR.

They don't apply here in the first place. I need a report to the screen,
most preferable in a grid, perhaps as a drill down gridreport. When that's
ok, I'll go for the report on paper.

Any ideas?

Kenneth P

"Elton Wang" wrote:
Hi Kenneth,

You can apply crystal reports to create and show
complicated report.

Elton Wang
el********@hotmail.com
-----Original Message-----
Hi,

I've planned an app where there's a lot of columns in a

table and because of
that I'd like to split up the columns when presenting

them in a datagrid.

I'll give you an example. It's always one year between

every row

row _type descr amount remAmount rate interest

accruedInterest
1 1 Claim1 100000 100000 10 10000

10000
2 1 Claim2 100000 200000 10 20000

30000
row _type descr amount remAmount myRemPart

taxRemPart accrInt myAccPart
3 2 Paym1 -200000 30000 119000

51000 0
21000
row _type descr amount remAmount rate interest

accruedInt
4 1 Claim3 100000 130000 10

13000 ......

As you can see both claims and payments are in the same

table (grid) with
different headers. And in row 3 you can see that total

amount is first taken
from accruedinterest and then from remainderamount

columns.

I'd like to have both claims( demands ) and payments to

show up in the same
grid, so to speak.

Any ideas?

TIA

Kenneth P
.

Nov 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

117
by: phil-news-nospam | last post by:
Is there really any advantage to using DIV elements with float style properies, vs. the old method of TABLE and TR and TD? I'm finding that by using DIV, it still involves the same number of...
3
by: kaczmar2 | last post by:
Hey there, I have a large image in a browser window, and I would like a way to overlay grid lines on top of the image, so a user can show the grid or hide the grid lines. The grid would cover...
0
by: BH | last post by:
Hi, I am trying to build my own IHM with two treeCtrl and 1 grid, based on the wx.aui demos. My problem is with the Grid. It dosen't have scrollbars. I tried many methods (fit) but it always...
6
by: Romulo NF | last post by:
Greetings again to everyone, Im back to show this grid componenet i´ve developed. With this grid you can show the data like a normal table, remove the rows that you need, add rows, import data,...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.