BK Shorts, Sorting report by a field

Mark_Ogier · September 3, 2020, 3:32pm

Hi

I am testing out the demo BK Shorts program for the Report Designer.

Managed to connect (SQLite) and get a report going real quick, all good. Simple list of Books with Author Surname, Forename and Title.

I want to sort the list by Author Surname (DB field = author_surname)

But cant see any option to do any sorting in the designer. Surely I must be missing something. No sort??

Cheers
Mark

Tim_Parnell · September 3, 2020, 3:45pm

The Order By field was on the bottom of the inspector list if I recall correctly.

Mark_Ogier · September 3, 2020, 3:48pm

Not seeing it. See screenshot

Also. the demo crashes of you right-click on a blank are of the designer page. I tried it in case the sort was a context menu option.

Bob_Keeney2 · September 3, 2020, 3:55pm

Select the Body object and it will then be in properties.

Mark_Ogier · September 3, 2020, 4:00pm

Got it thank you. I assumed the sort would be a property of the field you wanted to sort. Assumption, never a good thing …

BTW. the Preview display looks a bit along the top edge, has the designer stuff showing through I think, see screenshot. I am using Mac Catalina. BKS is 2.08

Any ideas?