473,320 Members | 2,145 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to repeat Sub-Report for each row in data set that contains the parameter field?

103 100+
I have a Main report that has a sub report. The dataset has 5 rows returned when I execute the query. In the data return I have a field (we'll call Field1) and I set the parameter for the sub-report as field1, but the sub-report only executes for one row. I then created a list and added the subreport to that list and set the list grouping on the field. However, I am not getting the sub-report to execute for the other data rows. Any suggestions or point me to the correct way of doing so would be greatly appreciated.
Sep 30 '12 #1
4 8911
Rabbit
12,516 Expert Mod 8TB
I don't know what you mean by you set the parameter field in the sub report. You need to use a ripe source that returns all routes that you need and then set up the master/child relationship and the sub report filtering will happen automatically.
Sep 30 '12 #2
Brian Connelly
103 100+
Needed to put the main dataset in a list control that would then go through each row. For each row, then the sub report would execute with the parameter field from that row being passed.
Oct 25 '12 #3
Brian Connelly
103 100+
Thank you for your comment.
Oct 25 '12 #4
Hi Brian,

You can do it by creating a Tablix ( that is mapped on the specific dataset that store your parameter)

You can then Create a group based on your parameter, In the row of your Tablix you can put inside a subreport that will contain as parameter your grouping already setted parameter for the row.

You'll then Get the report on each page for each row from the parameter.
May 21 '17 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

16
by: Stephen Saunders | last post by:
Hello, I am new to this news group. Please forgive me if this has been asked before. In my VB application, I have next and previous command buttons. I would like to be able to hold the left...
10
by: Frances Del Rio | last post by:
I've been wondering for a while whether you can do this... let's say I define a class thus: ..myClass {font-family:verdana,sans-serif; font-size:11px; color:#006699; text-decoration:underline}...
2
by: A & K Merchandise | last post by:
I am new to coding and therefore don't have much experience. My problem is this: I have a date field and other fields within a table. I want to schedule a certain event but to have it REPEAT...
14
by: Roland Hall | last post by:
Since I'm not getting any response from the community, I'm reposting this under my managed account. I've turned my web.config friendly error messages off and it may be easier to view what I'm...
5
by: Dennis | last post by:
I have a Sub Main from which I show a Form: Public MainForm as New Form1 <STAThread()> Public Sub Main() MainForm.Show() Application.Run() End Sub The MainForm (Form1) shows ok and runs ok...
5
by: Jay | last post by:
In a sub procedure how do I recall/restart the sub and maintain the position in a loop? Eg (this doesnt work how I need it to work)... sub Get_Language() 'code here to prompt the user to do...
3
by: Jana | last post by:
Good morning, Access gurus! I'm having a brain fart and can't seem to wrap my head around the logic for this problem, so I'm hoping someone out there can help me out. Here's my situation: I...
4
by: DDmUSA | last post by:
I am using a CSS-based glossy menu that I found on Dynamic Drive. Using Internet Explorer 7, the sub-menus appear towards the right once the mouse is pointing over the top level. Using Firefox, all...
2
XedinUnknown
by: XedinUnknown | last post by:
Hi! I am new to this forum, but not new to web design and programming. Nevertheless, I have never tried to use PNG so extensively in my pages. here's the problem. First, I have found that the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.