Forum Discussion
Create a new table
Hi Anonymous
If you just want to display this data in a visual table within the report you can create a many to one relationship between the your dates table and second table as shown below:
Once done you can then display all of the dates from the dates table along with all of the other neccessary information from the second table.
Please let me know if this helped solve your problem.
Hi Anonymous
Are you looking to achive something like this?
If not would you be able to post an example of what you want your table to show?
kinda, have this table
and need to join this one
but need to repeat each of the lines for example Canada 30 times for each date just the way is done on the first picture, for all of the lines on the second table (second picture)
Hi Anonymous
If you just want to display this data in a visual table within the report you can create a many to one relationship between the your dates table and second table as shown below:
Once done you can then display all of the dates from the dates table along with all of the other neccessary information from the second table.
Please let me know if this helped solve your problem.