Comments by iCanDivideByZero (Top 29 by date)

Output parameter...it yields a single xml value e.g. "<row ....="</xml>" col2="" col1="">
Also the "ROW" has three fields, that is why I put three in the table.

Quick question. Can you declare the @cache TABLE without specifying the id or the colums for the table?

Dude! That is exactly what I am looking for, Thanks! The output from this very closely matches the SQLXML output I have to match up to.

Could you please elaborate on this technique, I'm a bit of a noob

hmmmm...i tried your idea and received the following error.

Column name or number of supplied values does not match table definition. Could not find stored procedure 'CountCol'


Any clue to what is causing this?

You know since I do not have write access I doubt that will work lol

What about creating another SP and that calls the old one and wraps the ouput; not the return value, using FOR XML AUTO???

tried that already, and I believe the FOR XML AUTO must do some formatting that the method you mentioned does as, booleans come back as "true" and/or "false", rather "0" or "1" like when you have the clause in place. That is just one of the difference I've seen; which is major enough.

Given my circumstances do you think it is feasiable for me to be able to alter the sp then? Can you point me to some examples, so that maybe I can attempt that before having to return to him and try desparately to convince him it cannot be done in the manner he assigned it to me.

I have read access to the database, table, views, and stored procedures...however, I cannot modify them it appears. I was given an account with limited access, I am assuming that is all my lead said I required when I was setup.

sorry if it is coming across like that, but I AM NOT TRYING TO HACK ANYTHING! This task was given to by my lead and says its possible to get it done...but according to the comments I am getting it sounds like it is not.

Unfortunately, since I don't have "modify" access I cannot see what the stored procedure is actually doing to duplicate its functionality.

Are there no other options available then?

AUTO

Oh so your saying create another SP that simply does the same function, but at the necessary code to it. That would work, BUT I am not even able to see the code in the SP I am working with. That level of access was not granted. I feel like i am being screwed here lol

It does, but can you elaborate with some psuedo code please.

I actually ended implementing it they way you mentioned, as I was not having much luck otherwise.

Hello,
Sorry for the late response. But I was asked not to spend anymore time on this, so I decided to write a round about solution. I basically have a textbox where a date is entered, and once the user presses filter I essentially rebind the reportviewer based on the parameter. This essentially works, even when going through the pages.

I wish I had more time to come to a more eloquent solution, but unfortunately time was not on my side. Thanks for all your help!

I tried writing another expression as another avenue, but the results were the same:

CDate(IIF(IsDate(Parameters!DateFilterParam.Value), Parameters!DateFilterParam.Value, Fields!BillDate.Value))

I did the following: string dateStr = "01/01/0001";//new DateTime().ToShortDateString(); param[0] = new ReportParameter("DateFilterParam", dateStr); I received the same result an error was displayed. So I went ahead and changed my filter to just "=Parameters!DateFilterParam.Value", and the report simply came back empty; no error. Perhaps I am not doing something incorrectly with the setup of the filter maybe?

Hello,
Sorry for this late response. I tried doing what you mentioned and came up with the same result. Below is the method, perhaps that will shed more light on the situation.

private void BindData()
{
// Bind the report viewer control.
string queryStr = @"SELECT * FROM Invoice_Table";
SqlQueryParameter queryParams = new SqlQueryParameter();
DataSet ds = SqlDataAccessUtility.SQLSelect("tblBilling", queryStr, queryParams,
CommandType.Text);

ReportParameter[] param = new ReportParameter[1];
if (!string.IsNullOrEmpty(DateTextBox.Text))
{
param[0] = new ReportParameter("DateFilterParam", DateTextBox.Text);
}
else
{
param[0] = new ReportParameter("DateFilterParam",
new DateTime().ToShortDateString());
}
rvInvoices.LocalReport.SetParameters(param);

ReportDataSource rds = new ReportDataSource("InvoiceDataSet", ds.Tables[0]);
rvInvoices.LocalReport.DataSources.Clear();
rvInvoices.LocalReport.DataSources.Add(rds);
rvInvoices.LocalReport.Refresh();
rvInvoices.Visible = true;
}

I tried your solution, but I received the following error on the page at runtime:

"An error has occurred during report processing.
Failed to evaluate the FilterValue of the Tablix ‘Tablix1’."

Here is the filter I used. Perhaps you can see something, that I am not.

"=Parameters!DateFilterParam.Value Or Fields!BillDate.Value"

Please let me know what you and thanks for any help you can give.

Sounds good! Now I got some reading to do lol. I will have to process this first before I can say I'll be able to make use of it. But at least I know for sure it's plausible now. Thanks!

Yes the links will be good enough, thanks. My apologies turning this into more than a quick Q&A session :)

What information could I provide to help. I mean, it sounds you are confirming what I heard. So by implementing a plugin architecture the behavior of the service can be changed/added on to then? That would be great!