Hello!
I encountered the following today while evaluating your product.
1) I am missing a stack panel diagramm. Are there any plans to include this type?
2) As the stack panel diagramm is not possible, I wanted to add a "Column chart" type and add two columns. The columns should visualize count(<Datafield1>) and count(<Datafield2>). Am I correct that the functions Count, Sum, Max, ... are not supported in the chart types?
3) While trying different options to achieve my goals, I added labels to the report footer. Opening the Label Text Assistant and selecting the "Sum()" function, I then inserted (double clicked) the variable from my data source. The Assistant made the following expression "=Sum(First(Fields.CheckNotPassedIndicator, DataSources.MyDataSource)). Why does the assistant insert the "First()" function when I double click on a variable of my data source? I removed the "First()" function to get the formulas running correct.
If I insert "=Count(Fields.CheckNotPassedIndicator, DataSources.MyDataSource)" at the Label Text Assistant I get the following error message:
"Expression contains parsing error(s) Unable to resolve expression type, Parameter count mismatch at ().F<Id<Count>>(Ctx<Fields>.Id<CheckNotPassedIndicator>,Ctx<DataSources>.Id<MyDataSource>)" Making a Sum() is possible but Count() on the same variable is not possible although the variable has the type int. What must be changed to get the "Count()" functioning?
4) Depending on a field of the row, the table row should be hidden (row height = 0). If the visibility of the row is set to the field value, the row is not visible but consuming space on the report. This leads to a "fragmented" detail section.
5) I do not want a page break between the detail section and the report footer which contains the sum() and count() functions. In the detail section the InsertPageBreakAfter is set to "False". How can I remove/disable the page break?
6) Is there a possibility to fill the datasource while designing the report? If i change the width of a label , I do not want to start the complete solution to check if the variable could be displayed without a line break.
Thanks for your informationBest RegardsAlex
Hi Alex,
1) Improving Chart support is ranked high in the backlog. We will consider you feedback when choosing the new chart types to support.
2) Currently the chart values can only be bound to fields, not to an arbitrary expression. Part of the improving the chart story is about binding to arbitrary expressions too.
3) The assistant just provides basic guidance for building an expression. It essentially inserts at the current cursor position what you have selected. If you are selecting data fields, it will add a First function if the selected data field does not belongs to the current data context. I mean, the assistant is not smart enough to do what you want. Regarding the Count, just use “=Count(DataSources.MyDataSource)” to count the number of elements in MyDataSource.
4) Currently we don’t support hiding individual rows.
5) The report footer always starts in a new page. I’m not sure how your report is, but I guess you can add those totals in a summary footer.
6) Sorry I don’t understand this one. What you are saying is that you don’t see any data in the VS preview?
Hope it helps
Best,
Leo
Hello Leo!
Thank you for the information.
>> 4) Currently we don’t support hiding individual rows. <<Thats not good for me as some of our reports need this feature.
>> 5) The report footer always starts in a new page. I’m not sure how your report is, but I guess you can add those totals in a summary footer. <<Thanks, I had the same idea yesterday after I published the post.6) Sorry, my fault. I should fill the datasource of the report.
Regards,Alex