Posts by Paulo Felicio • 41 points
5 posts
-
0
votes1
answer16
viewsA: Reporting Services does not bring line with zeroed values
I managed to resolve leaving the fixed texts of the modalities and types of public, and in the number of vacancies I inserted an if. For the Internal public I put: =Iif(Fields!…
-
0
votes1
answer16
viewsQ: Reporting Services does not bring line with zeroed values
I am making a report of the students' status by course modality, where I need to display a matrix, even if all values are zeroed. By filtering a certain course, which does not contain the "Distance"…
-
0
votes0
answers77
viewsQ: Data Flow Task generates blank Excel file - SQL Server Integration Services
I have a process in SSIS that takes information from a table and exports it to an xlsx file. It happens that, when running Job by SQL Server Agent, often the file is generated blank, even if it has…
-
2
votes1
answer160
viewsQ: Error when using ISDATE in CASE WHEN
Hello, everybody. I am running the query below and is showing the error: "Operand type Clash: int is incompatible with date". My intention in performing this query is to validate whether the field…
-
1
votes0
answers67
viewsQ: Variable is not populated in Procedure
Good morning. I am running the file below, which validates whether the load should run or not, and if it is not possible to run, returns an error message stating why it did not run: declare @dtAtual…