Subreport Issues

[Cathy F]

I've read all the posts on reports/subreports and I'm still having problems.

Background:  I'm working with OLEDB, an Access database.

Main Report:
SQL:
SELECT Parties.*, Murders.Description
FROM Murders INNER JOIN Parties ON Murders.[CaseNumber] = Parties.CaseNumber;

SubReport:

SQL:

SELECT Suspects.CaseNumber, Suspects.Suspect, Suspects.FirstName, Suspects.LastName, Suspects.Profile, Suspects.Occupation, Players.Party, Players.FirstName, Players.LastName,  [Players].[FirstName] & " " & [Players].[Lastname] AS PName, Murders.Description, Murders.Victim, [Suspects].[FirstName] & " " & [Suspects].[Lastname] AS SName
FROM Murders INNER JOIN (Suspects INNER JOIN Players ON (Suspects.Suspect = Players.Suspect) AND (Suspects.[CaseNumber] = Players.[CaseNumber])) ON Murders.[CaseNumber] = Suspects.[CaseNumber]

The selection criteria is not working and the report is all jumbled.

Thanks for any help. 

[Cathy F]

Here is a sample on what the results look like:

[Ганьков Андрей]

28.07.2016 19:42, Cathy F пишет:

The selection criteria is not working and the report is all jumbled.

Thanks for any help. 

I personally didn't use subreport like you in table, even for a one time. May be Majorsilence Reporting has bug to display it. Please add issue on github, and attache example report. If i will have time, i will see it.

But I didn’t see why you use subreport for this case. May be you can do it, by one SQL query and add it to table of main report.

-- 
Andrey Gankov
Mail:gankov...@inbox.ru 
ICQ: 230-684-976
Jabber:gan...@jabber.ru

[Cathy F]

Hi Andrey,  I'm  using a subreport because the original layout wasn't working.  My Access report layout is as follows:

Case Number:  CASE001   Murder At The Beach    Party:  Party1

The Part of:                                                          Will be played by:
Character name                 occupation                 Actor name
Character name                 occupation                 Actor name

and so forth, with a page break on Party.

The data was from a joined query, characters in a table Suspects, and actors in a table Players.  Party code is in the Players table, occupation is in the Suspects table.  The case description is from Murders table.

When that did not work right, the Case Number/Description/Party was moved to a main report with the data coming from a joined query between Parties table and Murders table.  The subreport was then using a joined query of the Suspects and Players table.  Still no luck.  I did try using a subreport with the information only coming from the Players table (in case the joined query was the issue) and that didn't work.

Now I don't know exactly all of the changes I made, but the report format is looking good, however, the link between report/subreport isn't working because for each row in the Parties table (there are 4), all of the rows in the Players table are listed.

What I want to do is to select a party for the main report and the subreport will print all the rows for that party.

On Friday, July 29, 2016 at 1:37:12 AM UTC-5, Andrey Gankov wrote:

28.07.2016 19:42, Cathy F пишет:

The selection criteria is not working and the report is all jumbled.

Thanks for any help. 

I personally didn't use subreport like you in table, even for a one time. May be Majorsilence Reporting has bug to display it. Please add issue on github, and attache example report. If i will have time, i will see it.

But I didn’t see why you use subreport for this case. May be you can do it, by one SQL query and add it to table of main report.

-- 
Andrey Gankov
Mail:gank...@inbox.ru 
ICQ: 230-684-976
Jabber...@jabber.ru

[Cathy F]

I found this document on a ReportingCloud website and I followed the instructions on the main report. and I get these results:

