Solved

URGENT PLEASE -  VB6 with DataReport using Multiples Command ??

Posted on 2004-04-19
13
466 Views
Last Modified: 2013-12-25
Hi !
I'm using couples reports in my software, but one is a big report of situation,
i'm Using in DataEnvironement  a  Command Call
- RappSituation     -   Command
     - RapProb        -   Child Command (Down Level of RappSituation)
     - RapDemand   -   Child Command (Same Level of RapProb)
     - RapEmpCum  -   Child Command (Same Level of RapProb)

When set the Command RappSituation to the Report , VB give me an error like "no supporting multidimensonial report thing...."
BUT IT's VERY Simple , I Want 3 Details Sections in This Report !!!!!!
- So, HOW to Make it in VB with Datareport ???
   OR (if is impossible.....   >:-(            
- HOW can i print 3 section details  (EVen if i have to buy some external report.....)

It's Very Urgent !

Thanks
Eric.
0
Comment
Question by:BeerMan
  • 5
  • 4
13 Comments
 
LVL 18

Expert Comment

by:Sethi
ID: 10864813
In DataReports you can't have three detail sections. In Crsytal Reports and Access reports you can have sub reports that can act like another detail section.
0
 
LVL 18

Expert Comment

by:Sethi
ID: 10864837
These two links may help you to achieve something with Hierarchical DataReports:

http://www.freevbcode.com/ShowCode.asp?ID=6442
http://www.freevbcode.com/ShowCode.Asp?ID=5288
0
 
LVL 1

Author Comment

by:BeerMan
ID: 10885823
Thanks Sethi,

But i want to know if exist an external Report who can accept Multiple Hierachical Detail !?

Eric.
0
 
LVL 18

Expert Comment

by:Sethi
ID: 10885956
Soryy...you new comment is not very clear...please explain again.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 1

Author Comment

by:BeerMan
ID: 10886040
Sethi,

Did have some Report (like Crystal Report for exemple) who i can put three Detail sections in ???

Thanks
Eric.
0
 
LVL 18

Accepted Solution

by:
Sethi earned 500 total points
ID: 10886130
Ok..In crystal reports you can use SubQueries...You can not have three detail sections in Crystal reports also but Sub queries will offset that limitation...Example:
1 detail section displaying data from one table
2 sub queries displaying data from related tables

When the report will run, the data will be displayed in detail section as well as subqueries and it will give an effect of three details section.

In case you have Crystal Reports installed on your PC there are Help PDF files in the Crystal Reports folder that will tell you how to use subqueries.
0
 
LVL 1

Author Comment

by:BeerMan
ID: 11317117
Hi,

Crystal Report i know it and i dont like it, i want any other suggestion programme or any great solution,
but i can't Accept a answer with Crystal Report....  i dont want to use it...never...

Thanks for all suggestion.

Eric.
0
 
LVL 18

Expert Comment

by:Sethi
ID: 11317791
There is no concept of three detail sections in any report I have worked with so far and that answers your question...I gave you an option of Crystal reports and Access reports becuase in these reports you can have sub reports that that in a way would serve your purpose well of having three detail sections.
0
 
LVL 1

Author Comment

by:BeerMan
ID: 11351509
Wow,  What a Answer for 500 points.... wow.

Eric.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now