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 + ", "...
Thanks for your reponse!
yes, i was doing the exact same thing but the next section is getting continued on the same page(group section #3e) but now i want the group section #3f too to continue on the same page because there is plenty of space in the page
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...
Thanks for your reply.
i have created a variable called federalcountyname, trying to get all the county names in that variable separated by commas.but when i do that i am getting duplicates.
the output should be A,B,C,D but instead of this i am getting A,B,C,A,A..etc
Thanks,
rreddy
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...
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.