CrossHeaderBand_Problem + CrossDataBand_Problem

Stimulsoft Reports.NET discussion
Post Reply
Radchenko_vv
Posts: 6
Joined: Mon Oct 11, 2021 2:45 am

CrossHeaderBand_Problem + CrossDataBand_Problem

Post by Radchenko_vv »

Hello, support!
I'm still only newcomer to study StimulSoft
I have problem with CrossHeaderBand + CrossDataBand.
If I set to some cell word wrapping, in other columns is height of cells different.
I cant set height column in cross table design window.
All files are included. (mrt, xlsx, png)

Thank you .
Attachments
Screen_3(from Excel_Correct).png
Screen_3(from Excel_Correct).png (23.23 KiB) Viewed 1156 times
Screen_2(from Designer).png
Screen_2(from Designer).png (17.3 KiB) Viewed 1156 times
Screen_1(from Designer).png
Screen_1(from Designer).png (40.07 KiB) Viewed 1156 times
Cross_Data_test_v1_correct.xlsx
(8.23 KiB) Downloaded 78 times
Cross_Data_test_v1.mrt
(13.09 KiB) Downloaded 79 times
Radchenko_vv
Posts: 6
Joined: Mon Oct 11, 2021 2:45 am

Re: CrossHeaderBand_Problem + CrossDataBand_Problem

Post by Radchenko_vv »

Radchenko_vv wrote: Mon Oct 11, 2021 9:06 am Hello, support!
I'm still only newcomer to study StimulSoft
I have problem with CrossHeaderBand + CrossDataBand.
If I set to some cell word wrapping, in other columns is height of cells different.
I cant set height column in cross table design window.
All files are included. (mrt, xlsx, png)

Thank you .
Do you have any suggestions for this request?
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: CrossHeaderBand_Problem + CrossDataBand_Problem

Post by Lech Kulikowski »

Hello,

Please check the modified report.

Thank you.
Attachments
Cross_Data_test_v1_modified.mrt
(20.85 KiB) Downloaded 80 times
Radchenko_vv
Posts: 6
Joined: Mon Oct 11, 2021 2:45 am

Re: CrossHeaderBand_Problem + CrossDataBand_Problem

Post by Radchenko_vv »

Lech Kulikowski wrote: Tue Oct 12, 2021 2:51 pm Hello,

Please check the modified report.

Thank you.
Something wrong with this report file.
I have send report mrt file in attached files with dataset.
Excel - this is how must be.
Attachments
Screen_4.png
Screen_4.png (103.43 KiB) Viewed 1107 times
Radchenko_vv
Posts: 6
Joined: Mon Oct 11, 2021 2:45 am

Re: CrossHeaderBand_Problem + CrossDataBand_Problem

Post by Radchenko_vv »

Radchenko_vv wrote: Wed Oct 13, 2021 11:18 am
Lech Kulikowski wrote: Tue Oct 12, 2021 2:51 pm Hello,

Please check the modified report.

Thank you.
Something wrong with this report file.
I have send report mrt file in attached files with dataset.
Excel - this is how must be.
-- Test request to fill customer data
--Customer_Info_(DataSource)--

-- Customer List --
DECLARE @List_Customer table(Cust_Id INT, Cust_Name varchar(100))
INSERT INTO @List_Customer (Cust_Id, Cust_Name)
SELECT 1, 'Customer_1' UNION
SELECT 2, 'Customer_2' UNION
SELECT 3, 'Customer_3'

-- Customer Settings List --
DECLARE @List_Customer_Settings table(Settings_Id INT, Settings_Name varchar(100), Settings_Text_Info nvarchar(4000), Cust_Id INT )
INSERT INTO @List_Customer_Settings (Settings_Id, Settings_Name, Settings_Text_Info, Cust_Id)
SELECT 1, 'Finans', 'At the expense of the funds received by the Customer from the compulsory medical insurance fund', 1 UNION
SELECT 1, 'Finans', 'Payment under the Contract is made at the expense of funds received by the customer from TFOMS for 2020', 2 UNION
SELECT 1, 'Finans', 'Funds received by the customer from the compulsory medical insurance fund, from the national budget, from funds from other income-generating activities.' , 3 UNION
SELECT 2, 'Adress', 'C.B.D. Library, and Subscriptions Service,P.O Box 255,Plympton,South Australia 5038', 1 UNION
SELECT 2, 'Adress', 'Troyka Limited, 799 College Street, Toronto, Ontario, Canada M8G IC7', 2 UNION
SELECT 2, 'Adress', '14 Rue de Provigny, 94236 Cachan Cedex' , 3


