Selecting Certain Fields in a Column

[Jon23]

Hi,

I am pretty new to using Stimulsoft so please forgive any stupidity.

Within the Main Data, I have two columns, one titled ColumnName, and the other called AssessmentAwarded2. ColumnName contains different grade descriptions, and the AssessmentAwarded2 contains the allocated grade.

The issue I am having is telling the report to choose all grades for a particular description. Is there a syntax/code to differentiate/select particular descriptions in ColumnName? The reports do show the correct grade for whatever description from ColumnName is chosen, it's getting the report to pick the desired description that is the trouble.

Thanks for any help.

Jon

[HighAley]

Hello, Jon.

You could use filter property of the Band to select particular descriptions.
Here is a tutorial video.
It will be useful to watch the Quick Start section of our video tutorials.

Thank you.

[Jon23]

Hi Aleksey, thanks for replying.

Here's a little more information with the issues I'm having.

This is the current set-up in the report creator

http://postimg.org/image/m4qnt6ti9/

When previewing the report, the classes show correctly (The other fields are not setup correctly)

http://postimg.org/image/klqg6ldud/

The issues are with with the other columns (I 'll speak solely regarding the Effort column).

Now, 'Effort' is an entity that is within the 'ColumnName' column in the Main Data. For each subject, effort has been awarded a grade, and those grades are stored in the 'AssessmentAwarded2' column. So for the report, I need the effort column to show all the Effort Grades that the pupil has received from their teachers.

Because I need this for multiple columns, I assume it would be impossible/impractical to use multiple data bands to add the filters (as you stated). Is there a way of filtering the text boxes, after adding a data source to them? (MainData.Effort). When a datasource is added below the effort columns, the preview will display any of the grades stored in AssessmentAwarded2, but it won't be for the desired parameter (effort).

SO, (I think) I need coding which will display 'AssessmentAwarded2' Grades for Effort in 'ColumnNames' (Running down the Effort column on the report). When viewing the data, the fields are aligned, so each row does display all the correct information, it's when converting that for reports that I can't sync them. I have looked through the tutorial videos but none seem to be what I need (may have overlooked)

Sorry for the long winded message, I am just trying to give as much information as possible.

Thanks

Jon

[HighAley]

Hello.

Please, send us your report template with sample data and could you also send us a sample of finished report. How should it look like?
Also specify version of our product that you use.
Please, send this information to support@stimulsoft.com.

Thank you.

[Jon23]

Hi Aleksey,

Thanks again for replying. I figured out the problem, I was using variables that begun with numbers ( ). Without knowing that was an issue, I assumed all the variables would not work.

Thanks for the help.

Jon

[Alex K.]

Hello,

Let us know if you need any additional help.

Thank you.