Forum Discussion
Solved
Paginated Report - Pulling Fields After Creation
Does anyone know how to add another field into a paginated report after it is created, and from same dataset as other fields already in the report? Like you forgot to pull something you needed.
Hi Kim_Maiden ,
Thanks for the update. You seem to have added the column but are receiving blank values. This is probably because the field isn't being retrieved properly from the source.
The following are a few things you should check.
- Ensure the query included in your dataset actually contains the column which is missing. If you are using DAX or MDX then it might be necessary to alter the query, so the query is modified to include the new field.
- Once you have added your column ensure it has been correctly mapped to the dataset field of Report Builder.
- Try to refresh the dataset within Report Builder to ensure it's pulling the latest structure from its source.
If your company is not using SQL, can you let us know what data source you're working with? This will allow us to be more specific.
If my response solved your query, please mark it as the Accepted solution to help others find it easily!
And if my answer was helpful, I'd really appreciate a 'Kudos'.
I did get it to let me add the column but it is not bringing back any data, just blank fields.
What is your source? what is your dataset contains SQL query, DAX, MDX, ... ?