I`m modifying a report now. Is there a way i can view name,city,st,zip of a location based on location ID on the reprt header? We have a table called loaction for all our locations. In my Dataset i have a column called Locationid.. Currently the report has a sub report just for the name,address,city and state for location. My question can i not just creat a locationID parameter and when Id is entered a user will also see the name,address of the location ID.? Please helppppppppFM

Hi Farhan, Does the dataset of main report contains details (name,city,st,zip) of the location or only location id? If the dataset of main report only contains the location id, and the location id is passed to the subreport for displaying more details, one possible workaround is to merger the dataset of the subreport to the main report dataset. After that, we can also retrieve the location details in the main report. If anything is unclear, please feel free to ask. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Tony, The dataset of main report contains details (name,city,st,zip) of the location or only location id? does not have all these columns. I was thinking of adding 2 dataset the 2nd one being for location. What i need to know and what i was thinking is i have used function called weekday in this report creation and i was able to get the outcome in my report footer like this. What I did was, put a textbox in my report and set it as Hidden. Then i went to Properties, go to Visibility tab and select Initial Visibility to Hidden. Now in the expression . =WeekDay(Globals!ExecutionTime) Now on Page Footer - I used the expression ="Printed On " & FormatDateTime(Globals!ExecutionTime, DateFormat.ShortDate) & " " & WeekDayName(ReportItems!textbox00.Value) & " " & Right(Globals!ExecutionTime, 11) I could be totally wrong in using this technique but i thought there might be. select name,city,st,zip from location where locationid=@locationid. But its just another dataset right i do get an error message when i run the report. An error occurred during local report processign The definition of the report is invalid The 'Tablix11' is invalid. The value for Datasetname property is Missing What does this mean ? ---------------------------------------------------------------------------------------------------------------------------------- FM

I have resolved this issue with expression. My query for the report was actualy a View.. so i just added a join to my view with Location table with the columns in the select statement. Then inserted a textbox into my report and used a expression to list the all the location columns next i inserted a column into my report hearder and used another expression to getmy the desired result. WORKS great. Thank you for all your help.FM