Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Recursive Table in Crystal Report 8.5

Hi,
 
 Can anyone help to print a report from a recursive table from SQL Server.I have a recursive table in SQL Server.(Id primary key & ParentId foreign key).I want the report to accept any Id from table & it should print all the children of that Id group by.(like a tree view in VB).
0
rkvk
Asked:
rkvk
  • 2
  • 2
1 Solution
 
peter57rCommented:
Hi rkvk,
Use the Heirarchical Grouping option in CR.
Insert a group based on the ID and then use Report>Heirachical Grouping to group by the Parent id.

Pete
0
 
rkvkAuthor Commented:
Hi,

    Sorry its not working.I am passing an Id fto the report , it should bring all its children as a group in the report
0
 
peter57rCommented:
So if you use the report without the hierarchical grouping, do you see a list of the required records?

Pete
0
 
rkvkAuthor Commented:
Hi Pete,

    Its working with heirarichal grouping if I create a temporay table & use it in report.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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