Messages »

1

Discussion | Обсуждение / Re: Footer only get first row from table widget

« on: September 18, 2018, 04:56:00 AM »

Hi, Ann.

Can you provide me a sample of database and exact description what result you want ?

Exact means "Step by step". What data in each place (band) your wanna see

Hi Subst, I try to explain at my best.

I have 2 tablewidget, one is the data(Table A) and the other one is the summary of the data(Table B).

Table A will arrange the data by date, so once the date is different, it will close with a footer and open a new header for the next date. At the same time, I need Table B first row of data to be display at the group footer.

Attached is my desired output.

2

Discussion | Обсуждение / Re: Footer only get first row from table widget

« on: September 12, 2018, 01:39:38 PM »

Sorry for the late reply.

can you provide example of in form sketch or table on how you want it to be for easy understanding? I believe Lime Report Designer has facilities to solve your problem.

I will try to draft it soon to make everything clear.

Ann, try to use data header & data footer instead group header & group footer first.

Then If u are using LR from your application You can create the instance of LimeReport::ICallbackDatasource* for and control the navigation throw the table in your QT code.

Or you can use the master-detail relation between main data and footer data in LR.

Data header and data footer does not work. Will try your other suggestion soon.


If still could not manage to get it, will give up on that kind of display method.
Thanks guys.

3

Discussion | Обсуждение / Re: Footer only get first row from table widget

« on: September 07, 2018, 06:36:52 AM »

ann, in this case U just need to add another databand and define second table for it as datasource.

Or it's strongly necessary to use the groopfooter band?

Thanks for the suggestion but it does not work. It will print all my databand1 first then just print databand2. I need the databand2 start printing only a row when the groupheader condition meet, and then start print the next row when the next groupheader condition meet and so on.

I sent another attachment, the arrow part need to be update on every different date.

Is it possible for me to access directly to the table in limereport GUI template? I tried $D{staff_hour.w_days[0]}, $D{staff_hour.w_days(0)}, $D{staff_hour.w_days.[0]}, $D{staff_hour.w_days.(0)} but it does not work. I am thinking to directly access into table and assign the row manually into group footer.

Sorry for the long essay and advance thanks for your help.

4

Discussion | Обсуждение / Re: Footer only get first row from table widget

« on: September 05, 2018, 10:07:33 AM »

Well, The footer band isn't for working with set of data 'row-by-row'. It's for some summary data from table. For example average of values in column and so on.

Let me see your lrxml file?

I see. I did the summary in a table and I just wanted to load the summary from the table. The footer table and databand table is different table.
Sure, attached is the lrxml file.

Thanks 

5

Discussion | Обсуждение / Re: Footer only get first row from table widget

« on: September 04, 2018, 04:47:41 AM »

As I see you've forgot to assign datasource to the dataBand

I did assign datasource to databand. The databand works well but footer not.

6

Discussion | Обсуждение / Footer only get first row from table widget

« on: September 03, 2018, 09:40:44 AM »

I am getting data from table widget into GroupBandFooter. However, all the footer keep on getting data from first row. I am tough that the footer will continue append data from the next row of table widget.

Is it possible to get data from second row of data for the second footer and so on?
Is it possible to direct access into a table and get specific row or column of data?

Attached is the template design and the arrow-ed footer always get data from first row of my table widget.

Thanks in advance.

7

Discussion | Обсуждение / Re: Set bold

« on: May 21, 2018, 04:36:57 AM »

My solution is more universal
If you write THIS.font=QFont("Arial",12,false,true); it will always Arial,12 independently from TextItem font settings.
But you can use both methods as you wish

I see. Currently I do not need a versatile build yet. But still thank you for the suggestion, might use it next time.

8

Discussion | Обсуждение / Re: Set bold

« on: May 16, 2018, 01:05:51 PM »

Hi Arin Alex, thanks for the suggestion. Does the script perform better? Or else I will stick to current code because script seems like complex to me   

9

Discussion | Обсуждение / Re: Set bold

« on: May 16, 2018, 12:09:46 PM »

Hey Subst, you save my day  the solution work. Thank you very much.

10

Discussion | Обсуждение / Set bold

« on: May 16, 2018, 09:41:38 AM »

Hi all. I am trying to set the font to bold through text item editor. Below is the sample code to set the text color

if($D{tablewidget.intimestatus}==2 && getVariable("colourFlag") == 0){
THIS.fontColor=QColor('green');
}

So is there any code to set the text to bold?. Thanks in advance.

11

Discussion | Обсуждение / Re: if condition from datasource

« on: December 21, 2017, 06:30:48 AM »

Thanks for the reply, but I don't think the name(tablewidget) is an issue.
However, my problem solve. not sure what is the issue. but the following code works.

$D{tablewidget.In}
$D{detail.nextLine}
$S{
if($D{tablewidget.In} == "") {
THIS.fontColor=QColor('white')
setVariable("colourFlag","1");
}
else{
setVariable("colourFlag","0")
}
}

$S{if($D{tablewidget.InStatus}==2 && getVariable("colourFlag") == 0)
THIS.fontColor=QColor('green')
else if($D{tablewidget.InStatus}==3 && getVariable("colourFlag") == 0)
THIS.fontColor=QColor('red')
else if(getVariable("colourFlag") == 0)
THIS.fontColor=QColor('black')
}

12

Discussion | Обсуждение / if condition from datasource

« on: December 20, 2017, 06:06:27 AM »

Hi.
I would like to make condition from tablewidget from datasource.
I tried this coding but it did not work
$S{if($D{tablewidget.InStatus}=="2" {$D{tablewidget.In}}}

Besides that, can I change the color of table column in the condition too?

Thanks in advance.

13

Discussion | Обсуждение / Re: setting for startNewPage using qt C++ code

« on: November 30, 2017, 11:20:46 AM »

Problem solve by doing 2 template and switch selection in QT.

14

Discussion | Обсуждение / setting for startNewPage using qt C++ code

« on: November 28, 2017, 07:35:11 AM »

Good day everyone. I encounter an issue where I am unable to set the check status of startNewPage for specific reportband using QT coding (C++). Is there anyway to do so? Advance thanks.

15

Discussion | Обсуждение / Re: Unable to hide template column

« on: September 24, 2017, 02:49:47 PM »

Wow!! Thank you and that is what I need !! appreciate your help. Thank you very much !!