on 08-26-2015 9:51 PM
I have a report using the
ShiftDateTime ({TDM_SF_PRC_HISTORY.CREATION_DATE},"UTC,0","")
It works just great in the editor, but not in the Viewer.
It just will not view unless I take this formula out.
how do I get this to work in the viewer?
Hi Paul,
What version of Crystal Reports are you using?
What type of application are you using to view the report?
Are you getting any errors?
Does the report work in the viewer on the Development machine?
Thanks,
Brian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Using Crystal Reports Viewer 2008 version 12.2.202.r566
Developer is Crystal Reports 2011 version 14.0.2.364
Another twist is that I can view a different report that was created a few years ago with the same formula and it views fine as well.
Issue is just with new report that has been developed and viewing it.
Thanks so much for attempting to help.
Hi Paul
I'd suggest using the CR 2013 viewer from here:
http://www.sap.com/solutions/sap-crystal-solutions/query-reporting-analysis/sapcrystalviewer/index.e... |
- Ludek
Senior Support Engineer AGS Product Support, Global Support Center Canada
Follow me on Twitter
Hi Paul
I have no idea what you attached, but it is not the report. I can ope it up in a text editor and see plain text. E.g.;
Model Serie
DE S DAY
CN_TRUCK_M Schedule
That looks like some export (CSC / TXT / XLS)?
I need the actual report. E.g.; say teh report is called "test.rpt". Rename that to test.txt and attach. Do make sure the report has saved data (under File | Options)
- Ludek
Paul,
You cannot attach a .rpt report without changing its extension to .txt.
First save the report 'with data'. Next, change its extension from .rpt to .txt.
Otherwise, you may send the .rpt file (with data) to my email address (address is in my SCN profile) and I'll try to attach it here.
-Abhilash
OK. So the issue is the formula that uses ShiftDateTime. If you comment this out, the viewer works fine.
Interestingly, designer is OK as is a .NET App.
Solution: The latest Crystal Reports 2013 Viewer Service Pack Issue here may be that unless you have an Enterprise support contract (Access to Service Market Place), there is no way for you to download the SP at this time. If you do not have enterprise support contract, please contact sales and ask them to provide the SP for you. PH: 866-681-3435 or 1-800-677-7271
or, Worldwide Office Locations | SAP directory.
- Ludek
Hi Paul,
Have you tried deleting the formula from the report and recreating it? Don't copy and paste just retype the formula from scratch. I've had strange things happen and I've seen reports hold onto stuff internally.
I've had to recreate a report from scratch because I knew it should work but didn't. With pretty much nothing different, the new version worked.
Good luck,
Brian
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.