Skip to Content
author's profile photo Former Member
Former Member

Can we place two command objects fields in one section ?

Hi Everyone,

I have a report contains 2 command objects.As per my requirement i need to place those 2 command objects fields in one detail section.

But there is no link between those 2 command objects.Those two queries from different tables. If i placed those 2 queries fields in one details section i am getting wrong results.Can any one please tell me what i have to do in this situation.Any solution would be greatly appreciated

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Feb 26, 2013 at 09:33 AM

    Hi Vissu,

    If you have unlinked commands/tables in your report and if you include records from both the command objects/tables, you're ought to get inflated results. This is also known as 'Cross-join'.

    Is there a reason why you want fields from both the tables side-by-side?

    1) Either create one single command object by joining the two tables OR

    2) Add the 2nd command object in the Subreport and place this Subreport on the Report Header. Then go to the Section Expert > Report Header and check "Underlay Following sections".


    Add a comment
    10|10000 characters needed characters exceeded

    • that's really up to you as to which method that you want to pursue. subreports would most likely be easier than trying to get everything on the main report using one query or a combination of queries.

      link each subreport on the time prompts / parameters which should be included in each query.

      if you haven't built a subreport before, i would advise you to go to the online help in crystal reports and look up "subreport linking". there will be many different topics there that will help you.

      the basic idea though is to base your current report on the main / largest query. each subreport will then be based on a different data set. now go to the Insert menu, choose Subreport, and then you'll choose a connection. choose the next query that you want to deal with. there is a Links tab that you will use to match up the date prompts between the main report and the subreport.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.