New Report Designer Syntax


Author
Message
soundmanuk
s
Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)
Group: Forum Members
Posts: 11, Visits: 67
Good Morning, 
I'm keen to get to grips with the new report designer, can you tell me what the back-end engine is so that i can research the syntax used?
Things like how to exclude certain items from reports (filters?)
I'm particularly interested in how to create the configurable reports. But a general understanding of the syntax would help.

Cheers
Phil
Hughes
H
Supreme Being (423 reputation)Supreme Being (423 reputation)Supreme Being (423 reputation)Supreme Being (423 reputation)Supreme Being (423 reputation)Supreme Being (423 reputation)Supreme Being (423 reputation)Supreme Being (423 reputation)Supreme Being (423 reputation)
Group: Forum Members
Posts: 44, Visits: 510
+1
Hi SD Team,

I'm also bouncing back on this post to suggest an update to the "report" related sections of the help.
Also notice that Help (F1) is not working when Report Designer Window is active. 
SD7.4 Build 24-02-25 21:51:29

Thank You,
Rob Robinson
Rob Robinson
Forum Administrator (390K reputation)
Group: Administrators
Posts: 2.3K, Visits: 9K
Hi Phil, Hughes,

Help for the Stardraw Design 7.4 Report Designer is currently a work in progress.

Documentation for the underlying engine, ActiveReports JS, is available at https://developer.mescius.com/activereportsjs/docs/ReportAuthorGuide/QuickStart


Kind regards,
Rob Robinson
Stardraw.com
soundmanuk
s
Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)
Group: Forum Members
Posts: 11, Visits: 67
Rob Robinson - 2/26/2025 11:45:48 AM
Hi Phil, Hughes,

Help for the Stardraw Design 7.4 Report Designer is currently a work in progress.

Documentation for the underlying engine, ActiveReports JS, is available at https://developer.mescius.com/activereportsjs/docs/ReportAuthorGuide/QuickStart

Thank you for this, very helpful.

However, i am unable to find where the parameters can be changed or defined? the online help is telling me its in the data sets section but this is locked and i cant see anything for parameters?

David Snipp
David Snipp
Architect (434K reputation)
Group: Administrators
Posts: 2.9K, Visits: 6.5K
Phil,
Thanks for reporting this.
We have investigated the problem and we will be publishing a fix for this very soon.
Apologies for any inconvenience this may have caused you.

David Snipp
Stardraw.com Ltd
David Snipp
David Snipp
Architect (434K reputation)
Group: Administrators
Posts: 2.9K, Visits: 6.5K
Phil,
I cna confirm that we have now published a fix for this problem.
Please run Stardraw Design 7.4 again and accept updates when prompted.

David Snipp
Stardraw.com Ltd
soundmanuk
s
Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)Forum Guru (56 reputation)
Group: Forum Members
Posts: 11, Visits: 67
David Snipp - 3/6/2025 6:17:17 PM
Phil,
I cna confirm that we have now published a fix for this problem.
Please run Stardraw Design 7.4 again and accept updates when prompted.

Thank you.
My use case is I have multiple drawings in a single file, one per room, i want to only report on whichever drawing I choose, hence the requirement for a parameter. I haven't managed to get this to work as i cant drill down far enough into the datasets, the four datasets given are Project, User, Product Attributes and Cable Attributes, if i select project i can only choose from the upper level Project Details (name, date etc) . Drawings, Cables and Products are listed but return 'null' as I need to drill down further (say to select the drawing name) which is not possible.
I have come across 3 issues.
1) using a copy of the existing 'configurable report' and adding 'Zone' as a parameter item, with a text name in the zone (zone 1, zone 2 etc) i get an error 'Data processing error: Invalid number format: Exclude', Exclude is the text in the Zone, but any text will throw up the error.
If i enter just a numeric value (1,2,3) etc in the zone the report generates but shows the Zone of each product as a £ item (£1.00, £2.00, £3.00).
2) to find the products that had text in the zone, i went to the products table, zone had already been hidden in my config, clicking zone in the config did not bring the column back, this was the same for other hidden columns.
3) if i create a parameter with a query, the list is populated within the parameter and sometimes doesn't show the text until it has been selected, so basically just a big white window, the items are there, just not showing up.

This may be user error


Rob Robinson
Rob Robinson
Forum Administrator (390K reputation)
Group: Administrators
Posts: 2.3K, Visits: 9K
Hi Phil,

Sorry for the long delay in getting back to you on this; the real answer was dependent on an update to SD7.4 that re-works the dataset structure and this update only went live today.

Please run SD7.4 and Accept Updates.

The new structure promotes the Drawings dataset to top level which means you can now use a Parameter to filter by a property of the drawings - I imagine you will use "Title" as the filter.

The Drawings dataset now includes the nested dataset "ProductInstances" which means that for each drawing you can expose the Products in that drawing and report on any Attributes of the Products. 

Regarding the "Invalid Number Format" error; if you were using the Configurable Report template then the Parameter in this template is used to define which Attribute to Sum.  You can only Sum numbers so if you bind the parameter to, or set, a non-numeric value it is right that it should throw an error.

Your real objective with the Parameter, if I understand correctly, is to show data only from the Room (or Zone) that you want, i.e. you want to Filter your report by the value chosen in the Parameter field.  You therefore just need to add a Filter expression to the data region you're using (e.g. a List or Table control) along the lines of Room = Parameter1.

I hope this is helpful.


Kind regards,
Rob Robinson
Stardraw.com
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic
1 active, 1 guest, 0 members, 0 anonymous
No members currently viewing this topic!

Login

Explore
Messages
Mentions
Search