Solved

URGENT PLEASE -  VB6 with DataReport using Multiples Command ??

Posted on 2004-04-19
13
475 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
ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

 
LVL 18

Expert Comment

by:Sethi
ID: 10885956
Soryy...you new comment is not very clear...please explain again.
0
 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
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 utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

809 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