Swapping source BI query in crosstab

I currently have several crosstabs in a report with highly formatted summarized fields, thus I do not want to have to delete the crosstab and insert another one to change my data source. I’m wanting to swap out the current source BI query with another one. I go to Database Expert and add another source. I then go to my crosstab expert and remove the report field in my columns that references the old BI query. I then go to Available Fields in my new datasource and choose the field from my new BI query. I go to the Customize Style tab and the column shows the field from my new BI query. I then go to the group options for my new column and select/sort my columns. As soon as I do this, I go back to the Customize Style tab and it now shows the column with my old BI query. So anytime I go in and make changes to my columns, it resorts to the previous query as my data source. Is there any way to get around this and substitute a new BI query without deleting all my current crosstabs that reference the previous BI query? Again, I do not want to do this because I will lose a ton of formatting.
Thanks.


mikegbuff (BOB member since 2009-05-28)

try using the template under Report then Template Expert. You only need to call the report with the same format of the report you are using.

I hope this will help :smiley:


nahtanoj :philippines: (BOB member since 2009-07-08)