Move adhoc reports between domains

[alman73]

I   uploaded adhoc report from dev to prod which has data source with a differant database schema but with the same table. And the report raise exception.  I believe it’s because of every view in domain has schema prefix and adhoc report use it.  Is there any possibility to move adhoc reports between domains with a different schema names ? 

Thanks in advance

[elizam]

You cannot move an Ad Hoc view from one Domain to another, but you might see if you can use the same Domain, but change the data source. I cannot guarantee this will work - it's very sensitive to any changes.  Look at this section in the user guide for some help - also read the following sections on referential integrity:

http://community.jaspersoft.com/documentation/jasperreports-server-user-guide/editing-domain

 

[alman73]

Thanks for your answer. But I asked about adhoc report - not a view.  And if I choose another datasource with a different DB schema  for the domain – adhoc reports that had been created earlier will stop working.