I am using the Report Designer for the first time. I have created a report and it is not allowing me to fetch the data from server. I am using local database credentials to get the data and display in the report and it is working fine. I want this report to work with the application other developers have created because the designer in the Visual Studio does not provide the options and is not that well organized as Report Designer is.
Is this all possible or I am just wasting my time over this issue ?