April 22, 2008 at 8:34 am
I am new to SQL 2005 reporting and I need help.
I have a table that right now has 5 rows of data, when I run the following code in query analyzer:
Select Ranking,
Indicator,
Compliant,
Eligible
from Physician_Report
Order by ranking asc
I get five rows back, which is what I would expect.
When I run this in SQL Reporting, I get five rows on the data tab. The issue is that when I go to preview the report, SQL tries to sum all my data and roll it up. If I delete the word sum from in front of the field, then it returns only the last fields.
What am I doing wrong?
April 22, 2008 at 10:44 am
You either did not add a grid to the report, or you added a grid and suppressed the detail rows.
April 23, 2008 at 8:47 am
This was a DOH! moment, I am used to being able to pull my data into my report and build it from there, not having to insert a table and build the report from there.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply