We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

Multiple datasources in 1 band in QuickReport

Jason Sweby
Jason Sweby asked
on
Medium Priority
622 Views
Last Modified: 2013-11-22
I've seen questions here relating to multiple columns in a Quick Report, but I need to place the values of various different tables in a detail band of my report.

Each band has Monday to Friday in it, with each "database text" field containing a certain value relating to a certain day of the week. This has to go ACROSS the screen in a band, like:

Monday | Tuesday | Wednesday | Thursday | Friday

value  | value   | value     | value    | value
from   | from    | from      |  from    | from
table  | table   | table     | table    | table
Comment
Watch Question

Commented:
Hi jsweby,

What about this :

1) Make a new table or query which joins these 5 tables and use this for your qreport band.

2) Use Before print, and put the values of the records of the different tables in there respective text fields (on the qr-form)

I think 1st one is the easiest and the best.

Have fun,
c.u. ZifNab;

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Jason SwebyTechnical Director
CERTIFIED EXPERT

Author

Commented:
Thanks for the reply - we came up with the same answer as you earlier (number 1, building another table to link the other 5),
but I'll give you the points for coming up with it anyway!

J.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.