MID function won’t return ‘N/A’ as default
I am using a combination of INSTR and MID functions to search a text field for a specific value and if the value is found, I return everything after this text until a period is found. If the specific value is not found, I want to return “N/A” but instead get a value of #Error. If the value is found, it is correctly displayed but I can’t get the ‘N/A’ to appear; it always returns #Error. I define two fields using INSTR function; one to show the first position that the value is found, and the second to show the position the period is in and use the values in the MID function. I noticed that the INSTR function returns an integer value of 0 if the value isn’t found, so I write my MID function to check if the value is 0 and return ‘N/A’ if it is; i.e,
How do I add an additional value to a SLECT DISTINCT
I have a parameter in SSRS that uses a query to retrieve a list of values.
Is there a way to Protect/Lock a range of cells from being edited in an Excel report that was exported from Report Builder 3.0 (v15.0.19914.0)?
Basically, working on a project automating a scorecard in SQL Report Builder, and the end-user has a requirement to lock a certain section of the scorecard once it is exported to Excel. Can that be done? I know you can set formatting changes to specific cells, but I can’t seem to find how to lock a cell for editing.