So, the first thing is that in this situation you absolutely want to set the Max Memory for the database engine, I can't recommend a value because I don't know enough about the server. Here is are some questions that need to be answered:
1. Is the SQL Server just hosting SSRS and the Report Server databases or does it host other user databases?
2. Please define "high memory usage" and problems that this is causing?
3. Are there any jobs running during this time frame (index maintenance, data loads)?
4 What is the main workload on the server, reporting, OLTP?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question