show column report with select user

[s_mokhtari]

hi
i three checkbox
1-id
2-name
3-address
when user select column when select checbox address report then show only field address
or select id,name show report only field id , name
thanks

[Alex K.]

Hello,

Please see the sample report in attachment.

Thank you.

[s_mokhtari]

hi
thanks from file
very good
but i want form chechbox in doesnt in report and this form disign in c#
and report havent any form
thanks
:grinder: :feelgood:

[Alex K.]

Hello,

You can use the following code:

Code: Select all

            StiReport report = new StiReport();
            report.Load(@"E:\SampleSelectingColumnsReport.mrt");
            StiText textProductID = report.GetComponents()["textProductID"] as StiText;
            textProductID.Enabled = true;

            StiText textProductName = report.GetComponents()["textProductName"] as StiText;
            textProductName.Enabled = false;

            StiText textSupplierID = report.GetComponents()["textSupplierID"] as StiText;
            textSupplierID.Enabled = true;

            StiText textCategoryID = report.GetComponents()["textCategoryID"] as StiText;
            textCategoryID.Enabled = false;

            StiText textQuantityPerUnit = report.GetComponents()["textQuantityPerUnit"] as StiText;
            textQuantityPerUnit.Enabled = false;

            StiText textUnitPrice = report.GetComponents()["textUnitPrice"] as StiText;
            textUnitPrice.Enabled = false;

            StiText textUnitsInStock = report.GetComponents()["textUnitsInStock"] as StiText;
            textUnitsInStock.Enabled = true;

            double width = 0;

            StiDataBand DataBand1 = report.GetComponents()["DataBand1"] as StiDataBand;
            foreach (StiComponent comp in DataBand1.Components)
            {
                if (comp.Enabled) width += comp.Width;
            }

            double factor = width / DataBand1.Width;

            foreach (StiComponent comp in DataBand1.Components)
            {
                if (comp.Enabled) comp.Width /= factor;
            }

            report.Show();

Thank you.

[s_mokhtari]

hello
very beautiful your code
thanks a lot of
but add this code

Code: Select all

 StiHeaderBand  h = stiReport2.GetComponents()["HeaderDataSource1"] as StiHeaderBand ;
            foreach (StiComponent comp in h.Components)
            {
                if (comp.Enabled) comp.Width /= factor;
            }

but headers in report dont correctly positions
how design this headers that correctly
thanks a lot of :feelgood: :feelgood:

[Alex K.]

Hello,

You can use the following code:

Code: Select all

StiReport report = new StiReport();
report.Load(@"E:\SampleSelectingColumnsReport.mrt");

StiText textProductID = report.GetComponents()["textProductID"] as StiText;
StiText headerProductID = report.GetComponents()["headerCategoryID"] as StiText;
textProductID.Enabled = true;
headerProductID.Enabled = true;

StiText textProductName = report.GetComponents()["textProductName"] as StiText;
StiText headerProductName = report.GetComponents()["headerProductName"] as StiText;
textProductName.Enabled = false;
headerProductName.Enabled = false;

StiText textSupplierID = report.GetComponents()["textSupplierID"] as StiText;
StiText headerSupplierID = report.GetComponents()["headerSupplierID"] as StiText;
textSupplierID.Enabled = true;
headerSupplierID.Enabled = true;

StiText textCategoryID = report.GetComponents()["textCategoryID"] as StiText;
StiText headerCategoryID = report.GetComponents()["headerCategoryID"] as StiText;
textCategoryID.Enabled = false;
headerCategoryID.Enabled = false;

StiText textQuantityPerUnit = report.GetComponents()["textQuantityPerUnit"] as StiText;
StiText headerQuantityPerUnit = report.GetComponents()["headerQuantityPerUnit"] as StiText;
textQuantityPerUnit.Enabled = false;
headerQuantityPerUnit.Enabled = false;

StiText textUnitPrice = report.GetComponents()["textUnitPrice"] as StiText;
StiText headerUnitPrice = report.GetComponents()["headerUnitPrice"] as StiText;
textUnitPrice.Enabled = false;
headerUnitPrice.Enabled = false;

StiText textUnitsInStock = report.GetComponents()["textUnitsInStock"] as StiText;
StiText headerUnitsInStock = report.GetComponents()["headerUnitsInStock"] as StiText;
textUnitsInStock.Enabled = true;
headerUnitsInStock.Enabled = true;

double width = 0;

StiDataBand DataBand1 = report.GetComponents()["DataBand1"] as StiDataBand;
foreach (StiComponent comp in DataBand1.Components)
{
    if (comp.Enabled) width += comp.Width;
}

double factor = width / DataBand1.Width;

foreach (StiComponent comp in DataBand1.Components)
{
    if (comp.Enabled) comp.Width /= factor;
}

StiHeaderBand HeaderBand1 = report.GetComponents()["HeaderBand1"] as StiHeaderBand;
foreach (StiComponent comp in HeaderBand1.Components)
{
    if (comp.Enabled) comp.Width /= factor;
}

report.Show();

Thank you.

[s_mokhtari]

hello
thanks a lot of your code
very good
but i delete this code because when user show only one col this col width change
i dont change width col

Code: Select all

double width = 0;

StiDataBand DataBand1 = report.GetComponents()["DataBand1"] as StiDataBand;
foreach (StiComponent comp in DataBand1.Components)
{
    if (comp.Enabled) width += comp.Width;
}

double factor = width / DataBand1.Width;

foreach (StiComponent comp in DataBand1.Components)
{
    if (comp.Enabled) comp.Width /= factor;
}

StiHeaderBand HeaderBand1 = report.GetComponents()["HeaderBand1"] as StiHeaderBand;
foreach (StiComponent comp in HeaderBand1.Components)
{
    if (comp.Enabled) comp.Width /= factor;
}

then i want this cols in center report how have one col
thanks a lot of

[Alex K.]

Hello,

In this case you can make verification. If only one column remained, then the width is not changed.

Thank you.