Assistance Required in Paginated Report/SSRS Report
Hi Team, I hope this email finds you well. I am reaching out for your assistance in resolving an issue I am encountering with a paginated report. The report is designed such that after selecting multiple parameters, clicking on the Reject column record redirects to a child report. However, an error is displayed: "The report parameter list exceeds the limit of 2040 characters, needs to reduce the selected values for Zone 1, 2, 3 WO# dropdown." I need assistance in ensuring that even after selecting "Select All" for the parameters, the report does not exceed the character limit and continues to function without errors. I have also attached the expression used to achieve the functionality for your reference: =IIF(LEN(Globals!ReportServerUrl +"?%2fBRS+Singapore%2fPA+Reports%2fTIJ4%2fSGP_Falcon%2fProduction+Reports%2fReject_Pen_summery_yield&rs:Command=Render&rc:Toolbar=False&StartDate= " & Parameters!parstartdate.Value & "&EndDate= " & Parameters!parenddate.Value & "&ShiftList= " &Join(Parameters!parshiftinclude.Value,",") & "&moduleky= " & Fields!MODULE_DIM_KY.Value & " &pruntype= " &Join(Parameters!paruntype.Value,",") & "&Zone1Wo= " & Join(Parameters!Zone1Wo.Value,"&Zone1Wo="))<=2083, "javascript:void(window.open('"+ Globals!ReportServerUrl +"?%2fBRS+Singapore%2fPA+Reports%2fTIJ4%2fSGP_Falcon%2fProduction+Reports%2fReject_Pen_summery_yield&rs:Command=Render&rc:Toolbar=False&StartDate= " & Parameters!parstartdate.Value & "&EndDate= " & Parameters!parenddate.Value & "&ShiftList= " &Join(Parameters!parshiftinclude.Value,",") & " &moduleky= " & Fields!MODULE_DIM_KY.Value & "&pruntype= " &Join(Parameters!paruntype.Value,",") & "&Zone1Wo= " &Join(Parameters!Zone1Wo.Value,"&Zone1Wo=") & "'))", "") ' --- Max URL limit accepted by IE browser is 2083 char Looking forward to your assistance! Thanks & Regards, Heena Kousar
Power BI Report builder | Matrix displays empty row on top with totals
Hi, I'm not sure if this is the right section of the forum, as I'm using the Report Builder from an existing report published in the Power BI service. In the original query in Power BI Desktop, my tables work just fine. However, in the Power BI report builder, I get an extra empty row for each level of the matrix with my total values as a value of the field. When I try to add functions to calculate the totals at the bottom of the table, my values are not correct because the formula picks up the values in those empty rows too. In the example above, the first row has empty values for Tenant ID and Batch, and the values of the columns are really the totals. So, if I sum the fields values for "Onboarded" in the total row, I get 66, while the correct value should be 33. How do I exclude that first empty row? It's really confusing... Thanks in advance! ~AlienvolmImproving Data Transfer Speed in ETL Process
We are using POWERBI in our organization. WE are having data around 400GB in our server. The issue is that it will take around a day to refresh all the dashboards which will be used to followup and monitor daily achievements. Is there any method to speedup the refresh process? Please provide your suggestions which are highly aprriciated by us.