SELECT
lc.Cust_Id
,lc.Cust_Name
,(SELECT top 1 Settings_Text_Info FROM @List_Customer_Settings lcs WHERE lcs.Cust_Id = lc.Cust_Id AND lcs.Settings_Name = 'Adress') AS Adress
,(SELECT top 1 Settings_Text_Info FROM @List_Customer_Settings lcs WHERE lcs.Cust_Id = lc.Cust_Id AND lcs.Settings_Name = 'Finans') AS Finans

FROM @List_Customer lc

ORDER BY lc.Cust_Id
Radchenko_vv
Posts: 6
Joined: Mon Oct 11, 2021 2:45 am

Re: CrossHeaderBand_Problem + CrossDataBand_Problem

Post by Radchenko_vv »

Radchenko_vv wrote: Wed Oct 13, 2021 11:19 am
Radchenko_vv wrote: Wed Oct 13, 2021 11:18 am
Lech Kulikowski wrote: Tue Oct 12, 2021 2:51 pm Hello,

Please check the modified report.

Thank you.
Something wrong with this report file.
I have send report mrt file in attached files with dataset.
Excel - this is how must be.
-- Test request to fill customer data
--Customer_Info_(DataSource)--

-- Customer List --
DECLARE @List_Customer table(Cust_Id INT, Cust_Name varchar(100))
INSERT INTO @List_Customer (Cust_Id, Cust_Name)
SELECT 1, 'Customer_1' UNION
SELECT 2, 'Customer_2' UNION
SELECT 3, 'Customer_3'

-- Customer Settings List --
DECLARE @List_Customer_Settings table(Settings_Id INT, Settings_Name varchar(100), Settings_Text_Info nvarchar(4000), Cust_Id INT )
INSERT INTO @List_Customer_Settings (Settings_Id, Settings_Name, Settings_Text_Info, Cust_Id)
SELECT 1, 'Finans', 'At the expense of the funds received by the Customer from the compulsory medical insurance fund', 1 UNION
SELECT 1, 'Finans', 'Payment under the Contract is made at the expense of funds received by the customer from TFOMS for 2020', 2 UNION
SELECT 1, 'Finans', 'Funds received by the customer from the compulsory medical insurance fund, from the national budget, from funds from other income-generating activities.' , 3 UNION
SELECT 2, 'Adress', 'C.B.D. Library, and Subscriptions Service,P.O Box 255,Plympton,South Australia 5038', 1 UNION
SELECT 2, 'Adress', 'Troyka Limited, 799 College Street, Toronto, Ontario, Canada M8G IC7', 2 UNION
SELECT 2, 'Adress', '14 Rue de Provigny, 94236 Cachan Cedex' , 3


SELECT
lc.Cust_Id
,lc.Cust_Name
,(SELECT top 1 Settings_Text_Info FROM @List_Customer_Settings lcs WHERE lcs.Cust_Id = lc.Cust_Id AND lcs.Settings_Name = 'Adress') AS Adress
,(SELECT top 1 Settings_Text_Info FROM @List_Customer_Settings lcs WHERE lcs.Cust_Id = lc.Cust_Id AND lcs.Settings_Name = 'Finans') AS Finans

FROM @List_Customer lc

ORDER BY lc.Cust_Id
Attachments
Screen_5.png
Screen_5.png (118.38 KiB) Viewed 1105 times
Radchenko_vv
Posts: 6
Joined: Mon Oct 11, 2021 2:45 am

Re: CrossHeaderBand_Problem + CrossDataBand_Problem

Post by Radchenko_vv »

Lech Kulikowski wrote: Tue Oct 12, 2021 2:51 pm Hello,

Please check the modified report.

Thank you.
I've seen your report. This work not correctly. See please in screenshots.
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: CrossHeaderBand_Problem + CrossDataBand_Problem

Post by Lech Kulikowski »

Hello,

We need some additional time to investigate the issue, we will let you know about the result.

Thank you.
Lech Kulikowski
Posts: 6196
Joined: Tue Mar 20, 2018 5:34 am

Re: CrossHeaderBand_Problem + CrossDataBand_Problem

Post by Lech Kulikowski »

Hello,

Please check the modified report.

Thank you.
Attachments
Cross_Data_test_v1_modified2.mrt
(169.07 KiB) Downloaded 75 times
Post Reply