How To Pull Record Count Info From Multiple Report Datapages Into One Report Datapage?

[Berean]

How do I pull record count info from multiple report datapages into one report datapage?

 

I have 2 objectives with this question:

 

1. I have dozens of report datapages and I would like to count and display the number of records in each datapage into one master datapage.  
2. I would like to embed the count for each datapage on separate images-graphic in this master datapage

My overall purpose with this datapage is to show changes in the reports (representing a geography) in a table of contents/index with nice graphics representing each geography.

 

I'm new to this so i hope I was able to articulate the problem.  Thanks for any help.

[Jan]

Hi Berean,

 

My idea is:

1) Create the table with locations names.

2) Create a Tabular Report, select the table from step 1 as a DataSource.

3) On Results page add a Calculated field and enter SQL query like:

SELECT SUM(name_of_the_field_with_id_in_view) FROM _v_viewname WHERE name_of_the_field_in_view_where_locations_are _stored = target.[@field:locationfieldname]

 

Please, enter your values instead of green values.

 

I hope, it helps.

Let me know, if anything is not clear.

[iren]

Hello Berean,

 

Welcome aboard   

 

Do you want to display just the numbers of records of each DataPage in one or you want to embed each Datapage to one?

Do DataPages use conditions for records?

Could you please provide the link to your DataPage for investigation?

[Berean]

Hello Berean,

 

Welcome aboard   

 

Do you want to display just the numbers of records of each DataPage in one or you want to embed each Datapage to one?

Do DataPages use conditions for records?

Could you please provide the link to your DataPage for investigation?

 

Hi Iren.

 

Thanks for asking.  I just want to display the number of records for each report-datapage (Their source is a Views datapage) in one report-datapage.  My report datapages filter for parameters (the same field for each report - location).

 

I have not yet created the new datapage which will pull the numbers until I've figured out how to go about it.  This new datapage will be the one to contain image thumbnails which will display the number of records per report per location, respectively.

 

Berean

[iren]

Hi Berean,

 

Tell me please, do you use the Lookup Table for Views? If so, whether this is one Lookup Table for all Views?

 

Iren

[Berean]

Hi Iren, I'm using a table (containing records) for Views but not a Look Up table.

[Jan]

Hi Berean,

 

How do you select location for every record? Do you enter, for example, the name of city?

Are the same locations used in all Views?

[Berean]

Hi Jan,

 

No, I don't use Look Up tables for locations as it could be a city, a town, an island, or a street.  The location field is entered by keyboard input and location-reports are created when we find something interesting (after the fact).

[Jan]

Hi Berean,

 

I apologize for many questions

Does every Report DataPage use only one location?

Does all Report DataPage use the same table? I mean, their Views used the same table or tables.

[Berean]

Hi Jan, No problem at all.  Yes, every report page uses one location.  And all report datapages use the same Views page.  

[Jan]

Maybe, you can use the Data Grouping feature, group the data by the location field?

[Berean]

Hi Jan, the problem with Data Grouping is that it appears in the results page and with individual records shown.  I would just like to display summaries - Count number for each location.  A preview summary page in place of a search form would be useful before the search results are shown.

[Jan]

Hi Berean,

 

Could you create a table for locations? I mean the table that contains only two fields: location_id and location.

You can add new records, when a new locations are added.

Also you can use this table as the Look up table for other tables.

 

I have one solution for this case, if the creation of the new table works for you.

[Berean]

Hi Jan, thank you sure I'm open to any ideas