Hi all,
I created an SSRS report depending on the CustCollectionLetterTrans table. To run the query I also created a query with datasource CustCollectionLetterTrans.
In the report there should be a grouping upon a extended field called MyDepartment and AccountNum... There are no error during compilation and deploying the eport. But on runtime a error occurs:
Unable to add the table field 'MyDepartment' to the query source 'CustCollectionLetterTrans'. Table field 'MyDepartment' does not exist on table 'CustCollectionLetterTrans'.
But the field is available in the query as well as in the extended table CustCollectionLetterTrans.
I tried to
- recompile several times
- synchronise the database several times
- restart IIS
- delete the report on report server and deploy it again
but nothing helps...
What else do I have to do/can I try to solve the problem?