all groups > sql server reporting services > june 2005 >
You're in the

sql server reporting services

group:

This can't be as hard as I'm making it, can it?


RE: This can't be as hard as I'm making it, can it? Harolds
6/30/2005 4:52:01 PM
sql server reporting services: It is really that simple, what you might do is start over, because you may
have something somewhere that is causing the problem.

I did what you were trying to do in about 30 seconds and it worked just fine.

1. Put on a list control
2. In the properties set the DataSetName, hit the '...' in the 'Grouping'
property, in 'Group On:' use the drop down and select your field to group on.
Select the 'Page break at end'
3. Place your Fields on the List control, drag and drop from Fields.
4. Select the preview tab.

It took me longer to type it here then to do it.

[quoted text, click to view]
This can't be as hard as I'm making it, can it? Greg
6/30/2005 8:53:58 PM
I'm trying to build what I would consider a very simple report, but I can't
seem to figure out how Reporting Services wants me to do it.

The "report" is really just a form letter. The data set contains basically
a persons name and their ID. What I need to do is print a new page for each
name. Seems simple. I've messed around with the list control, and the
grouping, but I can't get it to work right.

I created a list control, added a textbox for the name, and a textbox for
the verbage of the letter. I right clicked on the list control, clicked
properties, then hit the "edit group details" button. For the group
expression, I put "=Fields!ID.Value".

This gives me a report with several different people on the same page. I
have tried the checkboxes for inserting page breaks before and after the
list, but they don't seem to make any difference at all.

I'm about to just give up and start drinking because this seems like it
should be REALLY simple, so that means either, A) I've lost a lot more
brain cells then I thought, or B) Designing reports in Reporting Services is
unbelievably non-intuitive.
I hope it's A.

Any help is greatly appreciated.



Re: This can't be as hard as I'm making it, can it? Greg
7/1/2005 12:00:00 AM
[quoted text, click to view]
heh, showoff.

Just kidding, I appreciate your reality check, it helped, thanks. I was
doing basically the same thing you are doing, just a slightly different way.
(right click menu). I started fresh and tried it several times.

Here is what I have determined so far: No matter what I do, viewing the
report in the IDE (preview mode) will always show multiple records per page.
This is also true with the HTML viewer in report manager. That's really OK
with me because this report is going to be printed out via exporting to PDF.
My question is, is this everyone else's experience as well? Am I still
missing something here?

In order to make the report look right (one record per page) when it was
exported to a PDF, I had to make sure my page size was exactly right (actual
page size - margins) and also, the thing that threw me off a bit, make sure
the list control I used stretched from the very top of the report body to
the very bottom.

Now at least it looks right when in PDF, which was my goal.
-Greg


[quoted text, click to view]

AddThis Social Bookmark Button