473,397 Members | 2,077 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

Hide Column in a cross tab report of vb.net 2010/CRV13

228 100+
Hi all,

Am having a really hard time with Cyrstal Report's cross tab. The report is based on a SQL Server stored proc. and produces the report attached below. The basic idea is get ending balance for previous year (2011), get its ending balance while for the next year (2012) as well. What is needed now is, I need to hide Arrived Items column from the smaller year (2011). The arrived items and annual balance of the smaller year are always the same. If either columns of the 2011 could be hidden in a way, it would be really great.

The parameters for the report are @smallyear and @bigyear. I have tried coloring the columns white but 2012 gets affected as well. The same if I set their width to zero. Anyway to do so?
Attached Images
File Type: jpg crstab.jpg (22.2 KB, 155 views)
Nov 28 '12 #1
1 1702
Rabbit
12,516 Expert Mod 8TB
Please show us the code you've tried so far.
Nov 28 '12 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: HWG | last post by:
Hi All, In sqlplus, what set option is used to show/hide the column name from the sql return? e.g. select * from dual; X
9
by: Don Grover | last post by:
I have a HTML table created using ASP as a web page. ie. HEADING1 HEADING2 HEADING3 etc... data 1 data2 data3 etc and so on How can I toggle hide /...
3
by: Mal | last post by:
Hello.. Is there a property to force a new column in a report. I've looked at moveLayout, newRecord...and am thinking that some combination of those might do it...but how??? I want to test...
3
by: daveS | last post by:
I have come accross the exact same problem as below. The address that was given as a solution cannot be found. Specifically, i need to be able to show labels in only the first column of a report!...
5
by: hasanainf | last post by:
Hi, Need help on this report My report displays as follows Receipt Number Checkout Date Payment Date 13580 30-06-2005 02-07-2005 13581 01-07-2005 02-07-2005
1
by: enak | last post by:
I populate a datagrid by setting the datasource to a datatable. I then, bind them. After that I try to hide the last column but am not able to. I get an error message. Here is my code: ...
1
by: Sorcerdon | last post by:
Hello experts, I am currently opening an excel file from a VB.net application. The excel spreadsheet gets all its data from a Dataset. I need to hide a column form the results. I dont want the...
1
by: ashik478 | last post by:
Hi! I have a problem. I have a table in oracle database with one field is primary key. Now I want to insert data from Datagridview with hide column which contain not null field(this field is...
2
by: Ben | last post by:
Hi, i defined an imagebutton like this: <asp:ImageButton ID="ImageButton1" runat="server" /> Sometimes, the picture must be shown, sometimes not. I did this in code-behind: Dim x As Integer...
0
by: Rich Cote | last post by:
I am new to Crystal Reprorts. I have a main report and a subreport driven off of a value from the main report. I am trying to hide the headers of the main report when the subreport has information....
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.