Skip to Content
author's profile photo Former Member
Former Member

split a report into several reports


I have a report which contains several workers' data. I need to split the report for each worker(few excel files which all of them will be saved on one folder). I'm able to save one big excel for all the workers (using the "reporting agent") but how can I make a special file for each worker? (There are more than 100 workersÂ…)

Please Advice,


Message was edited by: David Cohn

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 05, 2006 at 12:56 PM

    Hi David,

    In the document I read you yesterday (How to precalculate for off-line usage) there is a part related to Control Query. If you use this Control Query, based on a simple query with all your workers, the system will produce a single file with all workers and a report for every single worker.

    Try and let me know please.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Riccardo,

      I went through the document you've mentioned (How to precalculate webtemplates for offline usage), but for me it is not clear in every point. The two queries were created according to the document, just as the webtemplate. Whenever I execute the webtemplate in a browser, I get the message "No precalculated data for DATAPROVIDER_2". DATAPROVIDER_2 is the control query. Am I doing something totally wrong, or is it my misunderstanding of the document?

      Thanks in advance,


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.