Register and join over 40,000 other developers!
Recent Topics
-
Tekken 7
IsrealJones - Mar 22 2021 07:21 AM
-
The Game You Are Waiting For?
WendellHarper - Dec 06 2020 01:21 PM
-
Quora and Reddit Backlinks
WendellHarper - Dec 06 2020 01:14 PM
-
Delete account
pindo - Jul 23 2020 01:33 AM
-
New to the community
iwinx - Jul 17 2020 12:02 PM
Recent Blog Entries
Recent Status Updates
Popular Tags
- networking
- Managed C++
- stream
- console
- database
- authentication
- Visual Basic 4 / 5 / 6
- session
- Connection
- asp.net
- import
- syntax
- hardware
- html5
- array
- mysql
- java
- php
- c++
- string
- C#
- html
- loop
- timer
- jquery
- ajax
- javascript
- programming
- android
- css
- assembly
- c
- form
- vb.net
- xml
- linked list
- login
- encryption
- pseudocode
- calculator
- sql
- python
- setup
- help
- game
- combobox
- binary
- hello world
- grid
- innerHTML

3 replies to this topic
#1
Posted 29 November 2012 - 10:19 PM
I was trying to print a crystal report with crystal report view in VS2008 for custom paper size and failed .. I was wondering can do the same thing with success using SSRS facility (Reporting service in SQL server 2008 without crystal reports) with the help of Microsoft Report Viewer rather than crystal report viewer on VS 2008 , if so any good reference for a beginner in SSRS and Microsoft Report Viewer development would be very helpful.
#2
Posted 29 November 2012 - 11:04 PM
This is for windows application issue ... so I LIKE to know good reference for a beginner in SSRS and Microsoft Report Viewer development
N.B . Just now got the news that Microsoft Report Viewer supports Crystal Report too , so any sample code or tute for Microsoft Report Viewer with Crystal Report is value to me.
thanks
N.B . Just now got the news that Microsoft Report Viewer supports Crystal Report too , so any sample code or tute for Microsoft Report Viewer with Crystal Report is value to me.
thanks
#3
Posted 30 November 2012 - 07:49 AM
I understand sql server reporting is independent from crystal reports.
About Microsoft report viewer, i think this link might help you:
Report writer video tutorial (youtube)
About Microsoft report viewer, i think this link might help you:
Report writer video tutorial (youtube)
#4
Posted 30 November 2012 - 08:12 AM
Report Viewer is fairly easy to use.
I built a generic report viewer, which is a page with a report viewer on it, I then pass the report name that I want to show as a parameter in the url e.g.
I also send report parameters as key value pairs in the url, then iterate through the Request.QueryString.Keys to retrieve them and add to the report parameters.
this allows me to display any report + params from a single url.
E.g.
Report name = /OBP_Airline_Report
Parameter called AirlineCode gets the value "BA"
I built a generic report viewer, which is a page with a report viewer on it, I then pass the report name that I want to show as a parameter in the url e.g.
protected void Page_Load(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request.QueryString["ReportName"].ToString())) { ReportViewer1.ServerReport.ReportPath = Request.QueryString["ReportName"].ToString(); addParameters(); } }
I also send report parameters as key value pairs in the url, then iterate through the Request.QueryString.Keys to retrieve them and add to the report parameters.
private void addParameters() { ReportParameter[] reportParams = new ReportParameter[Request.QueryString.Keys.Count - 1]; int paramCount = 0; foreach (string key in Request.QueryString.Keys) { if (key.ToString() != "ReportName") { reportParams[paramCount] = new ReportParameter(key.ToString(), Request.QueryString[key].ToString()); ReportViewer1.ServerReport.SetParameters(reportParams); paramCount++; } } }
this allows me to display any report + params from a single url.
E.g.
http://xx.xx.xx.xx/reportviewer/showreport.aspx?reportname=/OBP_Airline_Report&AirlineCode=BA
Report name = /OBP_Airline_Report
Parameter called AirlineCode gets the value "BA"
There are two ways to write error-free programs; only the third one works.
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download