Solved

URGENT PLEASE -  VB6 with DataReport using Multiples Command ??

Posted on 2004-04-19
13
455 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Soryy...you new comment is not very clear...please explain again.
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 1

Author Comment

by:BeerMan
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Wow,  What a Answer for 500 points.... wow.

Eric.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
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…
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…
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…

743 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