At a guess, your column is not wide enough and you have disabled the growth property of the cell/column.

I think the problem is a language barrier, however, I'm not entirely sure what you mean by your statements:

if Date in alias b is less than frdate than Amount...

I may be recalling incorrectly, but, I think that SUM at that point will still be within your grouping. You should just be able to do:
=Fields!PtCount.Value / Sum(Fields!PtCount.Value)

Firstly, what is the reason for having the nolock on you table? Is the table's data static, are no changes are happening on it while you are running this query?...

That's because what you're doing there is incorrect syntax. Your statement there is to return the data from the database @pDB, as in, the database is called "@pDB". You can't...

That query doesn't look like it'll run either. Firstly, in your query, you refer to something not having the value ?0. What is "?0"? It's not a a...

What do you have your agent job set to on completion on step failure? I'll hazard a guess that you have it set as proceed to next step, rather that...

Just a (unformatted) query isn't going to tell us anything about why your query is performing badly, and pictures of your query plan aren't useful (we can't interact with them)....