Search results for query: *

Thanks Madawc,i wanted to know to have a sample code for a Stored Procedure where a Temporary Table is created in the Stored Procedure as a Return Value,so when i click on the Stored Procedure instead of clicking on Command Objects.

Yes the parameter is part of record selection,it affects teh query that builds the data for the report...its not a selection formula or a group selection formula.its part of the query that builds teh recordset thru the command object,without it the report wont run.. so i need to have a way...

Parameters are strings and it needs to change every 5 minutes for 4 times,that is the trick part..can we do it?

How to Schedule a Report to run every 5 minutes from a particular time for 4 times and each of this 4 times the parameter should change its value. How to do this in CMC

How to Schedule a Report to run every 5 minutes from a particular time for 4 times and each of this 4 times the parameter should change its value. How to do this in CMC

If i want to create a report using Stored Procedures in Command objects,how do i do that I mean how should the stored procedure look like?Should it have a temp table returning the data or a cursor or how.Please explain how should the stored procedure look like.

I used this in a formula replicatestring(" ",146)& trim({Command.S2ADD1}) else if isnull({Command.S2ADD1}) then replicatestring(" ",146)& trim({Command.S2ADD2}) else if (not(isnull({Command.S2ADD1}) and not isnull({Command.S2ADD2}))) then replicatestring(" ",146)&...

Ian Well using a tab or adding strings is going to create problem if the data value changes for one of the fields,if lets say StringG in your example has 2 characters then the string3 that i want to print will print in lets say 70th column,but if string1 changes to 3 digits then it will create...

I have a report that has 2 groups and it works fine when run from Crystal 10,but when i publish it in CMC with all procedure done correctly like updating the password etc it doesnt show the 2nd group data,that is a formula which is in Group header 2 is not showing the data in it when published...

Thank you that works,what if the field datatype is a string,. Totext works for numbers,what if its a string and if the length of the string is 2 and i want 3 digits there.right now i am checking every variable thrua if condition and adding a 0 before..

In a line of Text,how to start a value be printed at a particular column number. Lets say i have a formula in which i am concatanating 3 strings and i want the 3rd string to start printing at column 70,how to do this. I know replicatestring will add n number of strings but i would like to print...

Local Stringvar a; Local Stringvar b; Local Stringvar c; If Isnull({Command.VarX1}) then a:='000' else a:= ({Command.Var1}); If Isnull({Command.Var2}) then b:='00' else b:= ({Command.Var2}); If Isnull({Command.Var3}) then c:='0000' else c:= ({Command.Var3}); In the above formula i need to...

I have a formula in which i am concatanating 5 strings and adding a "-" in between,even if one string is empty it wont do the concatanation,so is there a function similar to NVL that will replace a 0000 when the string is null I dont want to validate each string with a IF that it isnt null to...

12/12/2008 is not a number,its a value returned from a function in which i concatanate a string from extracting 2 characters,4 characters from another string to form a date like value. Also is there a function to calculate the datedifference from todays date minus a specific date,i think i...

I have a formula that returns a number in the format 12/12/2008,it still is not a date formula,its a number,i would like to convert that value into date,i tried using the datevalue function but it says BadDateFormat string,how to use this function...

Also there is a formula in which i am concatanating the result of 3 other formulas,even when one of those is blank or null the formula that concatanates is blank..why is this and how to have data in it even if one of the other formulas are null or blank..

If Not IsNull(ToText((currentdate-date({Command.ShipDate})),'00')) Then ToText((currentdate-date({Command.ShipDate})),'00') Else '00' The above formula doesnt compile and says i need to give a field in If section How do i write this without errors I need to get the current date - date...

In a Formula i have a chr(13) function to new line the data,i also need to add blank spaces to the new line to align it as this is called in another formula,how do i do this other than manually typing the blanks. Lets say i need to add 40 blank characters,instead of typing the blanks is there a...

I found the problem,i didnt check SUppress Blank Records in the detail 2 section which is where the subreport is..now its working

No i didnt click Ondemand,but it still doesnt display the Data,i had to click the subreport to view the data,please let me know what i am doing wrong here..