Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
This is the forum to discuss the Wrox book Professional SQL ServerReporting Services by Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney; ISBN: 9780764568787
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old July 1st, 2004, 07:47 AM
Authorized User
 
Join Date: Jun 2004
Location: Peterborough, Ontario, Canada.
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default Convert Wizard Report to Custom Report

I have been trying to get a report with grouping, it is a report from a survey which shows the:

      Question Group Title
Question
    Answer 1
    Answer 2
    Answer 3

Question
    Answer 1
    Answer 2
    Answer 3

        Question Group 2 Title
....

etc.

I can get the report to show the question group title properly (at the beginning of the group of questions) but I cannot get the answers to group properly.

I decide to see if the Wizard could produce this report. It can. HOWEVER, I use stored procedures and in order to get my report to work instead of just declaring the name of the proc and declaring the parameters (as report parameters) I am forced to use the exec command and hard-code parameters.

When I do that I get the report I want. That proves it can be done.

I have gone back into the Wizard created report and added report parameters but when I try to force my data set to use them I just get an error and it won't work.

I have also tried to look at the form created by the wizard and see how it created the groups (to duplicate the method) but I can't get the same result.

So, how can I use the wizard to create reports based on stored procedures with parameters, then go back and get the report to recognize and use parameters when I add them to the report.

Is that confusing enough?

Thanks.

Sandy Murdock MCP
__________________
Sandy Murdock MCP
  #2 (permalink)  
Old July 1st, 2004, 10:38 AM
Authorized User
 
Join Date: Jun 2004
Location: Peterborough, Ontario, Canada.
Posts: 50
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I did not succeed in modifying the report created by the wizard in the way that I wanted.

What I did do however, was take the report created by the wizard (which I could not control via parameters) and copy the table portion from that report to one that I created with the appropriate parameters. It works.

Sandy Murdock MCP
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Showing custom tooltip in crystal report skdevre Crystal Reports 0 August 1st, 2007 08:36 AM
SSRS Custom Report iSheahan BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 February 8th, 2007 12:52 PM
Report File Format Convert Problem wscheiman Access VBA 1 January 9th, 2006 11:36 AM
Convert Crystal Report 8 to PDF rsamanthif Crystal Reports 1 January 2nd, 2006 03:53 AM
Datasets and Custom Assemblies Rendered in Report dillig BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 August 11th, 2004 08:39 AM



All times are GMT -4. The time now is 06:25 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.