Creating reports and dashboards | Stimulsoft community forum

Niqu wrote:I want have page number on page when number of page is greater than 1. I tried using system variables, but all failed. I used conditions like "TotalPageCount == 1", "TotalPageCount > 1", "IsFirstPage == IsLastPage", "IsFirstPage == true && IsLastPage == true" - when i was displaying values of this variables, they were correct, but conditions didn't work. I add attachment to show it. Maybe i am doing something wrong - on 90% i am doing something wrong, becouse it should work, but i am not sure what unfortunately.

Niqu wrote:I have three data source with the same business obcjet and they display similar field, but in different place of report and the data i want to display in each data source is different. I have field name "Type" (it is int) and when the value of this field is 0 i want to display it in first data source, if the value is 1 i want to display it in second data source, etc. I tried using filter, but it didn't work, becouse all data sources take the last added filter, not their own filter. So i used conditions on all fields and it work as i wanted (but still don't know why filters didn't work). And now i also want to display line in each data source starting from 1. I was trying using system variables Line and LineThrough and GroupLine, but it never work fine.

Aleksey Andreyanov wrote: Please, try to set the Print On property.

Niqu wrote:Sorry, but i am a bit confuse now. Can you explain a bit more?
I have set Print On property to All Pages, becouse i want to print it on all pages if TotalPageCount is greater than 1, and i don't want to print it on any pages if TotalPageCount is equal 1.
I open new report with only one page (so TotalPageCount was equal 1 - i display it to check) and did two if:
1. {IIF(TotalPageCount == 1,
"It work",
"It do not work")}
2. {IIF(ToWords(TotalPageCount) == "1",
"It work",
"It do not work")}
both return "It do not work".

Niqu wrote:About the second problem i will try to make report with some data and i will send it to you.

Edit:
I add attachments to simply project, if it is not a problem.
This report is similar to my report, so i think fixing it also will fix problems in my report. Propobly i did something wrong, but at the moment i dont have any idea how to do it correct.
In business object is 12 rows. 4 rows has type 0, 4 rows has type 1, 4 rows has type 2. Each row with different type are in different data source. I think first data source work fine, but rest no much - as you can see i put data in Conditions (when i put filter "Users.Type == 1" and "Users.Type == 2" on this data source, both show me data with type 2). It propobly is the reason why Line do not show in case of 1,2,3,4 dispaly 2,5,8,11 and 3,6,9,12.
I hope you will understand what i want to achive.

Aleksey Andreyanov wrote: You sample report is rendered right. I set the condition on the each text component but it better to set it on the band. The Line variable shows the current band number and it shows right value because other bands are shrunk.

Niqu wrote:Oh, I know it is rendered right. Your program work very good I just do not know how to do some things and it is the reason why i am asking.
I understand what you're saying, but it does not solve my problem. I want to show the number of each display row (except those not displayed), as it is done in the first data source where I used a filter. The use of the conditions is not entirely good, because as you said variable Line is also increased by the not displayed lines - the result is that instead of numbers 1,2,3, ... I got 2,5,8, ... (or something similar). So is it possible to get what i want by changing something or do something otherwise?


Edit: When I set the Number of Pass property of the report to Double Pass, it works as i wanted. Thank you for help.

Users.OwnerBand = DataBand1;