Forum Discussion
how to modify sql after report is created
Hi experts,
I created a report, quite simple, just a matrix: as a source I used a query from sql server, where I had.
Where memberId = 123123
Because I wanted to work with a smaller set... now I finished it, and I want to remove that 'where' clause and get the full query... is there any way of editing the sql query?
the only way I see is deleting and importing all the data again....
- Anonymous8 years ago
You can click on Edit Queries in the top Ribbon, select your query in Query Editor, and double click on Source in the Applied Steps section to edit your custom SQL
2 Replies
- AnonymousNot applicable
You can click on Edit Queries in the top Ribbon, select your query in Query Editor, and double click on Source in the Applied Steps section to edit your custom SQL
- jean_e_lambertRegular Visitor
thanks a lot I had been struggling to find this!