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...
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...
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"...
I have created a report using Crystal Reports in VS 2005 and everything works great on my local machine. There is a parameter field in the report and before the report is displayed, a prompt is displayed to collect the user data. When I run the application through the web server, all works fine...
Thanks, jbenson001. I've been a member of this forum since 2001 and it seems like I've always been the one learning from scratch. I started out in ColdFusion, then went to ASP and some .NET, then to C++ and now I'm back to .NET and I've never got to stick with one long enough to become good at...
I've looked at this thing for so long I just didn't see it. Sometimes it takes a fresh pair of eyes to catch things. Thank you so much! I've never really posted anything to the forum because I'm too dumb, but I don't know what I'd without you guys! Works perfectly! Thanks a bunch!!
Melinda
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.