Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
 Posted - 2007-02-19 : 01:45:56
|
| Good day everyone. I am new with reporting services and I have read the configurations/setups of it in google. I am making a report in c#.net(windows application) through reporting services. (Reports should be shown in report viewer). Someone told me that the reports must be created directly in sql. Is it possible? If so, how to communicate c# and sql?Please help me. Thanks.Ron |
|
|
jhermiz
3564 Posts |
Posted - 2007-02-19 : 10:17:58
|
quote:
Originally posted by cwtriguns2002
Good day everyone. I am new with reporting services and I have read the configurations/setups of it in google. I am making a report in c#.net(windows application) through reporting services. (Reports should be shown in report viewer). Someone told me that the reports must be created directly in sql. Is it possible? If so, how to communicate c# and sql?Please help me. Thanks.Ron
If you are using visual studio.net 2k3 / 2k5 you will need to create a "Business Intelligence Project". The project can then have reports included within it. That project can be merged with your entire C# project. Its very simple, the report is then created using the Report Designer of VS.net (the business intelligence project will ask whether you want a report, a wizard, a data source, etc.). The actual query comes from the SQL Server box, not the report format or style.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
Posted - 2007-02-19 : 20:24:52
|
quote:
Originally posted by jhermizIf you are using visual studio.net 2k3 / 2k5 you will need to create a "Business Intelligence Project". The project can then have reports included within it. That project can be merged with your entire C# project. Its very simple, the report is then created using the Report Designer of VS.net (the business intelligence project will ask whether you want a report, a wizard, a data source, etc.). The actual query comes from the SQL Server box, not the report format or style.Jon
Yes, Im using VS.net 2k5 and "Business Intelligence Project" in "Report Model project" but i don't know the difference of it from the report wizard project and report server project. Does this make a difference? What is preferable to use?In your last statement "The actual query comes from the SQL Server box". Sorry I can't get the idea. What you mean by SQL server box? I tried to do reports in Report wizard with parameters(e.g. select * from customers where custid = @ID). But it automatically creates a textbox for input of ID in the report. I have a combobox in my C# windows application that filters the ID of all customers, what i want is If i select an ID in combobox, report will be displayed in report viewer. the parameter should be from the combobox of C# not in the textbox of the report. Thanks.Ron |
|
|
|
|
|
|
|
|
Reporting Services