Have you tried changing the database connection in a row instead of creating a new grid?
1 person found this helpful
That worked! Thanks!
Try doing this in 1 Grid. When you insert a new Row in your Grid, left-click once on the Row number to highlight the entire Row (your mouse focus is important here in order to change the connection properties on that one row). In the Properties view pane, note the Database Connection. Click on the search icon where it says Database Connection. You can then Select a Database Connection (or Create), the properties for this 1 row will be the new connection you select here.
Thanks for the detailed response Mike.
The issue with trying it in Grid1 vs Grid2 is that Grid1's DB connection has more dimensions than Grid2's DB connection. I can't change the DB connection to a database with more dimensions because you have to be able to map all dimensions from the existing DB connection (Grid1) to the new DB connection (Grid2). This isn't possible, so instead I have to map Grid2 (less dimensions) to Grid1 (more dimensions). It just ignores the extra dimensions from Grid1. Does that make sense?
Thanks again for your responses. It's very much appreciated.
Thanks Tiffany. Yeah, my reply was a stretch to get 5 pts for a Helpful answer. Glad you were able to figure it out.