Inherited reports

Hans · October 2014

I know Inheritance does have some limitations.
Like, do not use parameters in the base report.

I am not happy with that and try to create a workaround.
Because we do have hundreds of reports. A lot of them are a look a like of another report..
In the base reports we like to do the general settings by using parameters (for example 'show_price').
In the inherited reports we change only some fields,groups, sorts.

I am thinking about a workaround:
1. I Load the report by code
2. Detach the report by cocde
3. Give the parameters the right value.

Questions:
Is it possible to Load a report and Detach the Base report by code?
If not. Do you have plans to remove the limitations of inherited reports?

Hans · October 2014

With the code below it is possible to use a basereport with parameters and totals.
After loading the report by code, the basereport is resetted and all double parameters and totals are removed.
Then it works fine.

using (Designer frDesigner = new Designer())
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â report1.BaseReport = "";
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â report1.Designer = frDesigner;
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â report1.Designer.SetModified(this, "EditReport");
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â string xmlFR = report1.SaveToString();
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â string xmlHdr = xmlFR.Substring(1, xmlFR.IndexOf("\r\n") + 1);
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â xmlFR = xmlFR.Substring(xmlFR.IndexOf("\r\n") + 2);
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â XDocument xdoc = XDocument.Parse(xmlFR);
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â //remove double Parameters and Totals
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â xdoc.Root.Elements("Dictionary").Elements("Parameter")
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â .GroupBy(s => (string)s.Attribute("Name"))
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â .SelectMany(g => g.Skip(1)) // select all nodes from group except first one
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â .Remove();
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â xdoc.Root.Elements("Dictionary").Elements("Total")
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â .GroupBy(s => (string)s.Attribute("Name"))
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â .SelectMany(g => g.Skip(1)) // select all nodes from group except first one
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â .Remove();
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â string xmlResult = xmlHdr + xdoc.ToString(SaveOptions.DisableFormatting);
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â xmlResult = xmlResult.Replace("\r\n", Environment.NewLine);
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â report1.Clear();
Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â report1.LoadFromString(xmlResult);

Inherited reports

Comments

Leave a Comment