Search results for query: *

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)&...

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...

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...

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...

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...

Is a Subreport the only way to have a Master Detail report? If so how can the Subreport display the value without being clicked on it,as it will take it to the original subreport,i just want the subreport to display the details and the master values will be in the main report,i will place the...

In a SQL Statement in command object how do i use the Ucase function in the where clause,i know this might seem primitive but i really need to know

I checked the option Keep Group Together and Show Group Heading on each page in the Group options This works finefor me but the problem is in one of the pages of the 15 page output it has only one record for the group and i would like it to print the next group and its records in that page as...

select table1.s2name1, table1.s2name2, table1.s2add1, table1.s2add2, table1.s2city, table1.s2state, table1.s2zip, table1.s2country, table1.s2phone, table1.carrier, table1.service, table1.shipdate, table1.dc, table1.treax26 MANIFESTOR, table1.treax15...

I installed WIN XP in a machine that already had Windows Vista in it and Audio and other multimedia was working fine,but after i installed WIN XP the AUDIO is not working,all the options are disabled when i open the Sound and Audio Devices property tabs..i also tried the services.msc in the Run...

I get the PXE E61 Media Test Failure when i try to boot the Laptop.I already tried the following 1)Change the Boot order to Hard disk as the first in BIOS by pressing F2 while starting up the Laptop. 2)Removed the battery and re inserted it 3)Got a new Hard drive and replaced the old one with...

Some setting in my Internet has changed accidentally or installing some software for the browser has caused the Audio to not work in Macromedia Flash player version 8.Any Video that i get thru Macromedia Flash doesnt have Audio and i want to know what settings i should change in order to get...

I am using Windows XP and Win Media player Ver 10,but still it doesnt have a great video quality,i would like to know what are all the plug ins i need to install and what settings in Windows i need to use in order to use Media Player to the optimum and get great quality videos.

In my Temporary Internet files folder there are some files over 700 MB and i guess they could be movie files or DAT files.These files have no extension so i presume they might have been some incomplete files while downloading. I tried renaming them with MOV it didnt work,i tried to open them in...