Home > database >  100 - data window statement, how to realize the display similar to EXCEL the function of the cell in
100 - data window statement, how to realize the display similar to EXCEL the function of the cell in

Time:09-16

Now you need to generate a statistics, there are a few columns show need to merge cells,
Excuse me, how to achieve in data window, similar to the EXCEL merge cells showed that thank you,

Couldn't come up with an image upload, can put a link,
http://img.blog.csdn.net/20140723171926218

CodePudding user response:

CodePudding user response:

CodePudding user response:

Only with freeform surface, can be used to suppress Repeating values have this effect,
Or you change the idea, use the show line and bar to achieve the effect you want, did something similar, but it requires the SQL and format

CodePudding user response:

refer to the original poster jxpanda response:
now need to generate a statistics, there are a few columns show need to merge cells,
Excuse me, how to achieve in data window, similar to the EXCEL merge cells showed that thank you,

Couldn't come up with an image upload, can put a link,
http://img.blog.csdn.net/20140723171926218


1. Can be achieved by controlling the column, according to whether the purpose of the merged cell, such as A column, written expression in A visible, if (getrow ()=1, 0, 1) to control the display, such as

2. Can suppress Repeating values compressed duplicate values

CodePudding user response:

Effect of inferior to merge cells function in excel

CodePudding user response:

The
reference 4 floor lzp_lrp reply:
Quote: refer to the original poster jxpanda response:

Now you need to generate a statistics, there are a few columns show need to merge cells,
Excuse me, how to achieve in data window, similar to the EXCEL merge cells showed that thank you,

Couldn't come up with an image upload, can put a link,
http://img.blog.csdn.net/20140723171926218


1. Can be achieved by controlling the column, according to whether the purpose of the merged cell, such as A column, written expression in A visible, if (getrow ()=1, 0, 1) to control the display, such as

2. Can suppress Repeating values compressed duplicate values to achieve

CodePudding user response:



The effect of excel, has done

CodePudding user response:

refer to 7th floor coderman response:


The effect of excel, also go


Bad, is it by line to make or other way? Can you give an example???
15967381 @qq.com

CodePudding user response:

refer to the eighth floor jiang396 response:
Quote: refer to 7th floor coderman response:



The effect of excel, also go


Bad, is it by line to make or other way? Can you give an example???
15967381 @qq.com


This is FreeForm format of the data window, and the content is in the detail area, don't be misled you

As to the left of the "one", is a text to achieve

CodePudding user response:

If you don't too large amount of data, such as less than 20 lines, you can use the external data sources to delimit the FreeForm format, and then use the grid data window to retrieve data, then write to the FreeForm, if your data lines hundreds or thousands of, so the FreeForm don't meet your requirements, suppress Repeating values is a better solution

CodePudding user response:

Suppress Repeating values should be able to meet your requirements

CodePudding user response:

references 9 f lzp_lrp response:
this is the data window, FreeForm format and the content is in the detail area, don't be misled you

As to the left of the "one", is put a text to achieve








Is indeed a freeform style of DW, but not use the mouse to put text, but with the program painted,
The first picture is reports the design of the interface;
Second is freport source code of the function, and more than 500 K report design and preview the object;
Freport object function is to explain the third image of the contents of the report file. According to the report file content in the parameters setting, painted with the program statements,

CodePudding user response:

Is indeed a freeform style of DW, but not use the mouse to put text, but with the program painted,

Program painted, no more than is dynamically created text, you can put the grammar to export, try to create a new data window
  • Related