How do you create report parameter in Report Builder? I want to create a new field and add to the report. When I run the report, it'll prompt for entering the value.
Thanks in advance!!
Brian wrote a blog article about this: http://blogs.msdn.com/bwelcker/archive/2006/07/29/682444.aspx
-- Robert
This appears:
Student Activity
1 Track
2 Track
4 Volleyball
I would like to see:
Student Activity
1 Track
2 Track
3 NULL
4 Volleyball
What settings need to be tweaked to make this happen?
Thanks for your assistance.Hi
What query are you using to generate this report? I created 2 tables: student, activity. Not all students have activities. If I use the following query:
select * from student
left outer join activity on student.i = activity.i
where i = student id in both the tables,
I get the list of students, activities (even for students who dont have activities mapped on the activity table)
The Left Outer Join operator returns each row that satisfies the join of the first (top) input with the second (bottom) input. It also returns any rows from the first input that had no matching rows in the second input. The nonmatching rows in the second input are returned as null values. If no join predicate exists in the Argument column, each row is a matching row.
Is this what you were looking for?
Thanks
|||Within Report Designer you can create a query and specify any type of join you need. This is IN REPORT BUILDER, where you are not able to specifiy the type of join you would like to use. The query is generated from the report model and dragging fields into the design area.Thanks for your response though.|||Hi Chris
Can you try this out and let me know if this works?
Create a report model and within the data source view, right click and add a NEW NAMED QUERY, here you can specify a query with joins. Once this query is created, create the report model. This should also list the query that you have created, apart from the 2 tables.
Now from Report Builder, select this datasource and drag/drop your query.
Remove the columns that you dont want (I just had student id and activity)
and run report.
This will give you all records, even the students who dont have activities listed.
If you are just using a report model, I think you need to edit that and add a query into that, so you can use it in your report builder to get the required data.
Thanks.|||
Actually, you don't need to create a named query to do this. You can do it in the Report Model. In your example, you need to set Cardinality=OptionalMany on the role from Student to activity. This tells RB that not all students have activities (so don’t do an inner join or you might lose a few).
I have been generating report models for users to use with Report Builder and there is no data when they select the model. I noticed that the tables I chose did not have a primary key and when I chose a different table, with a primary key, and generated a model from it, then there was data for the user to use in Report Builder.
Is there a documented work around or will I need to set a primary key on each table?
You don't need a physical PK on each of your tables. Instead, open up the DSV in your Report Model project, right click each table, and choose "Set Logical Primary Key" and the appropriate field. You'll then need to rebuild the model. See if this works for you!|||Thanks Russell! That worked just fine after I rebuilt the model.Guys,
What is "GetUserID()" function returns when the report server, report builder and everything is using windows authentication?
http://msdn2.microsoft.com/en-us/library/ms156292.aspx
Enkh.
Just use USERID
|||"Just use USERID" What do you mean? USERID? Is that a global variable, windows authentication username?
Enkh.
|||More details:
USER!USERID
|||I don't really understand it. Can you please just describe it for me or someone? Is it windows authentication username or some kind of ID?sqlThanks Bob,
It's the obvious answers...
Is there an API or a way to consume a Report Model? I want to try and roll my own simple web-based / thin-client Report Builder without using the ClickOnce control.
Thanks,
--jason
Semantic query is an xml document with the schema desribed here: http://msdn2.microsoft.com/en-us/library/ms155870.aspx
Semantic model is another xml document: http://msdn2.microsoft.com/en-us/library/ms155776.aspx
You can get existing semantic model using RS SOAP API GetUserModel. Create reports in RB or use Report Model data source in Report Designer as clue/samples.
You can execute semantic query on its own (without report) using RS URL API ExecuteQuery
Have fun! :)
Cool. I'll check it out. Thanks!
--jason
|||Hi Jason,Were you able to write your own report builder ? Please let me know how would I query different fields of an entity from a report model that has been published on the reporting service programmatically and make them available to a user in web application and to enable him/her to create a custom report ?
Thanks,
Rashid Khan
Is there an API or a way to consume a Report Model? I want to try and roll my own simple web-based / thin-client Report Builder without using the ClickOnce control.
Thanks,
--jason
Semantic query is an xml document with the schema desribed here: http://msdn2.microsoft.com/en-us/library/ms155870.aspx
Semantic model is another xml document: http://msdn2.microsoft.com/en-us/library/ms155776.aspx
You can get existing semantic model using RS SOAP API GetUserModel. Create reports in RB or use Report Model data source in Report Designer as clue/samples.
You can execute semantic query on its own (without report) using RS URL API ExecuteQuery
Have fun! :)
Cool. I'll check it out. Thanks!
--jason
|||Hi Jason,Were you able to write your own report builder ? Please let me know how would I query different fields of an entity from a report model that has been published on the reporting service programmatically and make them available to a user in web application and to enable him/her to create a custom report ?
Thanks,
Rashid Khan
hi everyone,
I created a report model and deployed it. When I open the rpt builder on web I get the following error.
'The selected data source does not have and content available'
Seemed like it would be a easy issue, but I cannot retrieve any data in the rpt model. The datasource I'm using does work for rpts not associated with the rpt model. Any suggestions? It seems like I've missed a step. Thanks, Lisa
If there is no primary key defined, you can build the model, but no contents. Do you have primary key defined?sql
