Recent content by DotNetDunce

That's just what I was looking for! Thanks for the information, Jason! Learn something new everyday! Melinda

Thank you! I appreciate the help!

Thanks for the help! I need to hold the sort order so that a table inside a report displayed in a reportviewer control on the next page can mimic what is in the gridview of the previous page. How do I capture what is set in the gridview? I need to know how to grab it so I can pass it on. I...

Does anyone know how to save a sort order or sort expression to a variable after a user has sorted a gridview? When a user clicks a column and the gridview sorts I would like to capture that into a variable to pass to another page. Any help is appreciated!

Thanks for your reply! Yes, the sql runs correctly outside of RS. I don't really understand why it is giving an error in RS, but I did manage to work around it by creating a function inside of Oracle to return the recordset. All is well now. Thank you for answering my post. Melinda

Hi! I am a newbie to SSRS am using it to connect to an Oracle database. Until this point I've had no problems, but now I am setting up a dataset with a couple of subqueries and I am now getting this error: ORA-01008: not all variables bound. What do I need to do to get this to work? Here is my...

Thank you for your replies. You have verified my information and hopefully this will help to convince my customer of my arguments. Thanks again!

I think I already know the answer to this question, but a customer of mine seems not to be able to accept "No" as an answer so here goes. I have a website that is basically a bulletin board type site. As you are browsing the site the links to the posts change colors once they are visited. Is...

Thank you so much for that information. I had that idea in mind when I started, but wasn't sure exactly how to accomplish it. Thanks again!

I cannot believe I had that extra comma there and didn't see it and, yes, George (gmmastros), I would love a better way to do this. I just threw this together this morning to create a scheduled task and this was the first thing that came to mind. Thanks everyone for your help. Sometimes you...

I am getting a type mismatch error when this reaches the last line of the sub. Can someone help me figure out why this doesn't work? post_id is a numeric field. Thanks in advance for your help! Sub Delete_Recs(post_id) set rs2 = Server.CreateObject("ADODB.recordset") sql2_abbs = "DELETE...

Thanks for the suggestion! I checked that and there is nothing set there that asks for a password. As I mentioned before, if you click cancel on the prompt it goes away and then opens the file anyway. Judging from posts to other threads, could it be something in IIS? Any other suggestions...

Hopefully, someone out there can give me an idea of where to look for this problem. I have a web site where the search option brings up a list of documents that meet the search criteria. If it is a text file or Word document it opens fine, but if it is a .xls file or a .ppt file, it throws up...

I'm apologize for not posting sooner. Here is the example I was given to figure it out. ReportDocument doc = new ReportDocument(); string fileName = Server.MapPath("ReportName.rpt"); doc.Load(fileName); doc.SetDatabaseLogon("login", "pass"); doc.SetParameterValue("param_name"...

Nevermind. I figured it out. :)