Hi, what is the best way to send you a sample based on our version number (2019.4.2)?

We recently upgraded our VueWorks and Stimulsoft report system, our reports are now on version 2019.4.2. We have one report where we have three Compliation Errors that we did not have previously and the report has not been modified after the upgrade. We are hoping you could help us figure out, why w...

Hi Lech,

Do you have a link for reference? I have already validated that the syntax is correct by SQL standards.

We are creating a report that is looking for a 1:1 ration between two record types. Below is the datasource I am trying to create. The issue I am running into is; with the group by and having count clause the columns do not retrieve. However if I remove those two lines the columns retrieve as expect...

Hi Lech, I tried the TOP method several different ways, in my main select and a sub select.However when selecting "Retrieve Columns" nothing is pulled. What is your suggested way of formatting TOP within my query? It is only the ASSET ID field we want the first matching record for, so I do...

I have a report where I want to pull the first asset record that is attached to a work order only. My datasource consists of three different joins, so I am trying to avoid using a sub select. I have tried using MIN and DISTINCT within the initial select statement but neither seem to work. Is there a...

Thank you! That worked perfectly!

Is there a way to multiple the sum of a column from a databand? This is being placed within a Footer band. {Sum(DataBand6,reports_InventoryTransactions.TotalCost)*0.15} However this is causing two errors: "Operator * cannot be applied to operands of type 'decimal' and 'double'" and "O...

We are building a report that we would like to keep as dynamic as possible. What we are trying to achieve is having a certain field pulled from a certain data source based on the id that is associated. Each datasource only has 1 field in them and their is one main data source being used, for sample ...

I am trying to do just this within the Dynamic Report Designer UI. Could you tell me how this would be done within the UI? We need to tie an asset id to a work order id and then have the data populate based off the work order id.