How does your temp table only have 4 rows?

I had my first meeting cancel today. Inside I was jumping for joy. 🙂

Are you trying to capture the data somewhere like a staging table, or render it in a report? If the answer is render, pre-render or cache a report, just...

Your report data comes from a query that builds a dataset. I would modify the query to add a column with a value for the modalityId, that you can...

I would do this in your dataset with an computed column

monotonous

Put a PendingValue column in your dataset and compute it there, then in the report just SUM that column.

I am not quite sure what you are trying to indicate with "*" but I would probably use IIF(InStr to do your evaulation. In the SSRS Expression builder you...

I don't believe there are any properties that would allow you to do this within SSRS. There is the ToolTip, but that won't highlight the cell, it will put...

maintenance

If you can't modify the SP then you can try this approach.

1. Create a table in your db with the correct column names and data definitions to receive data from...

Would you not have the dollar items (price, cost) as a measure within the new fact? As noted above, I think you'd still need a count of some sort (whether...

How do you provide these numbers as measures now - given that I run a report to show me all the people who purchased in jan 2011 - and then...

I am not aware of a way to do this outside of building another report that does not contain the data you do not want to export.

eclectic