Thank you so much...that's just want i needed... Thanks!!!

Thanks....that's a good option to do so. Thanks!

I have another small question regarding this: select substring(inventoryId,1,Charindex('-CE',InventoryID)) from Inventory work if all the inventoryID contain -CE, however there're some inventoryID that doesn't contain -CE and for those that doesn't contain -CE i want to select the whole field. My SQL statement is really big, if i use If..Else statement then it's like if InventoryID like '-CE' begin .....the whole nine yard of select statement... else .....another nine yard of select statement.... i was wonder if you can use if within select statement...what i picture are: SELECT *, (inventoryid without -CE for those that contain -CE) FROM Inventory I hope you understand my question. Thanks!

Let me clarify my question for you: This option is possible to do in Crystal report where you can add another column and choose a direction to print your data (if you want the data to display across then down or down then across). However, I did see option that you can increase the column number in SSRS when you create RDLC, but i didn't see anywhere that you can determine the printing direction and i'm just trying to find out if they have this option in SSRS (i'm trying to create a client report definition RDLC using VS2008 with C#). I thought maybe I'm looking for this option in a wrong place, since in crystal report this option seem to be out of sight too. Also, the reason I ask this question again this forum because i thought that the reason i didn't get any response last time was maybe because i asked question in a wrong type of forum & since this is topic associate more with SSRS, I ask again in here.

In crystal report, you can select the printing direction in Layout tab between "Across then Down" and "Down then Across." For Ex: I have a dataset with 2 column:

id Name
1 Jim
2 Jess
3 John
4 Jane
5 Joey

I want the result to print like this:

id name id name
1 Jim 2 Jess
3 John 4 Jane
5 Joey

How can i do this in local RDLC report or is it even possible? Please help/advice. I'm really stuck on this. Thanks in advance!!!!

Thank you....the substring function work without -2 at the end. Thanks again!!!

Hi, I need help with selecting part of column value. Say that I have a database that return me a InventoryID InventoryID as123-CE123daf235 23d45543-CE23432 234dave-CEj324lio I want to select everything before -CE, i couldn't use Substring() function because each value have a different character id. can anyone advice me how to do this??? Thanks in advance!!!

In crystal report, you can select the printing direction in Layout tab between "Across then Down" and "Down then Across." I was wonder how to do this in local RDLC report or is rdlc even have this option?

I created a custom control textbox in WinForm which have another value field called "fullValue" which is a little different than the .text value. Is there a way where I can make it to where when I mouse over this textbox, it show fullValue as a tooltip? Any help would be highly appreciated, thanks in advance!

yeh...when it display. i connect it to the datagrid, but i couldn't find a way to set the width of the column in there.

I create a dynamic table using the code below (c#), but I couldn't figure out how to set the column width (in column3 comments). DataTable tbl; DataColumn col; tbl = new DataTable(); col = new DataColumn("column1"); tbl.Columns.Add(col); col = new DataColumn("column2"); tbl.Columns.Add(col); col = new DataColumn("column3 comments"); tbl.Columns.Add(col); tbl.AcceptChanges(); DataRow r; r = tbl.NewRow(); r["column1"] = "This is 1"; r["column2"] = "This is 2"; r["column3 comments"] = "Comments is really long & I need to set the width for this"; tbl.Rows.Add(r);

Thanks for your reply. I came up with another idea....but still need a little guidance. Okay, so if my childForm1 is maximize then i launch Form1 by itself, not in MDIParent(frmParent) and if I want to launch childForm2 from Form1 but make it in MDIParent, Maximize and close childForm1. Is it possible? frmChild2 Child2 = new frmChild2(); frmParent Parent = new frmParent(); Child2.MdiParent = frmParent.MdiParent; Child2.WindowState = FormWindowState.Maximized; Child2.Show(); foreach (Form childForm in frmParent.MdiParent.MdiChildren) { if (childForm != Child2) childForm.Close(); } break; But it didn't work.

I'm developing a WinForm using C# and VS2005. I was wonder if it is possible to open up a childForm1 in maximize window of MDIparent and launch childForm2 on top of childForm1, but still keep childForm1 as MAXIMIZE. Here's a big picture. childForm1 > childForm2 (childForm1 Maximize and childForm2 on top) What I'm looking for is the code to keep childForm1 maximize and childForm2 launch on top. Please please please please please......advice!!!! Thank you!:~

Well, I just want an expander function like how WPF have it, but not sure how to create that in WinForm?

Yes, In my WinForm, I want to create a function where i can expand and collapse each sections. Right now I have it by using UserControl and Panel, then each time a user hit the button it hides the Panel. However, the way I have it does not work so well because I'll then have to create a user control for each sections and one form and run to 10 sections. Please advice.:(

I had a chance to learn WPF for a little while and found a useful feature which I want to create in WinForm, but not sure how to do so. I was wonder if there's a way to create an expander (just like how it work in WPF) in WinForm? Thanks...!:-D tant tant :doh: