Forum Discussion
Report Builder: Range Inclusive returning blank report
Hi all, I've built a paginated report with a date parameter from - to. The dates are the order creation dates. By default, the dates are today (to) and today-7 (from). When it happens that there is...
Can you please share the query that returns the orders for the period between the parameter.
Try to pass parameter values explicitly and see if results are appearing in the dataset.
DEFINE VAR vFromnakupnikontraktypohybyBalicekDatumPorizeni1 = IF(PATHLENGTH(@FromnakupnikontraktypohybyBalicekDatumPorizeni) = 1, IF(@FromnakupnikontraktypohybyBalicekDatumPorizeni <> "", @FromnakupnikontraktypohybyBalicekDatumPorizeni, BLANK()), IF(PATHITEM(@FromnakupnikontraktypohybyBalicekDatumPorizeni, 2) <> "", PATHITEM(@FromnakupnikontraktypohybyBalicekDatumPorizeni, 2), BLANK()))
VAR vFromnakupnikontraktypohybyBalicekDatumPorizeni1ALL = PATHLENGTH(@FromnakupnikontraktypohybyBalicekDatumPorizeni) > 1 && PATHITEM(@FromnakupnikontraktypohybyBalicekDatumPorizeni, 1, 1) < 1
VAR vTonakupnikontraktypohybyBalicekDatumPorizeni1 = IF(PATHLENGTH(@TonakupnikontraktypohybyBalicekDatumPorizeni) = 1, IF(@TonakupnikontraktypohybyBalicekDatumPorizeni <> "", @TonakupnikontraktypohybyBalicekDatumPorizeni, BLANK()), IF(PATHITEM(@TonakupnikontraktypohybyBalicekDatumPorizeni, 2) <> "", PATHITEM(@TonakupnikontraktypohybyBalicekDatumPorizeni, 2), BLANK()))
VAR vTonakupnikontraktypohybyBalicekDatumPorizeni1ALL = PATHLENGTH(@TonakupnikontraktypohybyBalicekDatumPorizeni) > 1 && PATHITEM(@TonakupnikontraktypohybyBalicekDatumPorizeni, 1, 1) < 1
EVALUATE SUMMARIZECOLUMNS('nakupni_kontrakty_pohyby'[CisloSmlouvy], 'nakupni_kontrakty_hlavicka'[Nazev], 'nakupni_kontrakty_pohyby'[PotvrzDatDod_Y], 'nakupni_kontrakty_pohyby'[PotvrzDatDod_M], 'nakupni_kontrakty_pohyby'[Nazev1], 'nakupni_kontrakty_pohyby'[FuturesProdejID], 'nakupni_kontrakty_pohyby'[FuturesProdejNazev], 'prodejni_kontrakt_hlavicka'[Nazev], 'nakupni_kontrakty_pohyby'[ProdejniSmlouvaCislo], 'nakupni_kontrakty_pohyby'[BalicekDatumPorizeni], 'nakupni_kontrakty_pohyby'[BalicekDatumZmeny], 'nakupni_kontrakty_pohyby'[FuturesNakupID], FILTER(VALUES('nakupni_kontrakty_pohyby'[BalicekDatumPorizeni]), (vFromnakupnikontraktypohybyBalicekDatumPorizeni1ALL || 'nakupni_kontrakty_pohyby'[BalicekDatumPorizeni] >= DATEVALUE(vFromnakupnikontraktypohybyBalicekDatumPorizeni1) + TIMEVALUE(vFromnakupnikontraktypohybyBalicekDatumPorizeni1)) && (vTonakupnikontraktypohybyBalicekDatumPorizeni1ALL || 'nakupni_kontrakty_pohyby'[BalicekDatumPorizeni] <= DATEVALUE(vTonakupnikontraktypohybyBalicekDatumPorizeni1) + TIMEVALUE(vTonakupnikontraktypohybyBalicekDatumPorizeni1))), "MnozstviNakoupeno", [MnozstviNakoupeno], "JCbezDaniKC weighted by Mnozstvi per ID", [JCbezDaniKC weighted by Mnozstvi per ID], "JCbezDaniEUR weighted by Mnozstvi per ID", [JCbezDaniEUR weighted by Mnozstvi per ID], "Premium weighted by Mnozstvi per ID", [Premium weighted by Mnozstvi per ID], "FuturesProdejCena weighted by Mnozstvi per ID", [FuturesProdejCena weighted by Mnozstvi per ID], "ProdejniSmlouvaCenaKC weighted by Mnozstvi per ID", [ProdejniSmlouvaCenaKC weighted by Mnozstvi per ID], "KurzFwdNeboUcetni weighted by Mnozstvi per ID", [KurzFwdNeboUcetni weighted by Mnozstvi per ID], "ProdejniSmlouvaCenaEUR weighted by Mnozstvi per ID", [ProdejniSmlouvaCenaEUR weighted by Mnozstvi per ID], "ProdejniSmlouvaPremium weighted by ProdejSmlouvaMnozstvi per ID", [ProdejniSmlouvaPremium weighted by ProdejSmlouvaMnozstvi per ID], "FyzMarzeCZK", [FyzMarzeCZK], "FyzMarzeEUR", [FyzMarzeEUR], "FyzMarzeCelkem", [FyzMarzeCelkem], "DerivMarze", [DerivMarze], "DerivMarzeCZK", [DerivMarzeCZK], "MarzeObchod", [MarzeObchod], "ProvizeCZK", [ProvizeCZK], "hvw_TIMTpPohybyE._DJC1 weighted by MnozstviNakoupeno per ID", [hvw_TIMTpPohybyE._DJC1 weighted by MnozstviNakoupeno per ID], "MarzeCelkemNaTunu", [MarzeCelkemNaTunu], "MarzeCelkemCZK", [MarzeCelkemCZK], "FuturesNakupCena weighted by FuturesNakupMnozstvi per ID 2", [FuturesNakupCena weighted by FuturesNakupMnozstvi per ID 2], "Bonifikace weighted by MnozstviNakoupeno per ID", [Bonifikace weighted by MnozstviNakoupeno per ID])If I pass parameters values explicitly at Query Designer, it filters out properly. The query itself is relatively complex as it comes from a Power BI Data set.
At the current settings it gives all data, only when display you have to find the date where there is an entry so that it starts showing data.