Page 1 of 1
[Solved] How do I remove the duplicating lines?
Posted: Tue Oct 11, 2016 12:47 pm
by 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?
Re: How do I remove the duplicating lines?
Posted: Wed Oct 12, 2016 1:15 pm
by 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.
Re: How do I remove the duplicating lines?
Posted: Thu Oct 13, 2016 11:10 am
by Ichiorochi
HighAley wrote: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.
Re: [Solved] How do I remove the duplicating lines?
Posted: Thu Oct 13, 2016 11:28 am
by 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.
Re: [Solved] How do I remove the duplicating lines?
Posted: Tue Jan 03, 2017 8:20 am
by 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
Re: [Solved] How do I remove the duplicating lines?
Posted: Wed Jan 04, 2017 6:28 am
by 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.