Mulitple details on repost

[ttelesky]

I have a database which we use to track engineering development projects. The project name etc is in one table. There is a table of "comments" on each project and a table of "tasks" for each project. I would like to print a report for each project in the database and list the tasks and comments for each project, each grouped separately. The report supports 1 detail listing, is there a way to list 2?

Thank you

 

[ekim]

If I read your issue correctly it sounds very similar to my post (thread 703-82100). I'll be interested to see what responses you get. Good Luck

 

[deidrahar]

I have the same problem. Did you ever get a resolution to this issue?

Thanks

 

[ekim]

I did not get a resolution from the forum. However I did create a solution on my own. I had a several surveys with as many as 60 questions many with "If not, please comment" kind of thing.

What I wanted was a grouping of all comments for a given question unser that question. The next question might have a yes/no response under which I would show a calculation of what % of total responses weere yes and no and then go on to the next question which might be a calculation or another section of compiled comments.

What I had to do was create sub-reports for each comment response based on a query that filtered for only that response. I put the responses in order of the survey placing the sub-reports in their proper place in the sequence. In one case I had I think 35 subreports.

The trick was that in order for the comments to be compiled, all of the responses had to be placed in the report header. The detail and footers were basically blank sections except for some hidden calculated or reference fields. There is a limit on how long the header can be so in a couple of places I had to break the reports into A and B parts.

Hope this gives you a lead on how to proceed.

 

[Bchemist]

I am not sure if I am understanding this correctly or not. It sound to me like there are serval answers to your problem. First if you need several detail sections the easiest way to accomplish this is to include subreports, linked to the main report. If you link you project info in to the subreport and main report you should be able to produce as many sub detail infos as you need.

Or

I have found that a much fast and more efficient method of doing this is to look over you query to gather your info, and include the project title, on the same line as each task. then make using the sorting option make a header field for the project sort and put the tasks in the detail.

 

[ekim]

It depends on what you want and your data structure. In my case I wanted to compile the results of each response to the yes/no/multiple choice prompt before moving onto the next question. In the case of the comments I wanted to list all non blank responses to a prompt before moving on to the next prompt. When I put my subreports in the detail secion, I got basically a data dump and for some reason it would not filter out the null values. There were other settings to the section properties that I don't want to go into or even remember. Suffice to say it was a lot of trial and error and the only way I got what I was after was putting all response calcs and compiled comments in the header section. I think it forces the database to make a first pass through the data. Anyway it worked.