Victor Charles
asked on
Help with seeing vertical and horizontal lines of a table and setting background and text colors of eve and odd rows
Hello,
How do I see the vertical and horizontal lines of a table and How do I set background and text colors of even and odd rows in my report?
Thanks,
victor
How do I see the vertical and horizontal lines of a table and How do I set background and text colors of even and odd rows in my report?
Thanks,
victor
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The expression goes into the BackgroundColor property which you'll find as one of the properties of a textbox (i.e. cell in a tablix).
BTW: are you using the SSRS designer or .NET code (I noticed you've got the ASP.NET topic in your question as well as SSRS).
BTW: are you using the SSRS designer or .NET code (I noticed you've got the ASP.NET topic in your question as well as SSRS).
ASKER
I am using using SSRS, but thought they also use the same type of report (RDLC) with SQL.
I have another question, perhaps you can help me answer it on the same post or I can open another post.
Previously my data was in a table format with multiple records displayed, now I need to display one record per page, how do I modify my code.
For example:
Table Format:
Country Address Zip Item
BEL xyz 112 Car
CAN xyz 112 Car
DEU xyz 112 Car
FRA xyz 112 Car
Now I need
Record 1 of 4
Country BEL
Address xyz
Zip 112
Item Car
Record 2 of 4
Country CAN
Address xyz
Zip 112
Item Car
Record 3 of 4
Country DEU
Address xyz
Zip 112
Item Car
Record 4 of 4
Country FRA
Address xyz
Zip 112
Item Car
Below is the code I am currently using to display the data using a datatable:
Dim FilteredDT As DataTable
Dim DV As New DataView(dt, SearchCriteria, Nothing, DataViewRowState.CurrentRo ws)
FilteredDT = DV.ToTable
Dim reportDataSource As New Microsoft.Reporting.WinFor ms.ReportD ataSource( )
reportDataSource.Name = "MyDataSet_Links"
reportDataSource.Value = FilteredDT
ReportViewer2.LocalReport. DataSource s.Clear()
ReportViewer2.LocalReport. DataSource s.Add(repo rtDataSour ce)
ReportViewer2.LocalReport. Refresh()
ReportViewer2.RefreshRepor t()
Thanks,
Victor
I have another question, perhaps you can help me answer it on the same post or I can open another post.
Previously my data was in a table format with multiple records displayed, now I need to display one record per page, how do I modify my code.
For example:
Table Format:
Country Address Zip Item
BEL xyz 112 Car
CAN xyz 112 Car
DEU xyz 112 Car
FRA xyz 112 Car
Now I need
Record 1 of 4
Country BEL
Address xyz
Zip 112
Item Car
Record 2 of 4
Country CAN
Address xyz
Zip 112
Item Car
Record 3 of 4
Country DEU
Address xyz
Zip 112
Item Car
Record 4 of 4
Country FRA
Address xyz
Zip 112
Item Car
Below is the code I am currently using to display the data using a datatable:
Dim FilteredDT As DataTable
Dim DV As New DataView(dt, SearchCriteria, Nothing, DataViewRowState.CurrentRo
FilteredDT = DV.ToTable
Dim reportDataSource As New Microsoft.Reporting.WinFor
reportDataSource.Name = "MyDataSet_Links"
reportDataSource.Value = FilteredDT
ReportViewer2.LocalReport.
ReportViewer2.LocalReport.
ReportViewer2.LocalReport.
ReportViewer2.RefreshRepor
Thanks,
Victor
Hi Victor,
Please follow the advice posted in below links for your solution:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/a42cae15-c166-4deb-9ba4-eb95d09d390f/
http://forums.asp.net/t/1428587.aspx/1
(a good one)
http://www.sqlchick.com/entries/2010/9/11/displaying-fixed-number-of-rows-per-ssrs-report-page.html
Mark as answer if helped.
Enjoy!!
Please follow the advice posted in below links for your solution:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/a42cae15-c166-4deb-9ba4-eb95d09d390f/
http://forums.asp.net/t/1428587.aspx/1
(a good one)
http://www.sqlchick.com/entries/2010/9/11/displaying-fixed-number-of-rows-per-ssrs-report-page.html
Mark as answer if helped.
Enjoy!!
ASKER
Thanks!
If you have other questions (such as the one in comment 37799753) it's better to open other questions instead of putting them in an already open one... That's more in line with the Problem/Solution philosophy.
You'll also attract more experts looking at the problem in question because they can then focus on just that one particular issue.
You'll also attract more experts looking at the problem in question because they can then focus on just that one particular issue.
ASKER
Got it. Thanks.
ASKER
I am fairly new at this, will look for the borders property and set it as you suggested.
where do I enter =IIf(RowNumber("YourDataSe
Thanks,