Report builder not accepting Date parameter as dd-mm-yyyy
Hi, hope someone can help me. I create a blank report with one parameter. I mark the parameter as datetime so that i can get a calendar. I have one field that references the parameter to see what it shows. If i select a date that is less than 12 days, it swops the month and date. So I guess it wants US date (MM-dd-yyyy) and I want UK (dd-MM-yyyy) My regional settings is (dd-MM-yyyy) I tried Report Localization Language as User language as well as en-GB I cant change anything on the Server I get this message after selecting a date on the calendar The value provided for the report parameter 'DateFrom' is not valid for its type. (rsReportParameterTypeMismatch) Any help would be much appreciated. PS I think it is a server setting, but I cant change anything there. Only way out for me would propably doing away with the calendar control and let people put in a text box what date they want.
How to merge second row line to first row, in Paginated Report Builder
Hi I have the following setup Item No Category Direction1 Direction2 Value Value3 10006 Cat1 Pay 100 10006 Cat1 Rec 125 10007 Cat1 Pay 98.5 10007 Cat1 Rec 88.4 How can i show the values for the same item & Category in one row and not have them split into multiple rows. Any help will be appreciated.
Power BI Report Builder Error
I have a report which I've transitioned to Power BI Report Builder from Report Builder 3.0. I've set everything up the same as it was on Report Builder 3.0 with the exclusion of a dsDefaultDates dataset. Originally they wanted it from the beginning of the previous month to the end of that month to now wanting it to cover the last years worth of new accounts. (See queries below) Unfortunately, when I hit "Run"...the first page shows up just fine, but then if you keep scrolling or hit the arrow to go to the next page; I get an error, "An error occurred during local reporting processing". Is there a log file somewhere which can provide me a bit more of a detailed reason as to the cause of the error? Report Builder 3.0 dsDefaultDates dataset query: select trunc(trunc(sysdate,'MM')-1,'MM') StartDate, trunc(sysdate,'MM')-1 StopDate from dual Power BI Report Builder dsDefaultDates dataset query: select trunc(sysdate)-366 StartDate, trunc(sysdate)-1 StopDate from dual; Power BI Report Builder Installed Version: 15.6.1628.2
Combining OR & AND in multi-value parameters
Hi, I have 3 parameters in my report query. The system generated DAX is as follows. I need to modify below query such that either I enter a combination of [CNTR] & [CNTR_DT] or enter just enter [SUPP_LD_NO] as the parameter, leaving other two fields blank. EVALUATE SUMMARIZECOLUMNS('Data'[CNTR], 'Data'[CNTR_DT], 'Data'[SUPP_LD_NO], RSCustomDaxFilter(@DataCNTR,EqualToCondition,[Data].[CNTR],String), RSCustomDaxFilter(@DataCNTRDT,EqualToCondition,[Data].[CNTR_DT],DateTime), RSCustomDaxFilter(@DataSUPPLDNO,EqualToCondition,[Data].[SUPP_LD_NO],String)) Assuming I was clear with my requirement, please assist. Regards, Muralidhar
