Jump to content
  • 0

Compound Reporting To Display 2Nd Query?





I have a simple online app that is a collection of salespeople and their clients. Clients can have more than one salesperson.


I want to create a report that finds all the clients of a particular salesperson, and displays those clients along with a list of the other salespeople on each of that list of clients.


I have the site on www.whoworkswithme.com  where I put up a simple version using a single table. But now, I am trying to split it out into 3 tables: Person, Client, and "Coverage" (which is the Client & salespeople) because I will eventually have users registering on their own and adding clients. 


As I said, I am trying to set-up a report where you search for a person (using their email address) and see ALL of a person's clients, and the ALL of the other salespeople who also are on those clients. In some cases, the person will have clients that have other salespeople.

The goal of the app is to allow each salesperson to see the other people who are associated with his clients.

So I want to search on an email address, find all the clients that the email/Person is associated with, then find all the other salespeople who are associated with those clients. Then display the clients in order, with a list of the other salespeople for each client

I created a View that combines the three tables into one and it looks correct (with multiple client lines for multiple salespeople), then I created a search & report on that View. But when I search by a person's email, I only get a list his/her clients, but not the other salespeople on those clients.

I have a search and report version online as an example of what I am looking for, but it only works for looking up a single client at a time to see who else is on that client. It is currently on www.whoworkswithme.com  But it uses the original single table. If you go to the site and select "Your Team" and search "Alstom" (client or project) you can see what the results should look like (for a single client, but I want multiple clients displayed like that).

All I can get right now is a list of a salesperson's clients, but it does not list the other associated sales people. (see the Me@Work" tab and search for "jbush@nefitness.com"...this list clients, but also should also display other salespeople under each client)


I am not sure if this can be done in one report, or needs to be some type of nested query/report. 


Thank you in advance for and advice!



Link to comment
Share on other sites

7 answers to this question

Recommended Posts

  • 0

So far, I simply passed a parameter (Client ID) to a second report, via a link "(Click here to see the Vendors") in the first report. That is ok for my first go, but clunky as I would actually like to get both reporting datasets onto one page, in groups by the first report...(but I guess you know that by now! ;-)


Thanks for all your help!

Link to comment
Share on other sites

  • 0

Did you try to create a view to join tables http://howto.caspio.com/views/creating-a-view-to-join-tables.html? This way then you can group by as well, or you can try to embed the second report page in the footer of the first report in details page (you need to get iframe code and pass the parameter through the source link of the frame)

Link to comment
Share on other sites

  • 0

I need to create a report that shows all the other people who are also associated with a salesperson's clients. This is a directory of who else knows my clients. 


The problem I seem to have with this report is that it essentially and eventually requires a report that sequences and combines multiple search inputs and reports into one. I am looking for a list from a table, then need to have each one of those items on the list get their own mini report inside a larger report. 


I have:

  1. Vendor table
  2. Client table
  3. Client:Vendor relationships table (many Vendors on each Client)

First I want to search the Client:Vendor table on a single Vendor and look up all the Clients she has.


Then, I want to take her Client list and search the same Client:Vendor table and get a report of all the other Vendors who also have each customer (grouped by Client).



So it is a two-step process, where the second step is multiple, sequential search terms, with the output in one report.


(I'm trying to think if there is a view that I could create for the second, but it still comes down to searching sequentially and creating multiple, stacked reports, if I see this and Caspio's capabilities correctly)


You can see my initial, one-by-one crude effort at www.whoworkswithme.com


  1. -> Click the "Clients and Contacts" button
  2. -> search for "randi@randifrank.com" to get her customer list
  3. -> click on "Gateway Community College" to see one of the individual reports that I would want in the previous results page


I need to combine 2 & 3 so that the user can see the list of Clients with all the Vendors under each, without having to click one-by-one. 


(There are refresh and new tab issues for making the form easier to navigate, but most get eliminated once I get the final report right)

Link to comment
Share on other sites

  • 0

What you can do is to create a a report for customers and then another report for vendors. Get the iframe deploy code of vendor report and deploy it in an HTML Block in Client report. You need to pass the ID of the client through the link of the frame source to the next page. This way for each client you will have a list of vendors.

Link to comment
Share on other sites

  • 0

MayMusic - I am in need of this solution too. I deployed a "child" tabular report as an iframe in an HTML block of the "parent" details page and included the unique ID in the iframe code but the child report is not receiving the ID parameter from the parent report. Could you offer more details on how to get the two reports to be linked and displaying on the same page? 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...