Graphic report - Horizontal scale bar

There is graphic report case from Geobank client's practice. Initial user question was:

"how we can use Horizontal scale bar in dynamic mode where low and high scale limits are fitted depending on Value variations (min;max)? Length of scale bar should be same, but "
Question related to Geophysic LAS diagram. Please look at attached "pic1.jpg" file

pic1.JPG

Resolving is:

We can setup scale bar by dynamic way using an additional dataset with Min and Max LAS data for the current Hole ID.

An example of dataset is below:

SELECT A.PROJECT, A.SITE_ID, A.INSTANCE, MIN(A.GAMMA) as MinGamma,MAX(A.GAMMA) as MaxGamma

FROM dbo.GB_LAS_DATA AS A

WHERE A.PROJECT = :PROJECT AND A.SITE_ID = :SITE_ID AND A.INSTANCE = :INSTANCE

GROUP BY A.PROJECT, A.SITE_ID, A.INSTANCE

Please look at Scaling properties screenshot (pic2.jpg file) for details

pic2.JPG