CrossHeaderBand_Problem + CrossDataBand_Problem
-
- Posts: 6
- Joined: Mon Oct 11, 2021 2:45 am
CrossHeaderBand_Problem + CrossDataBand_Problem
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 .
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 (23.23 KiB) Viewed 1396 times
-
- Screen_2(from Designer).png (17.3 KiB) Viewed 1396 times
-
- Screen_1(from Designer).png (40.07 KiB) Viewed 1396 times
-
- Cross_Data_test_v1_correct.xlsx
- (8.23 KiB) Downloaded 83 times
-
- Cross_Data_test_v1.mrt
- (13.09 KiB) Downloaded 84 times
-
- Posts: 6
- Joined: Mon Oct 11, 2021 2:45 am
Re: CrossHeaderBand_Problem + CrossDataBand_Problem
Do you have any suggestions for this request?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 .
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: CrossHeaderBand_Problem + CrossDataBand_Problem
Hello,
Please check the modified report.
Thank you.
Please check the modified report.
Thank you.
- Attachments
-
- Cross_Data_test_v1_modified.mrt
- (20.85 KiB) Downloaded 84 times
-
- Posts: 6
- Joined: Mon Oct 11, 2021 2:45 am
Re: CrossHeaderBand_Problem + CrossDataBand_Problem
Something wrong with this report file.Lech Kulikowski wrote: ↑Tue Oct 12, 2021 2:51 pm Hello,
Please check the modified report.
Thank you.
I have send report mrt file in attached files with dataset.
Excel - this is how must be.
- Attachments
-
- Screen_4.png (103.43 KiB) Viewed 1347 times
-
- Posts: 6
- Joined: Mon Oct 11, 2021 2:45 am
Re: CrossHeaderBand_Problem + CrossDataBand_Problem
-- Test request to fill customer dataRadchenko_vv wrote: ↑Wed Oct 13, 2021 11:18 amSomething wrong with this report file.Lech Kulikowski wrote: ↑Tue Oct 12, 2021 2:51 pm Hello,
Please check the modified report.
Thank you.
I have send report mrt file in attached files with dataset.
Excel - this is how must be.
--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
-
- Posts: 6
- Joined: Mon Oct 11, 2021 2:45 am
Re: CrossHeaderBand_Problem + CrossDataBand_Problem
Radchenko_vv wrote: ↑Wed Oct 13, 2021 11:19 am-- Test request to fill customer dataRadchenko_vv wrote: ↑Wed Oct 13, 2021 11:18 amSomething wrong with this report file.Lech Kulikowski wrote: ↑Tue Oct 12, 2021 2:51 pm Hello,
Please check the modified report.
Thank you.
I have send report mrt file in attached files with dataset.
Excel - this is how must be.
--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 (118.38 KiB) Viewed 1345 times
-
- Posts: 6
- Joined: Mon Oct 11, 2021 2:45 am
Re: CrossHeaderBand_Problem + CrossDataBand_Problem
I've seen your report. This work not correctly. See please in screenshots.Lech Kulikowski wrote: ↑Tue Oct 12, 2021 2:51 pm Hello,
Please check the modified report.
Thank you.
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: CrossHeaderBand_Problem + CrossDataBand_Problem
Hello,
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: CrossHeaderBand_Problem + CrossDataBand_Problem
Hello,
Please check the modified report.
Thank you.
Please check the modified report.
Thank you.
- Attachments
-
- Cross_Data_test_v1_modified2.mrt
- (169.07 KiB) Downloaded 80 times