I have been trying to dify a sample asp page from CR to run the RDC with V: XI.
Here is my code:
<%@ LANGUAGE="VBSCRIPT" %>
<%
'===================================================================================
' WORKING WITH THE REPORT DESIGNER COMPONENT AND ASP TO SET A REPORT'S QUERY...
I am getting this error:
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument
It has been traced back to
set m_de = Server.CreateObject("DERuntime.DERuntime")
m_de.Init(Application("DE"))
This was working fine on the dev server. when we moved it to the new...
I am trying to set the anchor of an internal HTML page on my asp page. I have a couple of the pages pulling from the url, but this page will not accept that.
The only place it calls the html page is here:
m_sFileLocation = Session("sTemplatePhysicalPath") & "C-ClientSummary.htm"
m_sHtmlDoc =...
I realize it is, however it is the starting for a long SP I an transfering from SQL server. There will be updates and modifications to the table, etc...
I did check the verion and I can creat a simple SP, however when I add a begin/end it goes haywire
I am writing this stored procedure and it keeps erroring out:
create procedure RetensionRate ()
BEGIN
CREATE TEMPORARY TABLE mytemptable (Week int, beginning_Count bigint, Ending_Count bigint, Retension_Rate decimal);
insert into mytemptable select Week, Beginning_Count,Ending_Count...
Synapse,
Can you have multiple command objects in 1 report? I need to do this first for the opt-in, then the opt-outs column for this week and the previous 9 weeks.
Also, we are creating this in access and then moving it to MYSQL. Will the command objects still be effective?
I am fairly new to CR XI and I am trying to develp a formula to determine the original record count then the final active record count.
How can I put these conditions in formula?
count({Transactions.UserId})
isnull({Transactions.InactiveDate})
or
{Transactions.InactiveDate} <= DateTime...
I have a text field that I am updating. Once the procedure finishes running i need to save it to a file.
The problem is that I am getting about half of the document.
Here is my code
set nocount on
declare @Abbr table ( IDN int identity
, Abbreviation varchar(12)
, Definition...
what comment code? I am sorry, but I copied this from the previous version of the page and am still unsure what it does other than displays the message as it starts the page and then disapears.
The change text function is this:
function ChangeText(ElementID, newtext)
{
var...
I have this little bit of code that is throwing me for a loop.
I looked up what the error said, but do not see where this has not been terminated. If I take this code out, the page works fine.
If I leave it in I get:
Line 100
Char 25
Error: unterminated string constant
Code 0
If I take...
I changed it, but now I am getting another error:
Server: Msg 8115, Level 16, State 5, Line 1
Arithmetic overflow error converting numeric to data type varchar.
Here is the new staement:\
select
Case when Ltrs is null then '-' else
convert(varchar(4),(convert(numeric (18,1), Ltrs) * 1.0567))...
I am trying to do an insert, however this is not working the way I expected.
Case when liter is not null then '-' else
convert(varchar(5),(convert(numeric (18,1), Liter) * 1.0567) End as Quarts
I had expected to conver a varchar(4) to conver to a number if it was not null, multiply it out by...
it is the class in the css for blue links, by default for this site they are not supposed to change, but on this page they are supposed to be blue and underlined.
I cannot seem to change the color of my link via the stylesheet.
This is the statement I am trying to change the link to blue with is:
<p class="main">Go ahead, click on <a class="SubSectLink" href="javascript:document.frmDemo.submit();">Try It Now!</a></p>
The stylesheet looks like this...
alright I get the count of the files, but it will not generate the random number. Can I pass a vbscript variable to a javascript funtion?
Dim oFSO
Dim oFolder
Dim FileCount
dim count1
Set oFSO = server.CreateObject("scripting.FileSystemObject")
Set oFolder =...
That came back with an error:
Microsoft VBScript compilation , (0x800A0408), Invalid character, /Default.asp, line 109, column 13, GET , /Default.asp,
Here is what I have for the code now:
Dim oFSO
Dim oFolder
Dim FileCount
Set oFSO = server.CreateObject"scripting.FileSystemObject")
set...
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.