Solved

URGENT PLEASE -  VB6 with DataReport using Multiples Command ??

Posted on 2004-04-19
13
490 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: 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!

 
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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

752 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