Report Builder/ Report Designer

  • I am trying to creat a report with two different frames, but don't know how to create a second frame. I am not sure if frame is the right word in SQL. I am trying to make a report with two different outputs on the same page. I would like one output on the top of the page and the second output on the bottom. Please Help...Thanks for your help in advance.

  • What are you dumping your output to?

    I'm guessing Tables.

    Each table is assigned to its own Dataset.

     

    Create 2 different datasets one for each output.

    then plop down 2 tables on the designer.

    Edit the properties for each table and assign the dataset to the appropriate table.

    thats it.

     

  • I am retrieving data from several tables and need to generate a report with two different queries. One query results need to be near the top and the other near the bottom of the same page.  I like to try to do this in Report Builder and having trouble with the layout. How can I make this happen?

  • And you can't use the query as a table, because? (I'm asking this seriously - I've not used SSRS at all, but the need for my knowing it is less than 4 months away....

  • I have never used this builder, but used Oracle's Report Builder which is much different. I am trying to figure this out cause my company wants to have this process to be available on multiple databases. I hope there is an easy solution that I must be overlooking.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply