Hello!
I want to create a report with a dynamic title containing the date. I saw this post: Create report with dynamic file name | Thinkwise Community, and followed the steps proposed, but I get the following error:
It seems like it does not just sets the filename to the value specified in the default, but the entire path. How can I keep the path the same (in user’s documents folder), while setting only the filename?
Best answer by Edo Spijker
Hello Sven,
To only replace the filename in the whole path you can do something like first extracting only the directory and then placing your own filename at the end.
Extracting the directory can be done with something like this:
LEFT(FilePath, LEN(FilePath) - CHARINDEX('\', REVERSE(FilePath)))
This searches for the last ‘\’ and removes everything after (and including) that.
+4Hello Sven,
It's been a while for me personally since I have attempted anything in a situation like this one.
I assume you have already implemented a default that creates the ‘testnaam.pdf’ file for the report, judging from your screenshot. Have you tried including the path in the default? I am not entirely sure whether this works or not, and I also don't have any working examples to inspire me, unfortunately. But it might be worth a shot. If not I can ask around to find out if there's someone who knows more about this than me 😅
Kind regards,
Renée
Kind regards,
Sven
+4Well technically you do know which user is currently logged in in the default procedure. Perhaps you can fix it through that?
Otherwise I am afraid I will have to tell you that the goal you're trying to achieve might not be possible, at least not currently.
Hello Sven,
To only replace the filename in the whole path you can do something like first extracting only the directory and then placing your own filename at the end.
Extracting the directory can be done with something like this:
LEFT(FilePath, LEN(FilePath) - CHARINDEX('\', REVERSE(FilePath)))
This searches for the last ‘\’ and removes everything after (and including) that.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
