It is beyond me to believe that in the existance of Crystal reports there has never been a need to be able to perform bitwise functions, I need a ufl that can handle a very simple SQL function 'Bitand' and all I have been able to get so far is "change your database" from Seagate's tech...
unfortunately this is wrong. You also have to calulate leap years and for some reason it seems to be off 1 second ever 11 years as well. Sorry to burst your bubble but it is not an exact solution.
I need help with a formula to convert a number field to a datetime field. This particular field stores seconds from 01/01/1970 00:00:00 I am having a brain fart and cannot remeber all of the rules for leap years and so forth, and someone mentioned needing to add 1 second every 11 years? any help...
I used to think that functions couldn't be used to Pass SQL because thats what I've allways been told by Seagate(I haven't asked Crystal Decisions Yet) here is one of the formulas that I use for record selection against a SQL Server Datebase that passes SQL 100% and you'll notice there are...
Tojo1234 to it!
You seem to be suffering from the same Crystal Disease that I do most of the time. I may be wrong but it seems you are over complicating this situation.
Lets start with you date Parameters, ?StartDate ?EndDate
and don't forget your {Creation.Date} field. These are the important...
Ken,
I have run into this before when trying to get a record selection formula to pass the SQL to the database, I discovered there were limitations oddly enough on using more than one formula that referenced other formulas in the record selection. (If I did this It wouldn't pass the SQL.) So I...
Try exporting the report to a format that the user already has such as a word.doc you didn't mention what version you were using but you may even have the option to export as pdf file, or html, and generally everyone will have one or the other. if formatting becomes an issue then I would stick...
Sweety,
That is perplexing; unfortunately Subreports were not created with the intensions of ever paginating. They were originally designed to pull in small amounts of data that could not be included due to conflicting record selection criteria.
Since SubReports cannot paginate (they are an...
Ferdisig:
To get the correct value to always show use the funtion:
whileprintingrecords;
as the first line of your formula code, be sure to include the ; to seperate it from the rest of the formula.
Note: you can always change the evaluation time of a formula as long as you are telling it to...
I'm not sure that you should be trying to link with 2 formulas, what I usually use in linking them together is to create a formula in the main report that gives me a result or value that matches something in the subreport. A basic example would be as follows:
I have a table that has an ID field...
Is there any way to turn off colors used when printing? I am using Seagate Info 7.5 and Crystal Reports 8.0. I want my customers to have colorful reports since they will just be viewing them from the desktop for the most part. However, if they need to print them out none of them have color...
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.