Building a report

I have been "Thrown to the wolves" and need to learn Visual Studio and Reporting Services thru the scholl of hard knocks. I have had about 5 years a self teaching on Microsoft Access and 2 months of SQL Server. Not by any means a pro but I'm learning.

I put my SQL in the Data tab. I go to layout. I have made a couple of reports using the table and subreport in the toolbox. However when I try to drag and drop the fields into the body without a table all that previews is the first field.

When I drop the field in the body it comes out=First(Fields!fldname.Value) or=Sum(Fields!fldname2.Value)

I'd like to get this a continuous report(form). I hope I'm explaining this well enough. I'm going top Barnes and Noble today to get a book but in the meantime does anyone understand what I'm looking for?

I tried finding it on BOL but it didn't help me that much.

Hi

you can also use List to place labels inside. List is similar to Table(Grid) as you can place fields inside, but list does not force you to have table layout.

-yuriy

|||

Hi, I am not sure what you are trying to ask, if you are bugged that when you drag/drop a field it comes like =First(Fields!fldname.Value) instead of

=Fields!fldname.Value, then you can edit this directly or right click in textbox ot table cell and go to Expressions and there you can create an expression using different functions,variables, parameters and fields.

I apologise if I am tootally off the track.

|||

No apologise necessary. I can't explain what I'm looking for well.

I grab a field from my fieldlist and drop it in the body. I go to preview and all that comes up is the first record in my result set. How do I make it a continous report so I have the first record, the last record and everything in between.

I'm able to do this if I create a table in the body and drop the fields in the details portion of that table. However that is too structured for some of the reports I'm looking for.

|||

Drag LIST control to your report first. Configure it to repeat records from your source. Then drag fields into the LIST control.

|||

Yes,

That works. Well I haven't tried the configure part yet but I create a list, drag the field in the list and BAM there it is. Great answer thank you.

|||

You can only use the data regions available to build reports, and they are sufficient to build most of the reports, go through the report design basics(http://msdn2.microsoft.com/en-us/library/ms159253.aspx) and Data regions available in reporting services and you should be able to design more complicated reports with a combination of these data regions(http://msdn2.microsoft.com/en-us/library/ms157134.aspx) .

Still if you have some problem designing the report you can post your specific requirement and we will try to help.