2. ASPRunnerPro General questions
  3. [SOLVED]  Record doesn't show up on Report Page
This topic is locked
[SOLVED]

 Record doesn't show up on Report Page

 		12/14/2010 2:38:14 PM
ASPRunnerPro General questions
J
 Jay123 author

Hi!
I am using ASP Runner 6.2.
I have an Add Page with a child table. If the child table doesn't have any data (the master table has some data, though) the report doesn't show the entire record at all. Is this how the report page suppose to work? If not, could you pls. let me know what the problem is?
The record shows up on the report when the child table has data on any of its fields. I didn't put any filter or conditions on the report page.
Thanks,

Jay
Sergey Kornilov admin 12/14/2010

Jay,
I'm not sure how you can Add page in report. Reports are for read-only information representation.
I would suggest to post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.
J
 		Jay123 author 12/14/2010

Hi Sergey,
I have posted it in the demo account.
I guess I didn't explain it well.
Basically, I have a table (ie. Table A) which has an add page and this add page contains a child table (ie. Table <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=55082&image=1&table=forumreplies' class='bbc_emoticon' alt='B)' />. I have created a report for that table (Table A with child Table <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=55082&image=2&table=forumreplies' class='bbc_emoticon' alt='B)' /> but the report doesn't show the record of what I have on Table A unless one of the fields of Table B has a data.
Thanks,

Jay
J
 		Jay123 author 12/15/2010

Thanks so much, Jane!
Your advise to change the SQL query from INNER JOIN to LEFT JOIN worked.
Thanks,

Jay