I have a report that displays numbers correctly when run against sql server 2000 but when run against sql server 2008 in 2000 compatibility mode, the numbers are displayed as 0. The report query actually returns numbers.
Any help will be greatly appreciated.
I have reports using =* for outer joins and they fail to run against SQL Server 2005. How can I replace the =* or *= automatically in Reportsmith without having to edit all the reports' SQL statements. I am using RS 3.10.
Thank you.
When I try to export to Excel using Save As, no error is reported but the file turns out with size 0 and contains no values. I am using Windows XP winr RS Version 3.12.
Does anyone know why this happens? Thanks for your help.
Does anyone know how to resolve this error that comes up when i run a report in Windows XP. The error message is:
Attempt to stream unrefistered type "TTotalPages". OK to resume?
This report runs perfectly OK in Windows 95.
I am able to lunch the built-in change pasword form from code using the following:
CommandBars!Tools.Controls!Security.Controls![Set Login Password...].Execute
This allows my user to change login password on the SQL Server.
How can I know when the user clicks OK or Cancel on this built-in...
I have a stored procedure on SQL Server called by Access project. The stored procedure return either 0 or 1 if a login is a member of as server role.
How do I receive the returned value in Access module.
I am using the following to run the stored procedure:
CurrentProject.Connection.Execute...
How can I connect an access project to an SQL server backend without using ODBC. I want to deploy an access project front end without having to set up ODBC on the client PC.
Thanks for your help.
Wale
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.