| :: More Miscellaneous :: show all messages | Post a New Message | Post a Reply |
 Re: More Miscellaneous | Post a Reply |
from: Washington, DC
2. Group ID, what relevance is the ID to a group? When I create a group with an ID the ID does not show up on the main screen. How is the Group ID work?
1 & 2: Group ID is what is used to identify the report groups. It is important when you want to create more than one group of reports and also when you want to control which groups of reports to display.
The Group ID can be the same as the group title or the group number.
By default, the general group has no Group ID. If you want to create more groups you need to add a group ID. You can create your groups with the following values:
Group Title: Client Reports
Group ID: CLIENT
Group Title: Cases
Group ID: CASE
Group Title: Providers
Group ID: PROV 3. Once I create a filter I have to uncheck the old filter and add a new one. Is there a shorted way?
3. Not really, because some reports require more than one filter, so we give the option to uncheck the filters you don't want
4. IF I have a report with two linked tables, how do I add another table with links after the fact?
4. I'm not sure what you mean but you can always create a new report if you need to add more tables.
5. If I create a new report with three tables, what is the syntax to link these three tables? I link two tables with linkA=LInkB so how do I add a third table?
5. That will depend on the relationships that exists amongst the tables.
For example if you have the following three tables:
Products (ProductID, SupplierID, ProductName)
OrderDetails (OrderID, ProductID, Quantity)
Suppliers (SupplierID,CompanyName, ContactName )
You can link them as follows:
OrderDetails.ProductID = Products.ProductID AND Products.SupplierID = Suppliers.SupplierID -------------------------
Ghost