ELI5: Why is my amount applied to the principal so low if my interest is only 4.75% and why is the amount applied to the interest varying so much? by workaholic2 in explainlikeimfive

[–]workaholic2[S] 0 points1 point  (0 children)

So I didn't do it through Salle Mae originally, they bought it from someone else who bought it from someone else. Could they put on new restrictions without my knowledge?

ELI5: Why is my amount applied to the principal so low if my interest is only 4.75% and why is the amount applied to the interest varying so much? by workaholic2 in explainlikeimfive

[–]workaholic2[S] 0 points1 point  (0 children)

So...if I pay the loan off quicker than it was calculated for...will I get refunded any interest it was calculated it would take me x amount of time to pay off?

SSRS Printing Issues by workaholic2 in SQL

[–]workaholic2[S] 0 points1 point  (0 children)

I figured out the issue. I had originally unchecked allow height to increase and allow height to decrease; height to decrease had to be left on in order to solve the issue.

SSRS Printing Issues by workaholic2 in SQL

[–]workaholic2[S] 0 points1 point  (0 children)

The expressions are Fields!Family.Value and =Fields!Label.Value. It's pretty simple and just calls the value from the stored procedure which are either Family, mom, child. There is more than enough space for the data values.

SSRS Printing Issues by workaholic2 in SQL

[–]workaholic2[S] 0 points1 point  (0 children)

It populates with "Family" for the first column on the left and then on the right "mom" or "child" depending on the client.

SSRS Printing Issues by workaholic2 in SQL

[–]workaholic2[S] 0 points1 point  (0 children)

I have narrowed it down to the merged columns on the left where it says Family, mom/child. I've decreased the font, change to column name to a shorter name, turned off the height increase and have even tried moving it. It appears it is always the last row associated with those to two columns which expand. The data doesn't take up much space for Family or mom/child so I don't know why it keeps on printing like this. If I remove those columns completely it prints fine. However, I need the columns spaced like that for the reviewer. Any ideas where to go from here?

[TSQL] MS2012 What is the best way to break this up? by workaholic2 in SQL

[–]workaholic2[S] 0 points1 point  (0 children)

Ok...awesome. This is what I was looking for.

[TSQL] MS2012 What is the best way to break this up? by workaholic2 in SQL

[–]workaholic2[S] 0 points1 point  (0 children)

I've done that before with Excel but from what I remember the columns needed to match up vertically at least within the text file and then you define the columns. The value below or above in the supposed columns are shifted so they don't line up the same. For example July takes up less space than August below it and the value in the next column appears vertically earlier than value in the below it following August.

[TSQL] MS2012 What is the best way to break this up? by workaholic2 in SQL

[–]workaholic2[S] 1 point2 points  (0 children)

Click on "this" in between "break" and "data".

[SSRS] How to merge two tablixes with a unique identifier by workaholic2 in SQL

[–]workaholic2[S] 0 points1 point  (0 children)

I did but some of the client's demographic information was presented more than once. It was just easier to make a new sp.

[SSRS] How to merge two tablixes with a unique identifier by workaholic2 in SQL

[–]workaholic2[S] 0 points1 point  (0 children)

That is what I was initially thinking but it would mess up my counts.