Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...Keep up the very good job that you and your team are doing. This site has replaced my morning cup of tea as a must have/do!!!..."

Geography

Where in the world do Tek-Tips members come from?
vbajock (Programmer)
13 Dec 10 12:46
I am converting an Access report that has a group header that has about twenty fields, arranged in three columns of fields across the first half of the page,something you would usually do in SSRS with the list control. It then has a detail record section that prints on the second half of the page. I am at a loss on how to convert this style of report to SSRS style reporting, the parameter mapping between the two keeps giving me an error that fields cannot be used for parameters when I try to use the key field on the list display section as the parameter to the detail view.  I tried just dragging the table into the list view control, no luck. Am I missing a trick ?
RiverGuy (Programmer)
13 Dec 10 13:48
No, you cannot do that.  Keep in mind that SSRS is not directly comparable to Access.  The Services in the phrase SQL Server Reporting Services gives you a clue -- it's a set of services, not a self-contained development environment like Access.  Out of the box, Microsoft provides you with a report manager and viewer.  In this viewer, they have included simple drop down lists which are basic HTML elements.  There is nothing stopping you from designing your own web page with your own drop downs to call and render an SSRS report.  However, the best solution would probably be to simply write a query to return all three columns separated by a pipe symbol to use as your drop-down description.
vbajock (Programmer)
13 Dec 10 15:52
By experimenting, I found a solution:

Created a list box, stretched it into the half page area, and then populated it with the fields found in the Access report header.

Created another report with just the detail records, using a stored procedure that took a parameter that matched the key field of the list.

Back to main report, added a row to this giant list box.

Dragged my detail table report as a sub report into this row.

Mapped the key field of the list data to the parameter of the sub report table.

Looks exactly like a typical Access report. And they say it couldn't be done!

 
RiverGuy (Programmer)
13 Dec 10 16:55
I didn't read your initial question close enough.  You're not talking about parameter selections.  But yes, you've found that you can easily embed a subreport within a main report.  You don't even have to use a List.  You can use a regular table if you want the clean/grid look, add another row below that, merge the three cells in the new row, and then add the subreport.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close