User Profile
miwundu
Helper I
Joined 3 years ago
User Widgets
Contributions
Re: I want to automatically update the report to the latest state at 1-minute intervals.
I think you can click on the grey area on the report builder and then look at the report properties under other. You will see auto refresh. set the time frame you want but be mindful of the size of data or report.2.6KViews0likes5CommentsImpact of Data Source in Report
Hello, My Organization is replacing our shared drive with a centralized Network drive. I have a report server that runs on my computer and toad for Oracle installed. I connect to the report manager remotely. Some of the Data Sources I have for my RDL files are shared Data sets while Some are not. I have a single report with data source from shared drive which I used in creating table for a report . My Question is this : When this change is done what impact will it have on my reporting process in the report server?Solved1.2KViews0likes3CommentsHelp with SSRS Expression
I have 2 datasets in my report but using a common table. dataset 1 is named XXX and dataset 2 is named UNKNOWN . I have a column cell_1 with this ssrs lookup expression from dataset XXX =Sum(Fields!total_complete_1_Count.Value, "XXX") + Sum(Fields!total_complete_2_Count.Value, "XXX") + Sum(Fields!total_complete_3_Count.Value, "XXX") and another column cell_2 from Unknown dataset with this expression Sum(Fields!total_complete_1_Count.Value) + Sum(Fields!total_complete_2_Count.Value) + Sum(Fields!total_complete_3_Count.Value). I want to divide cell_1 by cell_2. XXX EXPRESSION DISPLAYS correctly but unknown displays a wrong value =Sum(Fields!total_complete_1_Count.Value, "XXX") + Sum(Fields!total_complete_2_Count.Value, "XXX") + Sum(Fields!total_complete_3_Count.Value, "XXX") / Sum(Fields!total_complete_1_Count.Value, "UNKNOWN") + Sum(Fields!total_complete_2_Count.Value, "UNKNOWN") + Sum(Fields!total_complete_3_Count.Value, "UNKNOWN"). The value for cell displays correctly but cell 2 does not so the result is wrong. I have also tried to use the numerator and denominator in text boxes properly named and then call them in this expression =CD(Reportitems!XXX_Sum.Value) / CD(Reportitems!UNKNOWN_Sum.Value). THESE ARE THE TEXT BOX NAMES XXX_Sum AND UNKNOWN_Sum. I am not sure what I am doing wrongSolved837Views0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.