Hey, I have a few conditions I need to narrow down with cross tabs. I am trying to build a leakage report, so I am using cross tabs to create data tables. These data tables hold a set of employee names and their leakage amounts, one cross tab for each applicable title.
First, is there a way to make multiple cross tabs auto fit horizontally with each other? I created about 5 cross tabs with relevant data, but their sizes can vary depending on the name and values in the columns. What I want to do is make it so the cross tabs won't overlap horizontally with each other, but will remain a small distance apart.
Secondly, is there a way for the cross tabs to not even populate if no data is present for them? For example, the row headers for my cross tabs are using a pool of employee names depending on their title. Not every employee should be on this as only a few will be flagged for leakage per month. I created a column with a calculation that turns the employee's name to NULL if they do not have a leakage value, in an attempt to ignore this row of data. I created a filter on the cross tab to exclude these NULL values, that is working fine. Some of the categories, though, will frequently not have any information to populate, but the cross tab populates with a few boxes. No useful information, just relative "junk". If would be perfect if the Cross tabs only appear if there is value for them to populate.
Help with Cross tabs
-
- Posts: 7
- Joined: Wed Apr 19, 2017 6:50 pm
Re: Help with Cross tabs
Hello,
Please send us a simple report with test data which reproduces the issue. We will try to find a solution for you.
Thank you.
Please send us a simple report with test data which reproduces the issue. We will try to find a solution for you.
Thank you.
-
- Posts: 7
- Joined: Wed Apr 19, 2017 6:50 pm
Re: Help with Cross tabs
How would I upload a report?
Also, I think the issue lies with my misunderstanding, not really a bug. I attached a screenshot of the two things I am interested in.
First, the Gap between the two cross tabs. Is there a way to make the horizontal position of the right cross tabs change to fit in line with the crosstab to the left?
Second, how would I hid the two crosstabs with no data?
Also, I think the issue lies with my misunderstanding, not really a bug. I attached a screenshot of the two things I am interested in.
First, the Gap between the two cross tabs. Is there a way to make the horizontal position of the right cross tabs change to fit in line with the crosstab to the left?
Second, how would I hid the two crosstabs with no data?
- Attachments
-
- Cross Tab Stimulsoft Capture.PNG (25.21 KiB) Viewed 2315 times
Re: Help with Cross tabs
Hello,
For the first issue - please try to use the DockStyle property. In second, as a way you can use Condition in which check counts data (Totals.Count() as an example) and use ComponentIsEnabled option (set to false).
Thank you.
For the first issue - please try to use the DockStyle property. In second, as a way you can use Condition in which check counts data (Totals.Count() as an example) and use ComponentIsEnabled option (set to false).
Thank you.
-
- Posts: 7
- Joined: Wed Apr 19, 2017 6:50 pm
Re: Help with Cross tabs
Thank you, Aleksey!
Re: Help with Cross tabs
Hello
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.