This is how the data in the table is
When a report is in scheduled status then the FolderPath consists of the FolderName as well as the Report Name.This is the case for all scheduled reports
FolderPath Status ReportName...
No the formula is not working as desired since it is showing only the root folder .I want to display the entire folder path(including subfolders too).
The reason i tried that formula was becoz i was trying to play around to see how the duplicates could be removed.
So the issue still has not...
There are only 2 groups.
Group #1 (folder )------ this is where the formula is placed)
Group #2 object, schedule Instance, Viewed Instance, date
When i use the following formula I get the root folder and all the objects under it (there is no subfolders being displayed and there is no...
I am placing the formula in the group 1 section (folder level) since this is where i want the folder name to be displayed
Section 2 has object details, Count od scheduled and viewed and the most recent time stamp
The object of this report is to display the count of reports that are viewed or Scheduled.
There are 2 Groups in my report .one at the folder level(This is to display the folder and subfolder name) and second at the object level(this is to display the report name)
The issue here is that in some...
Before the formula is used :
/Customer/
CustomerDetails.rpt
/Customer/CustomerDetails.rpt/
CustomerDetails.rpt
After the formula is used:
/
CustomerDetails.rpt
/Customer/
CustomerDetails.rpt
I want only this to be displayed
/Customer/
CustomerDetails.rpt
Just noticed a problem in the report.
Using this formula to display the root folder i see a issue for some folders.
for example CustomerDetails report which is under Customer folder is displayed as follows:
/
CustomerDetails
/Customer
CustomerDetails
So i have the the report being displayed...
Thanks a lot LB, hilfy4`he following formula worked for me.
stringvar x := {table.folderpath};
stringvar y := left(trim(x),len(trim(x))-1);
left(y,InStrRev(y,'/'))
Thanks.
The formula is working as desired for some folder path but for some it does not .for ex consider this folder path in the table .
Admissions/CustomerDetails - Weekly
The way the it is being displayed on the report is Admissions/CustomerDetails - Weekly
But it should be displayed as...
Thanks for the response.
I am working on a report in crystal 2008 where the Folderpath field needs to be split because it is separated by a '/'
For example the following data in the FolderPath field
/servername/Server Intelligence/Servers/CustomerDetail.rpt/ needs to be split and displayed...
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.