Changing either of the two inner joins with an outer join could fix this. Can you post table definitions for tblfunds and tbltransactions along with some relevant sample data?

I'm sorry, I blew right past your output section in your original post.

In the case where the daily.fund is null, is there a fund record like:

"Fund2" null null...

And what does your query return at the start of the month?

I've put together a very basic article for a beginner audience on setting up the performance dashboard that I created as I set it up in my environment. I've...

From Chris Hedgate:

The information returned by the DMOs is collected by the engine itself from lots of different sources and the DMOs make it easy for you to use it...

Try running this under different databases. Also make sure there's some activity on the database.

The data is state data not historical, I believe since the last reboot.

The queries Chris Harshman posted should work on your sql 2005 server as long as compatibility level is set to 90 or greater (cross apply is an 05 feature). ...

Where are the performance improvements needed? During selects, updates and/or the table load?

I'm not sure this can be done. The first thing that comes to me is the 'norows' table property. Set that for your subreport table.

Question is,...

Adding hardware is always an option and it can't hurt. Easier to justify right now too.

It is also easy to justify some query changes if they help....

Oh but you are so close! Let us know if you want to jump back on it. I threw the boolean parameter in for free...It's just one way...

the boolean parameter is just a flag for the IIF statement, nothing more. The only thing referencing it is the IIF statement in the text box...

That's it Ramesh...Thanks...

BIDS menu, "Report", "Report Parameters"

Is this a new query? What was the last change to the database before this behavior started happening?

As for the query itself, I made one small modification...

Something like this in your expression for the text box:

=iif(displayfulltextparm=true,"mylongteststring"),left("mylongtestingstring",10)

You would have to add the boolean parameter to check against. This gives the user the option to display the...