Right Pane of Report

I have a report where I have setup a table and am using a subreport for the header and using the Page footer for the footer (Subreports can't be used in traditional Page Headers. I also have a Right pane. What i'd like to do is create a table that will use the space that isn't the header/footer/right pane for the body of a report but I can't seem to figure it out.
Is there any absolute positioning in RS? I'd love to be able to take the right pane (which is just a rectangle with sub-items) and say, please print this at x,y on every page. Am I asking too much?
My alternative approach (which I don't love) is to create an image of the template and use it as a page background, then draw the data over the the image. But that is hard to maintain long-term.
Ideas? Please?
Thanks,
Shawn Wildermuth
http://adoguy.com
http://magenic.comI haven't tried what you're doing yet, but am very interested in it. Are
you using rectangles to size and position elements? I'm finding that
placing items in rectangles gives me much more control over how they render
relative to each other.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Shawn Wildermuth" <swildermuth_at_adoguydotcom> wrote in message
news:%23qiQwt71EHA.3616@.TK2MSFTNGP11.phx.gbl...
>I have a report where I have setup a table and am using a subreport for the
>header and using the Page footer for the footer (Subreports can't be used
>in traditional Page Headers. I also have a Right pane. What i'd like to
>do is create a table that will use the space that isn't the
>header/footer/right pane for the body of a report but I can't seem to
>figure it out.
> Is there any absolute positioning in RS? I'd love to be able to take the
> right pane (which is just a rectangle with sub-items) and say, please
> print this at x,y on every page. Am I asking too much?
> My alternative approach (which I don't love) is to create an image of the
> template and use it as a page background, then draw the data over the the
> image. But that is hard to maintain long-term.
> Ideas? Please?
> Thanks,
> Shawn Wildermuth
> http://adoguy.com
> http://magenic.com

Returning only the Header Row instead of all the relevant rows.

Hi All:

My below sub in application is returning only the Header Row instead of the relevant rows I guess therez problem in my "str" Syntax. However I fail to understand where exactly is it faultering.

PrivateSub btnSearch_Click(ByVal senderAs System.Object,ByVal eAs System.EventArgs)Handles btnSearch.Click

Try

con.Open()

Dim empIDAsString = txtEmpID.Text

Dim FNameAsString = txtFName.Text

Dim LNameAsString = txtLName.Text

Dim strAsString = "Select Emp_ID, Emp_FName,Emp_LName,Emp_Address1,Emp_HNo,Emp_MNo from Emp_Details where Emp_ID='" & empID & " ' Or Emp_LName='" & LName & " ' Or Emp_FName=' " & FName & "'"""Dim da1AsNew SqlDataAdapter(str, con)

da1.Fill(ds, "Emp_Details")

dgEmp.DataSource = ds

dgEmp.DataMember = "Emp_Details"

dgEmp.DataBind()

Finally

con.Close()

EndTry

EndSub

Thanks in Advance for your quick help.

Regards,

Brandy

It looks like you might have one too many extra spaces in your statement. Try this instead:

Dim strAs String =String.Format("SELECT Emp_ID, Emp_FName, Emp_LName, Emp_Address1, Emp_HNo, Emp_MNo FROM Emp_Details WHERE Emp_ID ='{0}' OR Emp_LName = '{1}' OR Emp_FName = '{2}'", empID, LName, FName)

|||

This works... Appreciate your kind help.