I have created a dashboard with lots of tables. The dashboard contains data of around 40 of my customers. With loop and reduce via Publisher 40 reports are generated and the customers use their own physical dashboards. Some customers have a lot of data. The export to excel exceeds 65K rows and thus a CSV is created. This causes a lot of problem as linefeeds for example are screwing the csv. Mind you they use the AJAX client.
So Nprinting on demand seems like the solution to me. But I run into a problem with the value for connection.
I created a report with the designer. As all loop and reduce dashboard contain the same objects I picked the table I want to export, but I had to do this via a selection of one of the connections. I created connections to all dashboards by the way. Then in my dashboard for the reporting extension I use a function for the connection id to fetch the name of the organization. It corresponds to the connections I created. The export works this way for the organization I used to create the report, but not for others.
Is there a way to have 1 reports in designer that is applied to a connection based on the dashboard the user is using?
I tried adding all connections to the report, and it will execute for other organizations, but as the tabel was selection from one organization that report is shown instead of with the data of the executing organization.
I also thought of applying the report from he master file (all customer data) and the current selections will take care of the rest showing the filtered data. But as that file is 900Mb and will take up around 8gb of ram I am worried if 3 users execute a report that it will open QV in the background 3 times with that amount of memory. Or would it just open 1 and if the reports is specified as not close the connection that it will stay open for various requests against it?
Hope to get some insights. I would hate to create per organization reports for those with bigger data sets.
Also does the reporting queue show the reports created from that dashboard or all reports created from various dashboards/ nrprinting project file?