SSRS Report not maintaining same format when exported to Excel
Hello , I have a Oracle SQL query Select To_NUMBER( AG.SBA_REP, '99,999.99') FROM TABLE A. I used the SQL in SSRS and formatted the cell with SSRS expression FORMAT(CDec(Fields!Total_RLHAP_Award.Value), " #,0.00"). The Problem is when I export the report to excel the column records returns to text/General instead of integer. I have also tried removing the expression but the result is the same. Any idea of how to solve this?.Warning ID 50 and 1202 in report server
Hello, I saw this warning ID's in our server Manager Report Server today but not sure how to interprete them and what to do with them. Any help with be appreciated. Source ID Severity comments NTFS 50 Warning File and Storage Service Tab SCECLI 1202 Warning All Servers Tab Thank YouError Uploading Reports on Report Server
I started getting this error today. I am unable to upload new report or over write existing report on report server. I have checked the disk space where report server is installed and I have 70GB free space. I tried deleting one report but I get the same error as shown below. I am using Oracle Database and reports I have on the instance runs well but I can't overwrite existing report, upload new reports or delete. What should I do to solve this problem?.
WEEKNUM - Every 10th week is 6 digits
Created a Dates table that includes a column for Week Number using DAX WEEKNUM function. Most of the data is correct, however for some reason every 10th week is showing up as 6-digit numbers that increment for each day of that week. This is the case for week numbers 10, 20, 30, 40 and 50. In example below, 143527 is Sunday, 143528 is Monday, etc. of week number 10. I tried changing data format for Week column from Text to Whole Number and even deleted and re-created the table, but still having the issue. Does anyone know how to fix this?
