sorry for such a worst framing of my question. I will try now to elaborate it.
1. I have a reporting server installed in my private network. So I can access the reports on the reporting service only inside my private network.
2. Now I am designing a web APP which needs to display some of the existing reports which are already deployed on the reporting services.
3. For That I am using ReportViewer Control in ASP.Net webforms. And I am using Server Report mode which actually uses the the reports already deployed on the reporting server.
4. But the problem is some of my reports have links in it. When we click those links it will redirect to another report that was deployed on the reporting server. So even when I use reportviewer control to view the existing report , the link actaully redirects me to use reporting service URL.
5. As we are using the WEB APP outside the private network, the link actually cant be accessed because the reporting server is accessible only inside the network.
6. Now My question is how can I actually handle those links in such a way that when user clicks on them, they needs to be displayed on yet another reportviewer control rather than redirecting to the reporting server URL. IS there anyway I can manipulate the URL using Code.
I think that was poor planning on whoever created the report server and the reports in them.
Guess your just calling a report from the report server, and the report server generates the links in the report.
I would have to see the HTML in the browser, to inspect the format, and then decide what to do.
You could write a JQuery script to load when the dom is ready, and find all the A elements, and loop and inspect to finds the ones you want to change, and change the href attribute value.
If the web server and report server are on the same network, and the reports work, but the access links are different to the public, you should be able to change the links in the report server so all can access it, and the reports generate a new link.
You still didn't give samples of the links, you could just fix the DNS record for it.
But why is this your problem? Your a programer that write code, makes web sites. Unless your the one that made the report server and all the reports.
I am generating a function that Exports to Excel using Interop.dll in Vb.net. So Do you think that I need to install office for this on Server machine if I deploy the application? Are there any other things that does export to excel and which will not require Office to be installed on the server machine?
Your help is much appreciated.
"Interop" dlls are just .net wrappers around COM objects that allow your .net code to use the underlying COM objects. For the code to function after being deployed, the COM object the interop is a wrapper for needs to exist, so in your case those objects are provided by Excel, so Excel needs to be installed on the server.
Legal and license issues aside, you're not going to get this working reliable (if at all) and it isn't supported by Microsoft. Look to another way of generating excel files like Open XML, Adpose, the excel odbc driver, DocX etc.
Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.
There are various ways to create Excel spreadsheets on the server without using Office interop. For example:
NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query.
using (OleDbConnection connection = new OleDbConnection("-YOUR CONNECTION STRING HERE-"))
using (OleDbCommand command = new OleDbCommand("SELECT * FROM emp WHERE date_logged Between ? And ?"))
// OleDbCommand doesn't use named parameters, so the names don't matter here:
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
If you mean the file you selected is forgotten and the upload control blanked when the control is part of an updatepanel then that is normal behavior you can't do anything about. You can't default the file that an upload control points to, and when your updatepanel fires your upload is being deleted then recreated, and it can't be recreated to the same state the way a textbox or dropdown can.
Move the file upload outside of the update panel as they don't work inside asynch update panels anyway.
I have a task to dsiplay a report using ASP.NET webforms ReportViewer Control. I am using a localreport mode to display the report.
Now when I change something in the search_str parameter which I want to pass teh value from a textbox prompted to the user and click the View Report button, how to refresh or reset the search_str parameter in the button1_click event.
I wrote a contact us page with a form, that writes the info to the table.
I can read the table, but I can't write to it on the production web server.
I can write to the table on my desktop running VS2013 Debug.
So I have 3 other databases on this production SQL server that works fine.
All the other web sites can read and write to the SQL same server.
It's just my first MVC App, that I wrote.
The function runs from the home controller and returns true, and sends the emails.
In web forms, it throws and exception if there's a mistake, but in my MVC app here, it just runs even if there is an error in the SQL.
Like I said I'm just baffled here on this.
public ActionResult Contact(ContactModel model, string returnUrl)
if (ModelState.IsValid && true == ContactExtender.SubmitContactMessage(model))
// Package the data needed to send the message.
model.smtp_websiteName = "xxxxxx";
model.smtp_subject = "Contact Us";
model.smtp_sentFrom = "xxxxxx";
model.smtp_sendto = "xxxxxx";
model.smtp_replyto = "xxxxx";
model.smtp_templatePath_website = System.Web.Hosting.HostingEnvironment.MapPath("~/App_Data/SMTP_Templates/contact_website_template.html");
model.smtp_templatePath_customer = System.Web.Hosting.HostingEnvironment.MapPath("~/App_Data/SMTP_Templates/contact_customer_template.html");
// Send a email message to me and the customer.bool website = Contact_Website_Email_Proc.Send_XHTML_Website_Message(model);
bool visitor = Contact_Customer_Email_Proc.Send_XHTML_Customer_Message(model);
ViewData["contactMessage"] = "Success";
ViewData["contactMessage"] = "Failed";