Showing posts with label shown. Show all posts
Showing posts with label shown. Show all posts

Wednesday, March 28, 2012

Report designer

In a RD, i have 2 dataset, one of them consist of two field (id and name) by which the name will be shown as a parameter. When a user select from the combo box, how do I enable the id of the this dataset to be link up as a 'parameter' to another dataset which is a query to retrieve the result?

In another words instead of using the parameter 'name' i would like to implicitly link up the id instead of the name which is shown to the user.

Thanks.

Regards

Alu

In Report Parameters, you set the

Value Field to be ID

and the

Label Field to be Name

A bit like this

<Prompt>Select Hierarchy Group</Prompt>

<ValidValues>

<DataSetReference>

<DataSetName>H_Groups</DataSetName>

<ValueField>id</ValueField>

<LabelField>List</LabelField>

</DataSetReference>

</ValidValues>

Where id is the parameter passed to the query & List is the values displayed for the user to choose from in the Listbox

|||

thanks!

Regards

Alu

sql

Monday, March 12, 2012

Report builder cannot be shown on other user login

Dear all specialists,

I am encountering a situation that the report buider feature cannot be shown on other user login. Would you guide me to solve this issue ?

Thanks for your help

Gary Ho

Gary,

For your user login, you will have to make sure that they have "Report Builder" under the "Edit Role Assignment". You will find this in your folder/properties area.

Ham

|||

Hi Ham,

Thanks for your feedback and comments. The user profile under "Edit Role Assignment" already ticked the "Report Builder". Would you have any idea ?

Cheers,

Gary