Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 513
  • Last Modified:

URGENT PLEASE - VB6 with DataReport using Multiples Command ??

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
BeerMan
Asked:
BeerMan
  • 5
  • 4
1 Solution
 
SethiCommented:
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
 
SethiCommented:
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
 
BeerManAuthor Commented:
Thanks Sethi,

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

Eric.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
SethiCommented:
Soryy...you new comment is not very clear...please explain again.
0
 
BeerManAuthor Commented:
Sethi,

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

Thanks
Eric.
0
 
SethiCommented:
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
 
BeerManAuthor Commented:
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
 
SethiCommented:
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
 
BeerManAuthor Commented:
Wow,  What a Answer for 500 points.... wow.

Eric.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now