Thanks for your reply J but unfortunatley I am still struggling with this!!
i found the line that it is falling over on
SELECT * FROM dbo.GetReports(0,@Report_ID)
if i enter a number less than 32 for @Report_ID then the query runs but returns no rows as there are no records with a...
hi all,
i have the following recursive function but i keep on getting the error
Server: Msg 217, Level 16, State 1, Procedure GetReports, Line 31
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
I have tried putting in a count on this but i still get the...
Hi all,
I have the following query
(SELECT
a.strPlantAreaName, a.intPlantAreaID
FROM dbo.tblSafeTrackIT_Config_Area a
WHERE a.intParentPlantAreaID = 126 or a.intPlantAreaID = 126
UNION ALL
SELECT
b.strPlantAreaName, b.intParentPlantAreaID
FROM...
Hi all,
Im not too sure if i am posting in the right group but here goes.
I have built an asp.net app (vb.net). This has a sql server backend. I have installed this on a server at my clients site and they are logging on via citrix to access this app. When they log on using citrix then when...
Hi all,
Im not too sure if i am posting in the right group but here goes.
I have built an asp.net app (vb.net). This has a sql server backend. I have installed this on a server at my clients site and they are logging on via citrix to access this app. When they log on using citrix then when...
Hi all,
Im not too sure if i am posting in the right group but here goes.
I have built an asp.net app (vb.net). This has a sql server backend. I have installed this on a server at my clients site and they are logging on via citrix to access this app. When they log on using citrix then when...
hi all,
i have a website built using .net 2 with a sql server 2000 backend.
I am hosting this site with a hosting company and i had planned on using .htaccess file to allow or deny people the ability to login using their ip address or domain name. But now the hosting company are telling me...
select year(DATEADD(m,-1,(month(@intMonth)+year(@intYear))))
select year(DATEADD(m,-1,(month(1)+year(2006))))
i am using the above dateadd funtion. i use two variables in my query intMonth and intYear.
I want to use the dateadd function to return the year based on the month and year passed...
Hi all,
I have an application built using Visual Studio .Net 2005. I have compiled and installed this on a Windows 2003 Server machine. The clients used internet explorer version 6.0.2800.1106CD SP 1, to view this application. (Windows 2000 Professional SP 4)
They are getting the error...
i have a report created with crystal 10 and i access this report from visual studio 2005. using the code below
Private Sub ConfigureCrystalReports()
Dim reportPath As String = ConfigurationManager.AppSettings.Item("reportPath").ToString + "Report_RAData_Main.rpt"...
I have a websote developed using visual studio 2005 beta , .net version 2
i deploy my application to a server and it is run from client computers.
One of the users gets the error
"Internet Explorer cannot open the internet site "XXXXX"
Operation aborted"
this happens when they click on a...
I have an asp.net application running on Windows XP. SQL Server is running on the same machine. To login the user browses to http://machinename/default.aspx. Here they enter log in details and can use the application.
This works fine on all the other machines that I have deployed the app...
Hi all,
We are a small software company that develops a web application which is deployed on client sites. Currently we charge a support fee per year which is a percentage of the price payed by the company for the software. We also offer one free maintenance upgrade a year. I am wondering what...
Hi there,
I have quite a large report. I have a personnel details table and then I have a management table.
In the management table there is a foregin key called intPersonnelID (this is the name of the persons manager)
I want to be able to print the personnel details on the report and print...
I create a crystal report (v 10)
in the header i insert > picture and chose the picture from the same folder that the report is in. it is an OLE on the report.
I then view the report from an asp.net application but where the picture is there is a small box with a red square.
any suggestions?
Hello,
I want to send an email via Outlook 2003 (SP1) from an asp.net page. I have
tried using the SMTP classes as recommended by Microsoft, but the environment
of my client, the email messages never arrive when sent using this method;
hense using MS Otlook on the wenserver. The code is...
I have an application built using visual studio 2005. there are crystal reports in this application. I installed .NET framework 2, MDAC 2.8 and CRRedist.msi on the app server.When i open a page with a crystal report i am getting the error:
"The report you requested requires further information"...
Hi there,
I have a web app with the following structure
Application
Folder1
Folder2
IncidentReporting
reports
Inside in the folder IncidentReporting there is an aspx page that uses Response.Redirect to open a crystal report pdf file that is in a folder called reports. This is...
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.