Last post Mar 14, 2017 10:31 AM by nitinsontakke
Feb 13, 2017 03:31 PM|highrise955|LINK
I have a table called Materials (SQL Server 2012). In that table there is a field called PartNo and one called SubPartNo. If a SubPartNo has its own SubPartNo then it will be listed further down the table. For example, PartNo 555-123 has a SubPartNo of 111-222.
Part 111-222 also has its own sub parts so 111-222 is listed in the PartNo column. This will continue until all the sub parts have been listed.
I need the report to look like this...
Basically, while compiling the report I need Crystal Reports to...
I can figure out how to indent the records but I can't figure out how to get Crystal Reports to follow the logic while its compiling the report.
Any help would be greatly appreciated.
Mar 14, 2017 10:31 AM|nitinsontakke|LINK
I have virtually no knowledge of Crystal reports, while I have briefly worked on SSRS. What I don't understand is, why not do all this juggling at back-end itself? Is it SQL Server?
Furthermore, what if indentation grows beyond 2 level? Is that not possible ever?