Search results for query: *

Please disregard my post. I just found where it's going to format the date. Thanks for giving time reading my post. Have a great day :)

Hi, I created a formula for date (timeprint) when I already put it on my report, this is my formula: Printed on: {@timeprint} (GMT){2@GMT} When I ran the formula, it shows like this: Printed on: 5/20/2014 4:47PM. How and where can I format the date to 20-MAY-2014? Thanks in advance. netchie

Thanks for your reply. Much appreciated :)

Hi Pete, Thanks for your reply. When I tried to create a new formula that you've given, it's not accepting it. It says the field (@Duplicate) as field does not exist.

Hi, I'm using CR 2008. I created a formula to show Yes and No on the report. Now that I successfully show them, I only wanted to show all data with Yes on the report but I'm having a hard time to do it. Can you please help me? Here is the formula (@Duplicate) that I've created. if ({PR.id} =...

Hi, I am working on Crystal Report 2008. After converting the report template to the new version of CR and app, the Command field with SQL Query is not working properly anymore. Basically, the old version Parameters have the list of Auditor names and the Site as well. After the conversion to...

Here is the attachment and the complete situation. If anyone could help me, that would be great! :) I am working on Crystal Report 2008. After moving the report template to the new version of CR and app, the Command field with SQL Query is not working properly anymore. Basically, the old...

Hi NickieP, When I moved the report template to the new database location (clicked Update, etc.) It says name_role_id does not found and the only thing I could click is to click OK so I did. Then it opened the report template. It didn't prompt me to choose a new field to use. When I browse the...

Hi NickieP, Thanks for replying. Yeah, I compared the parameter from the old version and they are all the same. There is one thing that I noticed while I was moving it to the new version. It says name-role-id field is missing under Command. This is the SQL query when I opened the Command ...

Hi, I am new using Crystal Report and newbie on this forum :) I just converted CR to 2008 and when I ran my report templates, some parameters are not showing as list but blank fields to fill in. I'm already pulling my hair because I couldn't fix them :( Can you please help me? Thanks in...