I am using SSRS 2005 and have written a report that has groupings that are set to toggle based on clicking a field. When the report is rendered by SSRS the grouping is working as expected. When I try and export the report to Excel and open it I do not have any of the grouping toggles available...
I have a W2k3SBS server (server1) and a W2kSBS server (server2) both running SQL2k. I need to set up log shipping between these servers.
I have tried setting up log shipping per MrDenny's FAQ. However, since these are both SBS I can not have them in the same domain and I can not save the...
I am writing a script that runs a report on a mainframe and then does screen scrapes to collect data for inputting into an Access database.
Currently I am able to get the data from the screen scrapes into an array which I then write to my database one record at a time. This is much to slow...
HELP!
Whenever I try to run the code below I keep getting Error 3061 - To Few Parameters when it gets to the set rst line.
I have checked the Access Help and it appears that it should work.
Dim strSQL As String
Dim db As Database
Dim rst As Recordset
Set db = CurrentDb
strSQL =...
I have a need to use Access to open a spreadsheet and then make 1 small change to the spreadsheet and save it as another file name.
The filename that I save to is ALWAYS the same. However, everytime I save it I am prompted whether to overwrite the existing file. As this is ALWAYS a yes answer...
I am using Access to create and print charts in Excel.
I need to add a trendline to the chart but can't seem to get it to work.
Any help would be appreciated.
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.