嵌套矩表应该怎么操作，文中这种效果能实现吗

Vanquisher · Vanquisher

本帖最后由 Vanquisher 于 2021-5-6 16:28 编辑

JamesLv 发表于 2021-5-6 15:56
她今天请假没来公司，我问问其它同事，或者她上次给您说的方式发一下，我验证一下

ARJS定义文件如下：
我好像知道原因了，我嵌套矩表的时候没注意列宽度，扩展出来的时候超出了范围就报错Endless loop detected 这错报的就离谱，你可以按这份定义文件试试
-----------------------------------------------------------------------------------

{"Name":"报表1","Width":"6.3cm","DocumentMap":{"Source":"All"},"Layers":[{"Name":"default"}],"CustomProperties":[{"Name":"PaperOrientation","Value":"Portrait"},{"Name":"DisplayType","Value":"Page"},{"Name":"SizeType","Value":"Default"}],"Page":{"PageWidth":"21cm","PageHeight":"29.7cm","RightMargin":"1cm","LeftMargin":"1cm","TopMargin":"1cm","BottomMargin":"1cm","Columns":1,"ColumnSpacing":"0.5in"},"DataSources":[{"Name":"DataSource","ConnectionProperties":{"DataProvider":"JSONEMBED","ConnectString":"jsondata={\\n "recordNo":"ZHJT2021J00267",\\n "taskNo":"ZHJT2021R00291",\\n "sampleName":"砼立方体试件",\\n "testAt":"2021-01-17",\\n "condition":{\\n "temp":"20",\\n "humidity":"1.5xx"\\n },\\n "device":"压力试验机 E2000075，钢直尺0~30cm LE120002",\\n "testData":{\\n "body":[\\n {\\n "sampleNo": "ZHJT2021Y00227",\\n "createdAt":"2020-12-12",\\n "pressure":[1,23,444],\\n "part": "桥梁工程（双田小桥）1-7预制空心板桥梁工程（双田小桥）1-7预制空心板",\\n "level":"C40",\\n "expiredAt":"2020-12-12",\\n "size":"150*150*150"\\n },\\n {\\n "sampleNo": "ZHJT2021Y00229",\\n "createdAt":"2020-12-12",\\n "pressure":[2,24,434],\\n "part": "桥梁工程（双田小桥）1-8预制空心板桥梁工程（双田小桥）1-7预制空心板",\\n "level":"C40",\\n "expiredAt":"2020-12-111",\\n "size":"250*250*250"\\n }\\n ],\\n "remark":"这里是备注"\\n }\\n}\\n\\n"}}],"Body":{"Height":"6.45cm","ReportItems":[{"Type":"tablix","Name":"矩表6","ZIndex":6,"CustomProperties":[{"Name":"WizardModel","Value":"{"layoutOptions":{"totals":{"totalsForRowGroups":false,"subtotalsForRowGroups":false,"totalsForColumnGroups":false,"subtotalsForColumnGroups":false,"showTotalsBeforeGroup":false},"features":{"expandCollapseGroups":false,"collapsedGroups":false,"enableUserSort":false,"steppedRowGroups":false,"showValuesAsRows":false}},"columnHierarchy":[{"group":{"name":"矩表6_sampleNo_分组","field":{"name":"sampleNo","expr":"=Fields!sampleNo.Value"},"sorting":null,"itemName":"文本框10","itemValue":"=Fields!sampleNo.Value","format":""},"children":[],"startBodyIndex":0,"endBodyIndex":0}],"rowHierarchy":[],"body":[[{"itemName":"文本框11","field":{"name":"createdAt","expr":"=Fields!createdAt.Value"},"aggregate":null,"format":""}]]}"}],"DataSetName":"testData.body","RepeatColumnHeaders":true,"RepeatRowHeaders":true,"RowHierarchy":{"Members":[{"BodyIndex":0,"Group":null},{"BodyIndex":1,"Group":null}]},"ColumnHierarchy":{"LevelSizes":["0.75cm"],"Members":[{"Header":{"Item":{"Type":"textbox","Name":"文本框12","CanGrow":true,"KeepTogether":true,"Value":"样品编号","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.75cm"},"LevelCount":1},"BodyIndex":0,"Group":null},{"Header":{"Item":{"Type":"textbox","Name":"文本框10","DataElementName":"sampleNo","CanGrow":true,"KeepTogether":true,"Value":"=Fields!sampleNo.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.75cm"},"LevelCount":1},"BodyIndex":1,"Group":{"Name":"矩表6_sampleNo_分组","GroupExpressions":["=Fields!sampleNo.Value"]}}]},"Body":{"Columns":["2.5cm","2.5cm"],"Rows":[{"Height":"0.75cm","Cells":[{"Item":{"Type":"textbox","Name":"文本框13","CanGrow":true,"KeepTogether":true,"Value":"创建时间","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.75cm"}},{"Item":{"Type":"textbox","Name":"文本框11","DataElementName":"createdAt","CanGrow":true,"KeepTogether":true,"Value":"=Fields!createdAt.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.75cm"}}]},{"Height":"0.75cm","Cells":[{"Item":{"Type":"textbox","Name":"文本框14","CanGrow":true,"KeepTogether":true,"Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.75cm"}},{"Item":{"Type":"tablix","Name":"矩表7","ZIndex":7,"CustomProperties":[{"Name":"WizardModel","Value":"{"layoutOptions":{"totals":{"totalsForRowGroups":false,"subtotalsForRowGroups":false,"totalsForColumnGroups":false,"subtotalsForColumnGroups":false,"showTotalsBeforeGroup":false},"features":{"expandCollapseGroups":false,"collapsedGroups":false,"enableUserSort":false,"steppedRowGroups":false,"showValuesAsRows":false}},"columnHierarchy":[{"group":{"name":"矩表7_Field1_分组","field":{"name":"Field1","expr":"=Fields!Field1.Value"},"sorting":null,"itemName":"文本框28","itemValue":"=Fields!Field1.Value","format":""},"children":[],"startBodyIndex":0,"endBodyIndex":0}],"rowHierarchy":[],"body":[[{"itemName":"文本框29","field":{"name":"Field1","expr":"=Fields!Field1.Value"},"aggregate":null,"format":""}]]}"}],"DataSetName":"pressure","RepeatColumnHeaders":true,"RepeatRowHeaders":true,"RowHierarchy":{"Members":[{"BodyIndex":0,"Group":null}]},"ColumnHierarchy":{"Members":[{"BodyIndex":0,"Group":{"Name":"矩表7_Field1_分组","GroupExpressions":["=Fields!Field1.Value"]}}]},"Body":{"Columns":["2.5cm"],"Rows":[{"Height":"0.75cm","Cells":[{"Item":{"Type":"textbox","Name":"文本框29","DataElementName":"Field1","CanGrow":true,"KeepTogether":true,"Value":"=Fields!Field1.Value","Style":{"Border":{"Color":"DimGray","Style":"Solid"},"FontFamily":"微软雅黑","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","TextAlign":"Center","VerticalAlign":"Middle"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.75cm"}}]}]},"Style":{"FontFamily":"微软雅黑"},"Left":"0cm","Top":"0cm","Width":"2.5cm","Height":"0.75cm"}}]}]},"Style":{"FontFamily":"微软雅黑"},"Left":"1.3cm","Top":"4.2cm","Width":"5cm","Height":"2.25cm"}]},"DataSets":[{"Name":"DataSet","Fields":[{"Name":"recordNo","DataField":"recordNo"},{"Name":"taskNo","DataField":"taskNo"},{"Name":"sampleName","DataField":"sampleName"},{"Name":"testAt","DataField":"testAt"},{"Name":"condition.temp","DataField":"condition.temp"},{"Name":"condition.humidity","DataField":"condition.humidity"},{"Name":"device","DataField":"device"},{"Name":"testData.body","DataField":"testData.body"},{"Name":"testData.remark","DataField":"testData.remark"}],"Query":{"DataSourceName":"DataSource","CommandText":"jpath=$"},"CaseSensitivity":"Auto","KanatypeSensitivity":"Auto","AccentSensitivity":"Auto","WidthSensitivity":"Auto"},{"Name":"testData.body","Fields":[{"Name":"sampleNo","DataField":"sampleNo"},{"Name":"createdAt","DataField":"createdAt"},{"Name":"pressure","DataField":"pressure"},{"Name":"part","DataField":"part"},{"Name":"level","DataField":"level"},{"Name":"expiredAt","DataField":"expiredAt"},{"Name":"size","DataField":"size"}],"Query":{"DataSourceName":"$dataset:DataSet/testData.body"},"CaseSensitivity":"Auto","KanatypeSensitivity":"Auto","AccentSensitivity":"Auto","WidthSensitivity":"Auto"},{"Name":"pressure","Fields":[{"Name":"Field1","DataField":"Field1"}],"Query":{"DataSourceName":"$dataset:testData.body/pressure"},"CaseSensitivity":"Auto","KanatypeSensitivity":"Auto","AccentSensitivity":"Auto","WidthSensitivity":"Auto"}]}

复制代码

Crystal.Li · Crystal.Li

好的，收到。我们这边看看~

		自动登录	找回密码
密码			立即注册

[已处理] 嵌套矩表应该怎么操作，文中这种效果能实现吗

微信认证勋章

讲师达人

元老葡萄

悬赏达人