473,287 Members | 1,800 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,287 software developers and data experts.

Dynamically sized tabular display

ASP.NET
SQL Server 2k

Our clients need to output a pretty complicated Consignment/Delivery
Note from their system. It is in tabular form, but each row can have
a) a different number of columns, and b) cells of varying width and
height. I can mimic this in both Word and Access, and using either
Access' reporting functions or Word's mailmerge, can output a report
as I require.

However, it is unfeasible to automate either Word or Access from
ASP.NET, and I wondered if anyone had any ideas about how to approach
this in Crystal Reports. Here is a very rough idea of what is needed.

|---------------------------------------------------------------|
| Delivery Number | Copy Number | Bar code |
| ABC123 | 1 | ||| | | || ||| | | | |
|---------------------------------------------------------------|
| Consignor | Stock Number | Part Number |
| Joe Bloggs & Co. | 1234 | 5678969-00-97 |
| 1 Acacia Avenue |----------------------------------------|
| Happytown | Description |
| Loamshire | FORK END ASSEMBLY |
|---------------------------------------------------------------|
| etc. |
A certain amount has to fit on page 1. Pages 2..n contain child data
- for example, a list of Cases and Case number, each of which can
contain 1..n sub-assembly numbers.

Fun eh?

Anyone got any ideas? I really don't want to use GDI for this!

TIA

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk
Nov 20 '05 #1
1 986
Edward,
I haven't worked with Crystal, but I have used a lot of ActiveReports by
DataDynamics. Look up www.DataDynamics.com and look at the ActiveReports
for .Net... they have trial versions to download. One of the great things
for you is that you can import MS Access report definitions (some tweaking
needed) so if you can do your report in Access, you should be able to easily
do it in AR... and they have a lot of sample code!
hope this helps!
wardeaux
"Edward" <te********@hotmail.com> wrote in message
news:25**************************@posting.google.c om...
ASP.NET
SQL Server 2k

Our clients need to output a pretty complicated Consignment/Delivery
Note from their system. It is in tabular form, but each row can have
a) a different number of columns, and b) cells of varying width and
height. I can mimic this in both Word and Access, and using either
Access' reporting functions or Word's mailmerge, can output a report
as I require.

However, it is unfeasible to automate either Word or Access from
ASP.NET, and I wondered if anyone had any ideas about how to approach
this in Crystal Reports. Here is a very rough idea of what is needed.

|---------------------------------------------------------------|
| Delivery Number | Copy Number | Bar code |
| ABC123 | 1 | ||| | | || ||| | | | |
|---------------------------------------------------------------|
| Consignor | Stock Number | Part Number |
| Joe Bloggs & Co. | 1234 | 5678969-00-97 |
| 1 Acacia Avenue |----------------------------------------|
| Happytown | Description |
| Loamshire | FORK END ASSEMBLY |
|---------------------------------------------------------------|
| etc. |
A certain amount has to fit on page 1. Pages 2..n contain child data
- for example, a list of Cases and Case number, each of which can
contain 1..n sub-assembly numbers.

Fun eh?

Anyone got any ideas? I really don't want to use GDI for this!

TIA

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk

Nov 20 '05 #2

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

Similar topics

2
by: Joe Smith | last post by:
Hi, I'm using the code below to change the contents of a cell table in IE. The problem is that the cell size won't adjust to the size of the content, as its positions have been declared 'absolute'....
0
by: Olli Krollmann | last post by:
hello folks, we have been developing several .NET-based windows forms applications during the last two years. there are two mysterious display problems that we have encountered so far but have...
5
by: Carlos | last post by:
Hi all, I am from the C++ world, and just making baby steps into C#. Just wanted to ask you about the best way to create a dynamically sized array, and maintain it effectively (yeah, I know...
1
by: Edward | last post by:
ASP.NET SQL Server 2k Our clients need to output a pretty complicated Consignment/Delivery Note from their system. It is in tabular form, but each row can have a) a different number of...
2
by: t | last post by:
Hi, I have the following problem. The web-based software I am to create is going to display tabular data. Lots of data so I need some pagging mechanism. I thought about creating three classes:...
3
by: maylee21 | last post by:
hi, anyone can help me figure out how to read data from a text file like this: 10980012907200228082002 and extract the data according to this kind of format: Record type 1 TY-RECORD ...
38
by: Sanders Kaufman | last post by:
I'm converting my table-based layouts to css-positioned divs - but the ONLY reason I'm doing it is because it's *considered* a best practice. I don't really see where anything goes hinky when...
5
by: Lars Eighner | last post by:
Is a calendar tabular data, logically meriting table markup? -- Lars Eighner <http://larseighner.com/ <http://myspace.com/larseighner> Countdown: 465 days to go. What do you do when...
0
by: Mrityunjay Kumar Gaurav | last post by:
I'm making a HIS software using VB.Net and Oracle at the back end. I am facing a problem in creating a tabular report in Crystal Reports. The details is as follows: The table structure is as...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

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.