How can builtin fields in Report Builder be used in Dataset Query?

Question

Hi,

ReportBuilder has builtin fields, e.g. Language or User ID.

How can I use them within dataset's query?

Example: Having a dataset for text translations I want to use the builtin Field "Language" to fill the dataset only with this certain language.

How to write the query for that?

SELECT * FROM TranslationTable WHERE TranslationLanguage LIKE ►►►BuiltInField!Language◄◄◄ ???

Thank you in advance,
Martin

Answer 1

Hello Martin,

create a report parameter (invisible) and assign the build-in function as default value to it.
Write a query with a (named) parameter like @language and then map in the dataset settings => parameter the one created before.

SELECT *   
FROM TranslationTable  
WHERE TranslationLanguage = @language