-
Adding Parameters To Excel SQL Query
The other day, I was asked to make an Excel spreadsheet that was populated by a SQL stored procedure parameterized. This spreadsheet is supposed to run each month to analyze the previous month’s sales and commissions. I wrote a stored procedure that automatically pulled the previous month’s data. Now, they wanted to specify the Start…
-
Problem POSTING a SharePoint form multiple times
I created a web part that displays data in an HTML table. On this web part, there is also a button that says, Export to Excel. When the button is clicked, the form posts to the server and my server-side code responds with an Excel file. The problem is that it only works once. To…