[Solved] How do I remove the duplicating lines?

[Ichiorochi]

So I am currently working on reworking a report so that the report can show the quantity that has been ordered per day. It used to show the order ID and quantity of each order per line.

As it can be seen in the picture below i got it calculate the total quantity of each product per day. My problem is that it keeps duplicating the summed up quantity as if it is still going through it on an order per order basis.



The way I see it I could solve this in both sql and hopefully the Stimulsoft designer. So I was wondering if anyone out there who knows stimulsoft better than me(trust me it does not take much) could maybe give a few tips?

[HighAley]

Hello.

We need to see your report template with sample data to give you exact answer.
It seems that you should move the text component to the band with data and set the height of the data band to 0.

Thank you.

[Ichiorochi]

Hello.

We need to see your report template with sample data to give you exact answer.
It seems that you should move the text component to the band with data and set the height of the data band to 0.

Thank you.

Don't worry i Have managed to solve it myself. The problem with the duplicated text was because the databand still went through all the rows(of which the order number was the primary ID) so I emptied out the Databand and instead had the date and quantity displayed in the groupheaderband instead.

[Andrew]

Hello,

Thank you for letting us know about this and thank you for sharing your way of solving the issue.

Do not hesitate to contact us when you have additional questions.
Thank you.

[mrinal]

sir,i want to how cn i apply this iif condition.
suppose my report have ..applicant name ,co-applicant name,2nd co-applicant name .....i want to print all of this in a one line.an if any one is missing .i dnt want to show "," in this place..
how cn i do this

[Alex K.]

Hello,

You can use the following expression:

Code: Select all

{IIF(applicant == "", "", applicant + ", ")}{IIF(co-applicant == "", "", co-applicant + ", ")}{IIF(2ndco-applicant == "", "", 2ndco-applicant)}

Thank you.