Lets Discuss about Row Groups in SSRS 2010 Right Click on Row Groups Details Group properties is visible Choose Visibility Option Check One "Show or Hide based on an expression" put some expression like =iif(Count(Fields!USERSSN.Value)>1,true,false) Click Ok
How Could you add parameter in the SSRS Right Click on the dataset and choose properties then you able to view the DataSet Properties you will found a parameter option,click on it and add parameters after added parameter all the parameter will view at the Report Data in parameter section. in this section you can choose the parameter data type,allow velu blank.allow null value,allow multiple value,you can able to parameter visibility. ************************************************ by using Query option you can choose to use Query or Store procedure ************************************************ Byusing DataSource properties you can change the Name,Connection type,connection string ************************************************ How to use Report Viewer to view the output of the report. ReportViewer1.ShowCredentialPrompts = false; ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; ReportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://sntdev-08-sql1/ReportServer"); ReportViewer1.ServerReport.ReportPath = @"/BenefitsOnlineReports/DependentOverAgeReport"; ReportViewer1.ServerReport.Refresh(); the above code in .cs page and the below code for aspx page***********************************
http://www.shabdkosh.com/
ReplyDeleteGood English Dictionary from English to Hindi
http://dictionary.reference.com/
ReplyDeleteGood English to English Dictionary.
http://www.cfilt.iitb.ac.in/~hdict/webinterface_user/dict_search_user.php
ReplyDeleteEnglish to Hindi Dictionary
http://www.merriam-webster.com/top-ten-lists/top-10-phrases-from-shakespeare/cruel-to-be-kind.html
ReplyDeleteGood dictionary
Select O.name objectName, C.name ColumnName from sys.columns C
ReplyDeleteinner join sys.objects O ON C.object_id=O.object_id
where C.name like '%HSA_AMOUNT%' order by
USING THIS QUERY YOU CAN FIND A COLUMN NAME IN THE DATABASE
Short Cut key..........
ReplyDeletehttp://msdn.microsoft.com/en-us/library/xte2hh6a(VS.71).aspx
Lets Discuss about the design of the report
ReplyDelete1.BorderColor-LightGrey, LightGrey, LightGrey, LightGrey, LightGrey
2.Border Style:- Solid, Solid, Solid, Solid, Solid
3.Border Width:-0.5pt
4.Backgroundcolor:-Gainsboro
5.Font Color:-Black
6.Font:-Arial, 8pt, Normal, Normal, None
7.Padding:-2pt, 2pt, 2pt, 2pt
Design of Table cell in Reporting Service
1.padding:-2pt, 2pt, 2pt, 2pt
2.BorderColor:- LightGrey, LightGrey, LightGrey, LightGrey, LightGrey
3.Border Style:-Solid, Solid, Solid, Solid, Solid
4.BorderWidth:-0.5pt
5.BackgroundColor:-Gainsboro
6.Color:-Black
Font:-Arial, 8pt, Normal, Normal, Non
Lets Discuss about Row Groups in SSRS 2010
ReplyDeleteRight Click on Row Groups Details
Group properties is visible
Choose Visibility Option
Check One "Show or Hide based on an expression"
put some expression like
=iif(Count(Fields!USERSSN.Value)>1,true,false)
Click Ok
How Could you add parameter in the SSRS
ReplyDeleteRight Click on the dataset and choose properties
then you able to view the DataSet Properties
you will found a parameter option,click on it and add parameters
after added parameter all the parameter will view at the Report Data in parameter section.
in this section you can choose the parameter data type,allow velu blank.allow null value,allow multiple value,you can able to parameter visibility.
************************************************
by using Query option you can choose to use Query or Store procedure
************************************************
Byusing DataSource properties you can change the Name,Connection type,connection string
************************************************
How to use Report Viewer to view the output of the report.
ReportViewer1.ShowCredentialPrompts = false;
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://sntdev-08-sql1/ReportServer");
ReportViewer1.ServerReport.ReportPath = @"/BenefitsOnlineReports/DependentOverAgeReport";
ReportViewer1.ServerReport.Refresh();
the above code in .cs page and the below code for aspx page***********************************
The C# Station Tutorial
ReplyDeleteIntroduction to Classes
http://www.csharp-station.com/Tutorials/Lesson07.aspx