473,511 Members | 14,134 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

get header-detail and include summarized in detail [vb6 & DataReport]

1 New Member
hello friends,

I'm a little problem and would like to know if you could help me with one hand.

I am making an application in vb6 with questions DataReport $$$.

Now I have to print some slips yet must show a short summary of the last approved invoices made to the customer by way of information.

I have my consultation with shape (somewhat simplified because it is quite extensive)

Expand|Select|Wrap|Line Numbers
  1. EjecutarShape rstReport, "SHAPE {SELECT id_albaran, nroAlbaran approved, Total tbl_albaran FROM ORDER BY 1 DESC} header as" & _
  2.                          "APPEND ({SELECT id_detalle_albaran, concept, cost, id_clienteFK, id_albaranFK FROM tbl_albaran_detalle} as detail" & _
  3.                          "RELATE TO id_albaran id_albaranFK) retail as"
with this query I get very goods shipments to all clients I have. But now I want to include in the delivery note as he had mentioned above, a summary as a subquery which the DataReport does not allow me no longer working with subreports. I can not make a second detail.

the query to get the summary would be using TOP 3

Expand|Select|Wrap|Line Numbers
  1. SELECT TOP 3 id_albaran, nroAlbaran approved, Total tbl_albaran FROM ORDER BY 1 DESC
but I can not include it as mentioned above, try to add a label and display the result in that control section that intend to use the detail but it is not.

I need to do something rather like:



any ideas or suggestions are welcome.

thank you very much for your patience.
Jan 28 '15 #1
0 981

Sign in to post your reply or Sign up for a free account.

Similar topics

1
1865
by: Martin Double | last post by:
Does anyone know if there are problems associated with installing a VB6 on a Win 2000 Pro platform? The Package I have was created using the standard packaging feature of VB6 on a Win ME...
24
3008
by: dotnetforfood | last post by:
Joel Spolsky's new article "How Microsoft Lost the API War" at http://www.joelonsoftware.com/articles/APIWar.html describes how .NET has failed, how classic VB6 and ASP continue to be preferred by...
5
2656
by: Eric Fortin | last post by:
I'm trying to create a classlibrary in VB.net and call it from VB6. I can't figure it out. I created a .net project Created a proc DoSomething Sub DoSOmething() msgbox ("You did...
0
1191
by: Devang | last post by:
Hi everone, I am a beginner of VB. Now i am in last year of BCA course and i have prepared project using VB6 & MS Access. but now if i want to convert this database to Sql, what will be the...
1
1944
by: jainmcs | last post by:
i am using sqlserver2000, now i need a vbdatareport based on between two different date which ever user entered from the vb form,give me some sample source.
0
1606
by: Tim Marshall | last post by:
Access 2003. A report of mine was hanging on print preview. It turned out the issue was a bound text box where the data was too big to fit all on one page. When I changed the "keep together"...
3
1178
by: Dave Siegel | last post by:
Hey, Im interested in starting to use vb6 & mysql. Is there a way to do this? Help is much appreciated.
1
1599
by: lpeens | last post by:
I am currently doing a project in VB6 and we are using sourcesafe. In .Net you are forced to check out a document before working on it, but I see in VB6 you can just start working on it without...
2
1604
by: mickofgoju | last post by:
I am using VB 6 and Crystal report v10. I have a field that is the type of training session a student does, i.e. "Beach Training". I want to retrieve all the sessions from a given date i.e....
1
1453
by: mohd swaleh | last post by:
my shabpe String is given below but it is not working sqlw = "SHAPE {SELECT * FROM labour_main}" _ & " AS RsMain APPEND ({SELECT * FROM labour_child1}" _ & " AS RsFamily...
0
7237
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
7349
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,...
1
7074
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
5659
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5063
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
3219
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...
0
3210
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1572
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
445
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.