Hi. If a user inputs 8 the the field holds the value as 480:00000.If user enters 15 then 15:00000

Thanks,

Phil.

Hi John. What would the correct syntax be to grant execute permissions to a single stored procedure?

Stored Procedure: sp_product_search

DB Role: db_ExecuteStoredProcs

Thanks,

Phil.

Update: Got it........

GRANT EXECUTE ON sp_product_search TO db_ExecuteStoredProcs

John I think I have it. I have explicity granted 'Execute' permissions on the stored procedure for the AD Security Group. I am able to run the web page as...

Hi once again John. I am making progress (different error)!

Error:

sp_product_search being the stored procedure that returns the search...

Hi John. I have attempted to add a new connection string for a GridView that returns product details.

I successfully tested the connection on my local machine when it was created....

Thanks for taking time to reply.

Phil.

Thanks Adrian. Any ideas why .aspx pages take a while to render when called initially? PHP, HTML nice and quick, aspx not that good?

I read this http://www.aspnetresources.com/articles/debug_code_in_production.aspx

Have you experianced this?

Thanks,

Phil

Hi Adrian, I could not wait so have implemented remotely and it works a treat.

Next challenge(s) for the intranet:

1) Add site map

2) Add functionality to the contact form to allow...

Adrian thanks for that. I am out of the office tomorrow I will give that a try on Thursday then post back.

Thanks,

Phil.

Hi Adrian. I have attached the code behind the page.

Basically the summary takes is values from the values entered in Step 1 of the wizard. I have attached separate code.

I...

Ha! Ha! Some would argue that I am challenged!! On with my next project......adding a form that allows users to email faults (must be mad offering a channel for complaints!)

Once...

Luke you are a star, great work and many thanks for your patience.

One final question. Can I display alternate text in the column? i.e. instead of the OrderId can I...

Hi Luke. I tried your code. When the report renders instead of the OrderId being passed the report parameter field is populated with {0}!

If there is a better way than...

Hi Luke. I am 99% there .

My code:

http://my-server/reportserver?/Dev/Folder/Route Card&rs:Command=Render&Site=0&OrderId=(OrderId)

From the gridview I selected edit column and configured as follows:

HeaderText = Route Card

Sort Expression: OrderId

NavigateURL: (my code above)

DataTextField:OrderId

The link opens...

Thanks.