Messages
OleDbCommand.Prepare method requires all parameters to have an explicitly set type.
at System.Data.OleDb.OleDbParameter.Prepare(OleDbCommand cmd)
at System.Data.OleDb.OleDbCommand.PrepareCommandText(Int32 expectedExecutionCount)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior
behavior)
at fyiReporting.RDL.Query.FinalPass()
at fyiReporting.RDL.DataSetDefn.FinalPass()
at fyiReporting.RDL.DataSetsDefn.FinalPass()
at fyiReporting.RDL.ReportDefn.FinalPass(String folder)
at fyiReporting.RDL.ReportDefn..ctor(XmlNode xNode, ReportLog replog, String folder, NeedPassword
getpswd, Int32 objcount, CrossDelegate crossdel, String overwriteConnectionString, Boolean
overwriteInSubreport)
at fyiReporting.RDL.RDLParser.Parse(Int32 oc)
at fyiReporting.RdlViewer.RdlViewer.GetReport()

[Cathy F]

Query parameters don't work but Filters parameters work.

[Ганьков Андрей]

I seen about subreport in table. Now it works incorrect, when subreport generated difference height. Because in currently architecture of application we can not get height before it draw, but when we render table, we need know height of row, before draw. Now it implemented only for property CanGrow for TextBox. And implementation is very bad and confusing. For good works it should be rewrite completely.
I will try fix it. But it can need more time.

[Cathy F]

I redesigned part of my database.  I've added autonumber keys to all tables to simplify the joins.  Query parameters do not work with Access databases (OLEDB), but I got it to work using the Filter parameters.

On Sunday, July 31, 2016 at 3:18:02 AM UTC-5, Andrey Gankov wrote:

I seen about subreport in table. Now it works incorrect, when subreport generated difference height. Because in currently architecture of application we can not get height before it draw, but when we render table, we need know height of row, before draw. Now it implemented only for property CanGrow for TextBox. And implementation is very bad and confusing. For good works it should be rewrite completely.
I will try fix it. But it can need more time.

-- 
Andrey Gankov
Mail:gank...@inbox.ru
ICQ: 230-684-976
Jabber...@jabber.ru

[Mohamed Cisse]

Hi all, i use majorsilenceReporting recently and i am very happy to find this tools.
I have a question about subReport in table issue. i read message between "Andrey Gankov and Cathy..."
and he Andrey) was talking about fixing this issue.
What is a state of this now??
i need this feature for master - details report where i use subreport in table [detail row] and i have overlap problems on report rendering

thank in advance!!

[Андрей Ганьков]

I did not fix it. For fixing this issue need refactoring big part of engine, to simplefy it. Because now it is very entangled.

I can not find time for this work. We did not use subreport in table for business tasks.

But you can do it self. This is open source project.

 

15.12.2020, 14:16, "Mohamed Cisse" <mohamed...@gmail.com>:

--
You received this message because you are subscribed to the Google Groups "myfyireporting" group.
To unsubscribe from this group and stop receiving emails from it, send an email to myfyireportin...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/myfyireporting/bda129be-5169-47af-9c53-968902ef8073n%40googlegroups.com.

 

 

 

[Mohamed Cisse]

hi 

thank for the reply Andrey, 

But now How can i set my purpose. when i tried to do same thing using list control i have the same issue. 

please can you give some indications to make master - details with majorsilenceReporting. 

thank

[Андрей Ганьков]

I think i can not give you indications. You need dip in code. Unfortunately any calculation height of report items is very complex and smeared on code. I dont know simple solution of issue.

Code have many related issues, with list too. Will need dig and try fixing.

 

15.12.2020, 15:06, "Mohamed Cisse" <mohamed...@gmail.com>:

To view this discussion on the web, visit https://groups.google.com/d/msgid/myfyireporting/6ff70d19-f2ab-47d0-964c-2d7344f0ea46n%40googlegroups.com.

 

 

 

[Mohamed Cisse]

thank Andey for the quick response. 

I understand now, i appreciate your clarification it prevent me not waste more time in research.

I find some trick that i want to share. it is not exactly what i want to do but it can help some one.

in my [SubReport], i use a table control to display detail of my [master data] in main report. 

in this table control(in subreport), i select "page break after" option in table properties. 

->Result, i have for each page in report, master-detail information like i want per page. 

it is not exactly what i want earlier but hope can help some one!!

Thank for all,

Mohamed C.