Search results for query: *

Hi all, I have a task that I am not sure can be acomplished given the parameters. my boss has asked me to come up with a way to delete records from tables named in a temp table. Many of these tables are related and have foreign keys. We would like to be able to determine the dependency and...

Hi, I am trying to hide a label when a checkbox is unhecked. I am trying to do this using javascript within a vb.net code behind page. I keep getting a syntax error and don't know where to make the changes. Here is my sample code Protected Sub Page_Init(ByVal sender As Object, ByVal e As...

Yes that is normally the case, calling the proc with ADO.net. I was asked to have the clr procedure be implmented by an interface Interface ICLRmethod CLRmethod(P1,P2) End interface I think I may have the syntax wrong or the wrong type of project. I don't know. Never had this type of...

Hi, My question is first is it possible to return records from a clr procedure that is called from a VB.net interface. The CLR proc is using SQL context and a pipe to return the records. The proc works fine as far as returning results when used by itself. I have tried to figure out the interface...

Hi, I have a report where the user can select multiple values for one parameter. The report requires that the param selections be shown if reasonable. I am populating the parameter selection from a sproc using the id field for selection and the descriptor for display. My question is how can I...

HI, can anyone help me out with this. I have a report where I am trying to filter a single parameter based on the selection of a from date and a to date parameter in reporting services. ex: 1st = 1/1/2005 2nd = 1/1/2006 pass these 2 values to the sproc that will populate param 3

Hi, I have a report contains a matrix. The totals row is duplicated when the report is exported to Excel. How can I format the report so that this does not occur? Thanks

Thank You. That was what I needed.

Hi, I am new with SSRS. I have a report with mulitple parameters. If the user has selected a combination of the paramaters that yielded no data how can I place that message on the report.

globalstrata thanks for the repsonse. I am using a dataview WP with data from a custom list. The DVWP contains 2 columns with links to other custom lists. The secondary lists have filters applied based on the Medical staff ID #. List 1 should present all education; med school, fellowship...

I have a dataview that links to other lists (contact info and education). The data is not complete in the other 2 lists so when the filter is applied the no data message is displayed. When I click on the add new button how can I get the "New" form to populate the data in the name and ID fields...

Hi, I am working reporting services and want to create a dataset containing multiple tables. When in reporting services I am able to set the report datasource to the stored procedure but I am only able to retrieve data from the first table. Is this by design or is there a way I can retrieve...

Absolutley there should be a forum for reporting services. I use it daily to deploy many of the former "Green Bar" we used to have. [thumbsup2]

Donutman (Karl), Thanks for the help. It is now working as expected.

Thanks for the code example. It works well but I need the previous and current months to be based on data in the database. Most often the report data is not updated until the 15 days after the month has ended, say September data is not updated until Oct 15.

I do not have a Fiscal year table but I can do that if it will make it easier to accomplish the task. In my attemps to get this done I have used hard coding for the 2 previous Fy's.

Hi, I am trying to populate a spreadsheet from SQL Server. I want to get the last Period for the 2 previous fiscal years and then the most recent 2 months of the current Fy Example : 6/30/2003, 6/30/2004, 8/31/2004, 9/30/2004. I am trying this using a union query. I know it can be done by...

I Figured it out. I had to use CType(MyRow.FindControl("tbAddDesc"), TextBox) and so on to get it to work. Thanks guys.

Yes I am checking for nothing in the code but removed it for the post.

Thank you for the responses but I am still not there. Now my question is if I am to use e.Item.findcontrol should the e param type be e as System.Web.UI.WebControls.DataGridItemEventArgs or something else because Item is not a member of system.eventargs.