Hi
My company has agreed to send me on a SSRS course and I've identified 'Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services - 6236a' as the course to meet my requirements.
However, I am unsure who to go with in regards to the training.
I'm located in the South West but...
Quite new to SSIS and obviously Package Configurations.
I have inherited a system where an external application alters the XML package configuration to define an XML Source File Path.
This application no longer works and I want to recreate something within SSIS.
I hoped that by moving the...
Hi,
I have a SQL Server 2005 database that I have created several users with db_datareader access.
Most of these users access the data via ODBC, but some use SQL Server.
Those that can use SQL Server are my issue.
I assumed that with db_datareader users could only connect and view the data...
I always assumed that in Access when you join a field only exact matches return (Unless you change the Join Type obviously!!)
However when I joined two tables I got unexpected results.
So after running a quick test, I'm even more confused.
Access matches even if there are trailing spaces...
Hi,
I've created an Automated System, mainly through luck rather than judgement, that opens several reports, refreshes them, saves as pdf's and either prints or e-mails them to my clients.
What I'm looking to do now is on refreshing have a record count for each report.
I've got a form...
Any Help Will be great.
Am using VB to Open,Refresh,Print,Save and Close several reports.
However the reports all have user defined prompts - 2 with date ranges and 4 with user names from a list.
When the macro gets to:
activedocuments.refresh
I get the user prompt form appear - How can I...
Hi,
I have been trying unsuccessfully to open a document/report using VB.
Have tried several methods:
1)Open "Report1" For Random As #1
'Can't see the report anywhere
2)Documents.Open ("C:\Report1.rep")
'Object variable or With block variable not set (Error 91)
Not sure what I'm doing wrong...
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.