Crystal Reports Mahesh Chand's article discussion

Hi, I'm trying to start a thread about Mahesh Chand's article and Crystal Reports in general. Firstly I'd like to thank the author for covering what seems to be a very seldom discussed topic. I have a little problem if anyone is interested. I'm creating a report using an ADO.net dataset that I filled manually from a few different sources. My dataset has several tables, so I'm using groups in my Crystal Report to represent the child relations in the table , so there is a "report"(not a new report object, just a different heading in the same viewer) for every row in my first Table(I'll refer to it as ErrorReports), then several pages for each row in it's child Table(referred to as Report). This works fine but after this I run into problems as the Report Table has more than one child relation, so what I want to do is have all the data from one child Table written out then on a new page all the data from the next child Table. I can't make a group for each because the groups must keep thier structure such that any new group is contained in the by the last newest group(I'm not really sure how to explain this, the "smallest", "most specific") so that no group can contain 2 unrelated groups, they must contain one group that may contain a group itself. So I hope someone understands what I mean there. Anyway I have considered using a subreport but it seems to really slow things down, I've tried to split the groups into sections but this seems to really do nothing, when it fill the data it just puts the sections together as if they were one, and since the 2 child Tables contain different amounts of rows it really can't work this way. Any other suggestions would be greatly appreciated, I can never find any info about reports using "complicated" Relations like mine.

Well it turns out that when trying to use a Table with multiple child tables that subreports are the ticket(Working slower is better than not at all, my big perfomance hit from befor I think was because of multiple datasources). So After 1 child relation a subreport must be created for each additional child relation, and they only go 1 level deep. Also suppressing an empty sub report seems to be extremely ugly. The solution I have is to hide a copy of the subreport by setting it's height to 0 and in that report checking for any data, then using a boolean set by that check to decide whether or not to show the "real" subreport. my e-mail is [email protected] if you'd like to hear it so it makes sense. Anyway, any further comments will be appreciated as I'll try to keep on eye on this thread. Good Luck.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

dudesjunk22y ago
Well it turns out that when trying to use a Table with multiple child tables that subreports are the ticket(Working slower is better than not at all, my big perfomance hit from befor I think was because of multiple datasources). So After 1 child relation a subreport must be created for each additional child relation, and they only go 1 level deep. Also suppressing an empty sub report seems to be extremely ugly. The solution I have is to hide a copy of the subreport by setting it's height to 0 and in that report checking for any data, then using a boolean set by that check to decide whether or not to show the "real" subreport. my e-mail is [email protected] if you'd like to hear it so it makes sense. Anyway, any further comments will be appreciated as I'll try to keep on eye on this thread. Good Luck.
0