I'm using Visual Studio Community 2017 to create SSRS reports on a SQL 2014 installation and I'm running into two issues that I hope someone here could shed some light on.
1) SSRS modifies the field name when a table with columns that match an existing column name when it is added to a data set. For example: Customer table has an ID and a Name field, Sales table has an ID and Product field). If start with just the Customer table I can add the ID field to the report. When I add the Sales table to the dataset the field name for the Customer ID field changes from 'ID' to 'Customer_ID' (to differentiate it from 'Sales_ID'). This causes an error with any references to 'ID' which I have to find and correct one-by-one.
Is there any way to make SSRS always use the Table_Field nomenclature for every table and field so this doesn't happen? Is there a short-cut method to get SSRS to update all references when a field name is changed by the query designer when a table is added?
2) Is there any way to get SSRS to sort Field names in the picklist in alpha order? It seems to default to table ordinal order which is difficult to search through in datasets with a lot of columns.
Thanks,
