saitias

I am trying to create a report that we could use to simplify our proposals.
Basically we figure it would be much cleaner to submit a proposal that included every item sans the client description.(it tends to make our proposals 30 pages long when it could be condensed) But we do like our clients to be able to read through what they are getting in detail.

The problem I am having is for the second report. I have gotten our initial report correct sans the Client Descriptions of Items

I am creating this report to Group items by Manufacturer and I have also assigned the Items we want to show regularly with a custom setting in customproperties2 to Appendix. This way I can filter out anything we do not want to show up. Such as simple install parts and such. The problem I then run into is that if we have 20 speakers listed in the project this will print off 20 speaker descriptions, back to what we do want. I want to be able to show these items only once then move on to the next item no matter what the quantity of the item is in the project.

Any suggestions and does this make any sense to any one?

Thanks in advance!
MatthewT

saitias

7 views, no one knows how to do this?

Sorry guys, just a little bit in a hurry. I think it would be really sweet if I could get this done on my next big proposal.

Thanks all
Matthew

RickC

Originally Posted by saitias

I am trying to create a report that we could use to simplify our proposals. Basically we figure it would be much cleaner to submit a proposal that included every item sans the client description.(it tends to make our proposals 30 pages long when it could be condensed) But we do like our clients to be able to read through what they are getting in detail. The problem I am having is for the second report. I have gotten our initial report correct sans the Client Descriptions of Items I am creating this report to Group items by Manufacturer and I have also assigned the Items we want to show regularly with a custom setting in customproperties2 to Appendix. This way I can filter out anything we do not want to show up. Such as simple install parts and such. The problem I then run into is that if we have 20 speakers listed in the project this will print off 20 speaker descriptions, back to what we do want. I want to be able to show these items only once then move on to the next item no matter what the quantity of the item is in the project. Any suggestions and does this make any sense to any one? Thanks in advance! MatthewT

Sounds like you have the fields in the details section of the report. This section prints for every record in the data.

If you have the fields in the group section of the report, make sure the DataField property of the section is set to "dtr:ItemHash" this is the unqiue identifier for each item.

If you have that and you're still getting multiple entries, it's because the data is sorted as such that item instances are not in sequential order. In this case the data for the sub report needs to be resorted on the fly. There is a link with an example for this here:


Here's a thread:
Help with Custom Report and Dynamic grouping

Here's a direct link to the sample file:
http://downloads.d-tools.com/si5/rep...esort_demo.zip

Take a look at these potential reasons and see if one of them are not causing the problem.

-R

saitias

ahhhhhhh. OK. I appreciate the quick reply. You guys are so much smarter than myself! Thanks a bunch