| | |
Problems on making Crystal Report
Please support our VB.NET advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: Aug 2004
Posts: 3
Reputation:
Solved Threads: 0
Hi all,
I want to make a report that the column headers are getting from one of the
field in the dataset.
Example, dataset ds has table A with 4 columns, col1, col2, col3, col4
I would like to use col1 values to be the column headers of the report,
the returned dataset, ds has 4 records, and those values in col1 are
("AB","AC"," AD" and "AE")
so the reports will become
AB AC AD AE (distinct values of Col1 return from ds)
XX XX XX XX
XX XX XX XX
XX XX XX XX
XX XX XX XX
............
So I am thinking to get the distinct values of Col1 from the return dataset,
ds.
But I don't want to do it in the SQL, so how can I do it in the Crystal
Report?
I want to fill the returned data from ds following the headers come from col1
those data will be filled according to the value of col1 in each records,
says.
records 1 {AB, 123, ..., ...}
records 2 {AD, 999,...,...
the reports become,
AB AC AD AE
123
999
Or is there any other Good ideas to do it??
Thanks ~
Miyakejess :-|
I want to make a report that the column headers are getting from one of the
field in the dataset.
Example, dataset ds has table A with 4 columns, col1, col2, col3, col4
I would like to use col1 values to be the column headers of the report,
the returned dataset, ds has 4 records, and those values in col1 are
("AB","AC"," AD" and "AE")
so the reports will become
AB AC AD AE (distinct values of Col1 return from ds)
XX XX XX XX
XX XX XX XX
XX XX XX XX
XX XX XX XX
............
So I am thinking to get the distinct values of Col1 from the return dataset,
ds.
But I don't want to do it in the SQL, so how can I do it in the Crystal
Report?
I want to fill the returned data from ds following the headers come from col1
those data will be filled according to the value of col1 in each records,
says.
records 1 {AB, 123, ..., ...}
records 2 {AD, 999,...,...
the reports become,
AB AC AD AE
123
999
Or is there any other Good ideas to do it??
Thanks ~
Miyakejess :-|
Jess Miyake
![]() |
Similar Threads
- Crystal report in vb.net, printing problems (VB.NET)
- Crystal Report Exception Error when Viewing (Visual Basic 4 / 5 / 6)
- Crystal report (Visual Basic 4 / 5 / 6)
- problem connection vb6 & crystal report 11 (Visual Basic 4 / 5 / 6)
- How to include Access and Crystal Report in Setup file (Visual Basic 4 / 5 / 6)
- crystal report related.........simple one......Please take 2 min to read this... (VB.NET)
- Crystal report problems (ASP.NET)
Other Threads in the VB.NET Forum
- Previous Thread: Expert in Class Creation & Implementation Needed
- Next Thread: VB.Net experts: I need some help
| Thread Tools | Search this Thread |
.net .net2008 2008 access account add advanced application array basic beginner browser button buttons click code combo cpu cuesent data database datagrid datagridview date datetimepicker designer dissertation dissertations dissertationtopic employees excel exists fade filter forms generatetags html images input intel internet listview mobile module monitor mysql net number objects open panel pdf picturebox picturebox2 port position print printing printpreview problem regex reuse right-to-left save search searchvb.net select serial settings shutdown socket sqldatbase sqlserver storedprocedure survey temperature textbox timer timespan transparency txttoxmlconverter update user usercontol vb vb.net vb.netformclosing()eventpictureboxmessagebox vba vbnet vista visual visualbasic.net visualstudio.net visualstudio2008 web winforms wpf wrapingcode xml year





