How to display the dataset column value in text box in the parameter page of the report

Hello,

I have created a report, containing a dataset with only one column. When i run the report, I would like to show that dataset result in textbox in the parameter page of the report.

Example:
Dataset: Select name from table where id = 2; Output = Sai

Now i would like to display that output "Sai" in the textbox by default in the parameter page when i run that report.
bobbb
I have tried in many ways but i am unable to show it. Atlast i have tried with listbox but the listbox is showing blank (until the user select that value in the list) - For this i applied "is required" it was working good in my local birt viewer, but still showing the same blank listbox with red line border.

Could anyone please suggest any idea? as it was an urgent requirement.

Thanks,
Sai

Thanks & Regards,
Sai

Best Answer

  • Accepted Answer

    There "bobbb" is a typo error please ignore it.

    Thanks,
    Sai

    @Sai Krishna said:
    Hello,

    I have created a report, containing a dataset with only one column. When i run the report, I would like to show that dataset result in textbox in the parameter page of the report.

    Example:
    Dataset: Select name from table where id = 2; Output = Sai

    Now i would like to display that output "Sai" in the textbox by default in the parameter page when i run that report.
    bobbb
    I have tried in many ways but i am unable to show it. Atlast i have tried with listbox but the listbox is showing blank (until the user select that value in the list) - For this i applied "is required" it was working good in my local birt viewer, but still showing the same blank listbox with red line border.

    Could anyone please suggest any idea? as it was an urgent requirement.

    Thanks,
    Sai

    @Sai Krishna said:
    Hello,

    I have created a report, containing a dataset with only one column. When i run the report, I would like to show that dataset result in textbox in the parameter page of the report.

    Example:
    Dataset: Select name from table where id = 2; Output = Sai

    Now i would like to display that output "Sai" in the textbox by default in the parameter page when i run that report.
    bobbb
    I have tried in many ways but i am unable to show it. Atlast i have tried with listbox but the listbox is showing blank (until the user select that value in the list) - For this i applied "is required" it was working good in my local birt viewer, but still showing the same blank listbox with red line border.

    Could anyone please suggest any idea? as it was an urgent requirement.

    Thanks,
    Sai

    @Shweta Parihar said:
    I have created a sample report where the dataset result is shown as a parameter default value. I am using List Box for the Parameter and to populate this List Box I selected "Dynamic" option in "Edit parameter" window and set the parameter default value here. Attaching the report for your reference.

    Thank you Shweta....

    Thanks & Regards,
    Sai

Answers

  • I have created a sample report where the dataset result is shown as a parameter default value. I am using List Box for the Parameter and to populate this List Box I selected "Dynamic" option in "Edit parameter" window and set the parameter default value here. Attaching the report for your reference.

Sign In or Register to comment.