How to change report page settings

Is there a way to reset the page margins for all new
reports? I would like to reset them to allways be .5".
Also is there a way to create a new template?
ThanksPosted to the Wiki...
http://www.ReportingServicesFAQ.com/ow.asp?PageMargins
Help build the Wiki!
--
Reporting Services Articles, Forums, Blogs and Wiki Community
www.ReportingServicesFAQ.com
donald wrote:
> Is there a way to reset the page margins for all new
> reports? I would like to reset them to allways be .5".
> Also is there a way to create a new template?
> Thanks

How to call an image via code behind

I'm running ssrs 2005 and want to write a function in the code in the page
something like this:
Public Shared Function ShowImage(val as integer) AS Image
IF val = 4 Then
Return apply.png
ELSE
Return nothing
END IF
End Function
Where apply.png is an image in the report project folder (source=external)
How can I do this?
--
moondaddy@.newsgroup.nospamI found a solution.
Basically, if a condition is true then I want to display the image. so I
put the following iff function in the images visibility property's hidden
section.
=IIF(Fields!VP_qpcCap.Value = 4,False,True)
I suppose if I had more complex logic, I could run a function in the code
behind and have it return true or false. then call that function in the
visibility property's hidden section.
"moondaddy" <moondaddy@.newsgroup.nospam> wrote in message
news:%23MMR56TPIHA.4740@.TK2MSFTNGP02.phx.gbl...
> I'm running ssrs 2005 and want to write a function in the code in the page
> something like this:
> Public Shared Function ShowImage(val as integer) AS Image
> IF val = 4 Then
> Return apply.png
> ELSE
> Return nothing
> END IF
> End Function
> Where apply.png is an image in the report project folder (source=external)
> How can I do this?
>
> --
> moondaddy@.newsgroup.nospam
>|||On Dec 12, 11:44 pm, "moondaddy" <moonda...@.newsgroup.nospam> wrote:
> I found a solution.
> Basically, if a condition is true then I want to display the image. so I
> put the following iff function in the images visibility property's hidden
> section.
> =IIF(Fields!VP_qpcCap.Value = 4,False,True)
> I suppose if I had more complex logic, I could run a function in the code
> behind and have it return true or false. then call that function in the
> visibility property's hidden section.
> "moondaddy" <moonda...@.newsgroup.nospam> wrote in message
> news:%23MMR56TPIHA.4740@.TK2MSFTNGP02.phx.gbl...
>
> > I'm running ssrs 2005 and want to write a function in the code in the page
> > something like this:
> > Public Shared Function ShowImage(val as integer) AS Image
> > IF val = 4 Then
> > Return apply.png
> > ELSE
> > Return nothing
> > END IF
> > End Function
> > Where apply.png is an image in the report project folder (source=external)
> > How can I do this?
> > --
> > moonda...@.newsgroup.nospam- Hide quoted text -
> - Show quoted text -
1. Add an Image object to your Report
2. Set the Value expression to "=Code.ShowImage( Fields!
VP_qpcCap.Value )
3. Change the ShowImage function to return a String
4. Change the Return line to Return "apply.pjm" (put it in double
quotes)
-- Scott

How to call a stored procedure in asp.net

I have created a stored procedure only with an insert statement in sql server 2005.

How can i call this stored procedure through code in ASP.NET page using vb.

i want to pass one parameter that comes from a text box in asp.net page.

my emailid is:g12garg@.yahoo.co.in pls reply.

Thank you

Gaurav

dim conn as new sqlconnection("Your connection string here")

dim cmd as new sqlcommand("Your stored procedure name here",conn)

cmd.CommandType=CommandType.StoredProcedure

cmd.parameters.add("@.Your parameter name here",Your parameter type here).value=your parameter value here

conn.open

cmd.executenonquery

conn.close

|||

Thank you.

Now i want to encrypt this passing value in the stored procedure. i want the encryption to be done in the stored procedure using symmetric key. So do i need to convert this value to varbinary in the stored procedure. or only in the table?

How to call a stored procedure from a web page with VB

Dear Masters;

How can I call a stored procedure with VB code?

Thanks

Check thishttp://aspalliance.com/673_CodeSnip_Calling_a_Stored_Procedure_from_ASPNET_20

Thanks

|||Thanks:)

how to bypass report size limitation

I want to build a super long report that is organized by a train of
rectangles, and one rectangle follows another. Each rectangle has a page
break at end, so the report can be rendered in many pages, one rectangle
falls in one page. The problem is the size limit of a report is 160 inches.
That means, if I make 8.5 by 11 inches a rectangle, I can have only 14.5
pages in maximum.
How can I overcome this issue?I also have the same issue. Have you found a way around the size limit of 160
inches?
"how to bypass report size limitation" wrote:
> I want to build a super long report that is organized by a train of
> rectangles, and one rectangle follows another. Each rectangle has a page
> break at end, so the report can be rendered in many pages, one rectangle
> falls in one page. The problem is the size limit of a report is 160 inches.
> That means, if I make 8.5 by 11 inches a rectangle, I can have only 14.5
> pages in maximum.
> How can I overcome this issue?