none
SSRS table combined with matrix possible? RRS feed

  • Question

  • Hi all - hope you all well

    I am trying to create an SSRS report (Using VB.Net and SQLite) that combines a table with a matrix. Is this at all possible or am I mad?  Is a tablix the same as a table ? The result I would look like  :

    However a create a matrix and group on columns (years), I loose data row the rows. In the following picture I want the second table with all the rows in the first table, but under the respective year columns :

    I am also including my database schema.

    BEGIN TRANSACTION;
    CREATE TABLE IF NOT EXISTS `BlokOntledingsGeskiedenisVyfJaar` (
    `LidNo` TEXT,
    `PlaasNo` TEXT,
    `BlokNo` TEXT,
    `Kultivar` TEXT,
    `Datum` TEXT,
    `Suiker` REAL,
    `pH` REAL,
    `Suur` REAL,
    `Temp` REAL,
    `Plaasnaam` TEXT,
    `Aliasnaam` TEXT,
    `TipeOntleding` TEXT,
    `Jaar` TEXT,
    `Oesskatting` REAL
    );
    COMMIT;

    Regards, sorry for the pictures but though the best to explain.

    Thursday, April 16, 2020 7:35 AM