Does anyone know how to make this work? I need this field to be equal to the parameter ?Site, but I also want it to be equal to -1 or -2. It's saying I need it to be an array. Basically it's to chart limits which are for site =-1 and/or site=-2 plus the actual site. The Site parameter is dynamic...
I just normally do my parameter displays like this:
if {?Parameter}="*"
then "All Parameters"
else join ({?Parameters},",")
if you don't have the wildcard then you could just use
join ({?Parameters},",")
I have a chart for Crystal Reports 2013. Does anyone know how I can force the legend to NOT resize if the text is too large? Can i force it to only display a certain number of values? I don't see anywhere I can configure anything with the legend. I need it to resize based on the values but...
Hi all
This is sort of a backwards request in that I have the solution but need to know why it's working. I have a report that uses these formulas to convert the date from UTC to the local user's PC time. (So I've been told). However, I don't understand exactly HOW they work. Could someone...
I have a report that can be run for a large or small set of data. When there are only a few samples over a small time period, the Sample Date individually displays fine. However, if there are several Sample Dates, it tries to cram them all in. Is there some sort of conditional setting that can...
I'm sure this has been answered somewhere but I can't seem to find a solution specific to my report. I'm using CR 2013, I have a Page Header that I want displayed as long as I have records in the Detail section. Once all details have been displayed, I then have 2 subreports in the Report Footers...
Can someone please help me with all the required formulas that would allow me to create and pass an array of numbers to be used in a subreport?
I have a number of PR IDS generated in my main report that I want to pass to my subreport. My subreport then performs summaries and calculations on...
I have a shared variable being passed from my subreport to main report (Lot Number). I am trying to then suppress the Group Header in the main report if there is no Lot Number but it's not working. I assume it's because it processes after the report? Is there any other option?
Formula in Group...
Has anyone had issues with Crystal Reports and Trackwise database? I have "Database server is case-insensitive" checked off and it's still not working. For my parameter, if the user enters "LAV", I want "LAV, lav, LAv" all returned. But it's only returning exactly what the user types. Also, if...
Has anyone had issues with Crystal Reports and Trackwise database? I have "Database server is case-insensitive" checked off and it's still not working. For my parameter, if the user enters "LAV", I want "LAV, lav, LAv" all returned. But it's only returning exactly what the user types. Also, if...
I get 3 rows of blank values back.
If I only use this portion of the formula:
Whileprintingrecords;
Shared Stringvar AllLotNo;
AlLLotNo := AllLotNo & ", " & {F4111.ILLOTN};
If I just run the subreport alone, I get:
1. , VNPRL1011
2. , VNPRL1011, VNPRL1012
3. , VNPRL1011, VNPRL1012, VNPRL1013...
I have this in my subreport to gather the lot numbers (which I have been able to get, however when I run the subreport by itself, I'm getting 3 rows of values, shouldn't I get an array with commas all in one row? Also, don't I need a formula to share the variable with the main report or is this...
Hi all, I am using CR2008 and am lost. The first issue, is that I have a subreport that may have 1 or many values (Lot Number). I created this variable in the subreport and have it in the report footer
Lot Number subreport
WhilePrintingRecords;
shared stringvar VNteardown;
VNteardown:=...
Hi all, I am using CR2008 and am lost. The first issue, is that I have a subreport that may have 1 or many values (Lot Number). I created this variable in the subreport and have it in the report footer
Lot Number subreport
WhilePrintingRecords;
shared stringvar VNteardown;
VNteardown:=...
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.