Create report with data from other Map Services

Permanently deleted user

31 Maj 2016 19:04

This seems like a simple question, but I would like to create a report with data that is being pulled from different Map Services in my map, not data links. Is this possible?

 

I have a Water Well Report that is pulling data from the water well map service. But I'd also like to include location information for that well in the report. I have a Supervisor District Map Service and a Parcel map service. Is there a way to pull this information into my Water Well Report? Possibly through a sub report? Thanks!

0

• 

  Tom Neer

  31 Maj 2016 19:14

  If you are creating the Report in Workflow, query what you need and push all the tables into the report or subreports. If you are using Feature Reports, you will need to use a Transform Workflow which gives you the same capability.

  0
• 

  Permanently deleted user

  31 Maj 2016 19:18

  Is there a way to do it in just the Report Designer?

  0
• 

  Tom Neer

  31 Maj 2016 19:27

  Yes. How is your C#?

  0
• 

  Tom Neer

  31 Maj 2016 19:41

  Checked with one of our developers who has been doing a lot of Reports. He executes SQL queries in Workflows and passes them into a report, so we don't have an example of direct connecting to a database in ActiveReports but there are database connections that can be made (please note these are direct database connections, not using map services).

   

  He says his biggest difficulty is the lack of documentation because the version of ActiveReports used by Essentials has been deprecated by Grape City. Using the Workflows or Transform Workflows has been his path of least resistance. 

   

  Here is an example of a script to remove second address line from a Mailing List if it is empty: public void MailingLabelDetail_Format() { //Set up points to set textbox locations System.Drawing.PointF p1 = new System.Drawing.PointF(); System.Drawing.PointF p2 = new System.Drawing.PointF(); System.Drawing.PointF p3 = new System.Drawing.PointF(); p1.X = .063F; p1.Y = .375F; p2.X = .063F; p2.Y = .563F; p3.X = .063F; p3.Y = .75F; //Restore Defaults ((DataDynamics.ActiveReports.TextBox)rpt.Sections["MailingLabelDetail"].Controls["OWNERADDR1"]).Visible = true; ((DataDynamics.ActiveReports.TextBox)rpt.Sections["MailingLabelDetail"].Controls["OWNERADDR2"]).Visible = true; ((DataDynamics.ActiveReports.TextBox)rpt.Sections["MailingLabelDetail"].Controls["OWNERADDR2"]).Location = p2; ((DataDynamics.ActiveReports.TextBox)rpt.Sections["MailingLabelDetail"].Controls["CityStZip"]).Location = p3; string desc = Convert.ToString(((DataDynamics.ActiveReports.TextBox)rpt.Sections["MailingLabelDetail"].Controls["OWNERADDR1"]).Value); if (desc == "Null" || desc.Length == 0 || desc.Length < 1 || desc == " ") //See if address line 1 is empty { // Make things invisible. The renderer will not draw invisible elements, they will be as good as gone. ((DataDynamics.ActiveReports.TextBox)rpt.Sections["MailingLabelDetail"].Controls["OWNERADDR1"]).Visible = false; //Move things up ((DataDynamics.ActiveReports.TextBox)rpt.Sections["MailingLabelDetail"].Controls["OWNERADDR2"]).Location = p1; ((DataDynamics.ActiveReports.TextBox)rpt.Sections["MailingLabelDetail"].Controls["CityStZip"]).Location = p2; } else { desc = Convert.ToString(((DataDynamics.ActiveReports.TextBox)rpt.Sections["MailingLabelDetail"].Controls["OWNERADDR2"]).Value); if (desc == "Null" || desc.Length == 0 || desc.Length < 1 || desc == " ") { // Make things invisible. The renderer will not draw invisible elements, they will be as good as gone. ((DataDynamics.ActiveReports.TextBox)rpt.Sections["MailingLabelDetail"].Controls["OWNERADDR2"]).Visible = false; //Move things up ((DataDynamics.ActiveReports.TextBox)rpt.Sections["MailingLabelDetail"].Controls["CityStZip"]).Location = p2; } else {} } }

   

   

  0

Du måste logga in om du vill lämna en kommentar.