Search results for query: *

I have a crystal report 2008 built out of stored procedure(Procedure is using SQL server 2008 database). there is a datetime parameter in stored procedure.when it is coming to crystal reports it is showing as datetime but when i change the parameter type to dynamic the paramter datetype is...

I need to build a report in such a way that it should take the parameters from URL.. I have createad the URL but i need to know where i have to code in the report and what code i have to use so that the parameters will be inputed to the report. Any suggestions... Thanks, rreddy01

I am trying to create an optional parameter in crystal reports 2008. There is a parameter field called Name which is given as optional.. if they dont enter anyvalue in the parameter it should pick up ALL values..I have defaulted the parameter to 'ALL' in parameter list but when they want to...

I have a mainreport which has ID,contractID(15 characters- A10000-00-000-0),date.. Mainreport has group by on ID.. for ex: there is a contractID: A11111-00-010-00 is under ID 01 for tthe date may2012. but there may be same contractId just with slight difference in number under jan2012 and...

i am trying to get all the codevalues separated by commas in a variable x but while doing this getting some duplicates or some values are missing. WhilePrintingRecords; stringVar x; if length(x) = 0 then x := x + {CODEVALUE.DESCR} // else // x := x + ", "...

I have a report in which i have group footer #3d and #3e. there is a formula written in group footer #3d to supress some text object if it is a state project,if it federal then i am not suppressing anything. whenever it is state project there is a free space coming up. Instead of free space...

I have a report which is grouped by manager name, i dont want that to group in alphabetical order instead i want to start with letter B. Thanks, rreddy

Can i use this below Query and write a SQL expression or atleast create any formula.. i have never used SQL like this in my reports. SELECT WEBTRNSP.PROPOSAL.PROPOSAL_ID, WEBTRNSP.PROPOSAL.PROPOSAL_NM, LISTAGG(WEBTRNSP.PROJECT.FEDPROJECTNUM, ' & ') WITHIN GROUP (ORDER BY...

I have this below formula in my main report. this formula is getting all the county names into a variable called federalcountyname but the thing is the county names are repeating, means they are getting duplicated. For Ex: they are counties called A,B,C,D ETC. WHEN I USE THIS FORMULA I AM...