Hello

I have a simple query to count in a sales graph and i group by seller

but Strata Bo ask me all primary key in my view and my query is not disctint or grouping.

Can you tell me , how you start your query with count(*) and some group by on Stratraframe
to learn and reproduce this.

thanks
Olivier,

==============================================
Asp.net C# - Strataframe - telerik
==============================================

thanks michel,

i ll check , the override primary key option.

Can you see the way to build an procedure stored like this ?
to get a condition to put in the Where ?
(i give you a code in vfp cause i dont' get a vb code)

If ! empty(m.nNBPIECES) 
        m.cCondition = m.cCondition + " .AND. CLI_PIECMN<="+Alltr(str(m.nNBPIECES))
    Endif
    If ! empty(m.nSURFACE)
        m.cCondition = m.cCondition + " .AND. CLI_SURF<="+Alltr(str(m.nSURFACE+(m.nSURFACE*M.XPCKORL1/100)))
    Endif

select myfield from mytable where 1=1 and &cCondition

it's the last line i don't get in tsql for my proc stor !

thanks
Olivier


==============================================
Asp.net C# - Strataframe - telerik
==============================================

Hi Olivier,

Here is a sample of a query I used to test before creating the stored procedures:

DECLARE @StartDate AS DATE = '1/1/2013'
DECLARE @EndDate AS DATE = '12/31/2013'
DECLARE @PK_InsuranceCompany AS INT = 0

SELECT
    v.CompanyName,
    SUM(v.BrokerCommissionValue) AS BrokerCommissionvalue
FROM
    vCompanyPayments v
WHERE
    CAST(v.ReceiptDate AS DATE) >= @StartDate AND CAST(v.ReceiptDate AS DATE) <= @EndDate AND
    BrokerCommissionvalue > 0 AND
    (v.PK_InsuranceCompany = @PK_InsuranceCompany OR @PK_InsuranceCompany = 0)

GROUP BY
    v.CompanyName

ORDER BY
    v.CompanyName

Notice how I test for the value of the parameter @PK_InsuranceCompany to be = 0 in the WHERE condition, in this case in my VB application I pass either a real value greater than zero or just zero and the I will get all records for that Insurance Company PK or for all.
You can use similar code to replace your VFP coding and in VB you can control how to pass the parameters to your SQLCommand.

Edhy Rijo