Jump to content

reportmaker

Members
  • Content count

    11
  • Joined

  • Last visited

Community Reputation

0 Neutral

About reportmaker

  • Rank
    Member
  1. Hi I just want to ask if we are able to create sections in a custom report as we can create sections in the report generator. I have to display same fields for different packages so the query will vary depending on the package. how to implement this in one report rather than creating one report for every package.
  2. I want to add a admin only custom field to a product group so that it is available for all the products in that group.
  3. how to create a report of clients whose status is active but they dont have any active product
  4. I am trying to create a report using report generator module it works fine if there are two conditions but when I add a third one it gives me no results. Is it that i can only enter two conditions in the report generator. If ay anyone has used more that two successfully please suggest any solution. Also is there any way I can have a OR condition or it just works for the AND condition
  5. reportmaker

    self join using report generator

    Thanks for the reply I want to make this report using report generator module .but it is giving table alias error because i cant have two tables with the same name .
  6. I have a requirement to extract two field values from the customfieldvalues table for all the clients. The table stores the custom fields values with the clients numbers. How can i join the table by itself to extract values for two fields in the report generator or can it be done by only using custom php code without the report generator. I have tried joining the clients table with the table customfieldvalues and then by itself.It displays table alias error.
  7. reportmaker

    sorting not working

    I have made a report using clients and hosting table to display all clients with their product nextduedate. The nextduedate appears to be sorted when i edit the report but when i view the report the next due date is not sorted.
  8. I have made a report using clients and hosting table to display all clients with their product nextduedate. The nextduedate appears to be sorted when i edit the report but when i view the report the next due date is not sorted.
  9. Hi There are two custom field added to a product eg website address and email. These get values in when a new order for a product is made.I have filled the values for the existing clients using clientservices.php page because they were not having these values earlier relevant to those products. I want to make a report to display these values. I assume that all the custom field values are stored in tblcustomfieldvalues. but when i try to make a report these values dont show up. how can i add these values in the tblcustomfieldvalues table to fetch in a report if there is no new order. Are new rows only added in this table when there is new client or new order if yes can somebody please suggest a solution.is this a bug or not.
  10. I want to create a report per product.eg. it is product xyz the report should display the company name , url, next due date. which table display the products ordered as in the orders table there is just order number but how to find what products have been ordered in that order.
  11. Hi I want to create a report using 3 tables which are joined and the end result should be filtered according to this condition If the column has the value value = "a" or value ="b" or value ="c" or value ="d" (there are total 7 values I want to exclude 3 values) it should be displayed otherwise not
×

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated