Report Parameter List from Field

How can I have a report parameter show a list of employee names from the
employee table fields, (lastname, firstname) is this possible?
Thank you
FrankDo you use Business Intelligence studio to update reports, if so, create
query for employees table (Select lastname + ', ' + firstname as EmployeeName
from tblemployees order by lastname, firtsname", then create report parameter
(menu bar <Report><Report Parameters> ) that uses the qry for its "available
values" data.
"Frank" wrote:
> How can I have a report parameter show a list of employee names from the
> employee table fields, (lastname, firstname) is this possible?
> Thank you
> Frank|||loulou,
I am using Business Intelligence and did develop a second dataset called
Employees. I have the following written:
SELECT LastName, FirstName, Active_Employee, Employee_ID
FROM Employees
ORDER BY LastName, FirstName
In the Report Parameter I am using Available Values and have selected the
Employees Dataset, Employee_ID Value Field and Employee_ID Label Field.
This brings back a list of the Employee ID Numbers when I go to Preview. I
would also like to include last name and first name except that it errors
out.
Thank you
"loulou" wrote:
> Do you use Business Intelligence studio to update reports, if so, create
> query for employees table (Select lastname + ', ' + firstname as EmployeeName
> from tblemployees order by lastname, firtsname", then create report parameter
> (menu bar <Report><Report Parameters> ) that uses the qry for its "available
> values" data.
> "Frank" wrote:
> > How can I have a report parameter show a list of employee names from the
> > employee table fields, (lastname, firstname) is this possible?
> >
> > Thank you
> >
> > Frank|||loulou,
I set everything correctly now and it works great, thank you!
SELECT LastName + ',' + FirstName AS Expr1, Active_Employee, Employee_ID
FROM Employees
ORDER BY LastName, FirstName
"loulou" wrote:
> Do you use Business Intelligence studio to update reports, if so, create
> query for employees table (Select lastname + ', ' + firstname as EmployeeName
> from tblemployees order by lastname, firtsname", then create report parameter
> (menu bar <Report><Report Parameters> ) that uses the qry for its "available
> values" data.
> "Frank" wrote:
> > How can I have a report parameter show a list of employee names from the
> > employee table fields, (lastname, firstname) is this possible?
> >
> > Thank you
> >
> > Franksql

Report Output

Normally, the report always display like the follow:
Department Employee No. Average Salary
---
HR 15 11250
IT 25 15510
Sales 5 10000
But I want to display the record as the follow: (the record is shown
horizontally, instead of vertical)
Department HR IT Sales
Employee No. 15 25 5
Average Salary 11250 15510 10000
How can I do that ?May Liu,
Use a matrix instead of a table, your scenario is exactly what they are for.
If your query finds a new department it will add another column automatically.
Regards
Chris
"May Liu" wrote:
> Normally, the report always display like the follow:
> Department Employee No. Average Salary
> ---
> HR 15 11250
> IT 25 15510
> Sales 5 10000
> But I want to display the record as the follow: (the record is shown
> horizontally, instead of vertical)
> Department HR IT Sales
> Employee No. 15 25 5
> Average Salary 11250 15510 10000
> How can I do that ?
>

Report Organization

I am taking over a RS solution from an ex employee and looking for some
report organization help.
I see you can have a shared datasource with RS.
In the solution there are about 20 projects. Each project contains reports
that are displayed in a folder seen off Report Manager. Is this the proper
way to organize reports -- through projects? Is there a way to have
IIS/Report Manager folder structure to appear in the solution explorer?
Or do you have to create the structure manually? Any help would be
appreciated.
Thanks.Yes very much the right way for you to maintain is using "Projects", moreover
I suggest you can add one more thing as well. i.e. Source control like VSS
integration so that all your reports are very well managed. Regarding your
2nd question it is a "No".
Amarnath
"Brian Shannon" wrote:
> I am taking over a RS solution from an ex employee and looking for some
> report organization help.
> I see you can have a shared datasource with RS.
> In the solution there are about 20 projects. Each project contains reports
> that are displayed in a folder seen off Report Manager. Is this the proper
> way to organize reports -- through projects? Is there a way to have
> IIS/Report Manager folder structure to appear in the solution explorer?
> Or do you have to create the structure manually? Any help would be
> appreciated.
> Thanks.
>
>

Report Model, which approach?

Hi All,

I'm a newbie to Report Model and not able to find some conceptual information, Can you guys answer following:

I’ve

Employee [Name]
->Employee_Days [Day] (1-*)
->Employee_Day_Activities [Activity_Type, HoursSpent] (1-*)

schema and a generated model out of it. Now I’ve few report requirements which will be developed based on Report Model. These Reports needs aggregate of All similar activities and the hrs spent and it'll be shown with every employee. Like Employee Xyz has spent 14 hrs total on Sick Activity, which will be shown as

Employee Sick Hrs Maternity Hrs WorkHrs
Xyz 14 0 20

Now i need to know the approach to develop it like i'v to ways in my mind

- create 3 custom fields(Sickhrs,Maternityhrs,Workhrs) in the Employee Entity(model), so that managers can create reports like above by simple drag and drop

- leave model as it is.. just create more descriptive fields in all the three table and let managers do the activity grouping etc to develop report like above..

Which approach should i follow? Moreover can you point me to some conceptual info like how report model works..etc..

regards
farazIt seems microsoft people are not interested in Report Model :)|||

I'd suggest creating filtered aggregates for these categories in the Employee entity in your report model (your first approach). Please see this post for more info:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=941599&SiteID=1

Report Model, which approach?

Hi All,

I'm a newbie to Report Model and not able to find some conceptual information, Can you guys answer following:

I’ve

Employee [Name]
->Employee_Days [Day] (1-*)
->Employee_Day_Activities [Activity_Type, HoursSpent] (1-*)

schema and a generated model out of it. Now I’ve few report requirements which will be developed based on Report Model. These Reports needs aggregate of All similar activities and the hrs spent and it'll be shown with every employee. Like Employee Xyz has spent 14 hrs total on Sick Activity, which will be shown as

Employee Sick Hrs Maternity Hrs WorkHrs
Xyz 14 0 20

Now i need to know the approach to develop it like i'v to ways in my mind

- create 3 custom fields(Sickhrs,Maternityhrs,Workhrs) in the Employee Entity(model), so that managers can create reports like above by simple drag and drop

- leave model as it is.. just create more descriptive fields in all the three table and let managers do the activity grouping etc to develop report like above..

Which approach should i follow? Moreover can you point me to some conceptual info like how report model works..etc..

regards
farazIt seems microsoft people are not interested in Report Model :)|||

I'd suggest creating filtered aggregates for these categories in the Employee entity in your report model (your first approach). Please see this post for more info:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=941599&SiteID=1