Search results for query: *

How/what are you trying to highlight? Try selecting what you want the Right Click > Format Objects. On the Font Tab you can change font options you can change the color of the font and use a formula. Or on Border tab you can change the background with a formula. You can write the formula as...

I think I figured it out... What I needed was to show the count of Priority 1 and Priority 2 tickets over a 12 month span for a specific application. So for my parameter fields for begin and end I used 1/1/2010 to 12/1/2010 like I had been before. But, before I was saying show me only P1/2...

I think I might have an answer for this (not sure if it will work for your needs).. see here... http://www.tek-tips.com/viewthread.cfm?qid=1645027

Didn't finish my thought.... The ultimate goal is to have charts and/or crosstabs created on this basis so every month in the specified range and has totals for each priority of ticket whether the count is zero or not.

I want a report to show number of Priority 1 and Priority 2 tickets by month and total each P1 and P2 separately based on date opened. I want to create a report that will show number of tickets OPENED in each month, but have the report show ALL months regardless. The issue is if there is not...

Understood. I literally mean I removed EVERYTHING from the report canvas. There is nothing in select record/group, nothing in any footers, the report literally returns zero records and it still prompts for the param fields. Glad I'm not alone in this... to a degree I guess lol. Thanks for...

I will try that, thanks Brian. Dumb question though. What I DID try, I took one of the param fields, found every formula it was used in, deleted those formulas. Now when I do "find in formulas" it comes up with nothing, BUT it still has a check box and still prompts for the value when I...

Even fields from DB tables, the green check box is not remove and they are not used in ANY formulas.

What about removing a field that is used in another formula but that "other formula" is NOT IN the report? Its like if a formula is used in other formulas, and those "other formulas" are removed from being used in the report, those items still show as being IN the report (green check box).

Thanks Brian. This is what I was doing. I have it working now. I created a new report to test with pretty much nothing in it (i.e. parameters, formulas, etc.) As an aside to this, either this is me and I'm crazy or its crystal screwing with me. Is there a way to PURGE everything in a report...

I have a report where I am using 3 sets of parameters for begin and end dates (report, current, previous). The main report uses report_begin_date and report_end_date in the select statement to grab 2 months worth of data. In the main report where I am displaying monthly data metrics I use...

If I add it to a footer, lets say my top one, footer report footer A) RFA and do what you suggested (instead of in the pager header) checking the underlay box does nothing, it doesn't underlay the sub report. Keep in mind I have a lot of RF sections, like through RFAI. Now, I'm think the more...

Hmmm. When doing that it causes the subreport, which is only 2 pages, to span the whole of the report. So page one shows on page one. Instead of the logical second page of the sub report being on the second page of the main reports it displays in the last page (which is page 6 in this case) of...

You can't, that I have found, insert a report as a sub report across multiple rows, i.e. report footers. So I can't insert a sub report into the blank space in the middle (just left of the black line. This would show previous month: December, and its data). The insert sub report would go into...

I've built a report that mimics a "dashboard" used by upper management as a monthly board report. I have lots of report foots for each line of data formatted something like this (see attachment) What I want to do is insert a sub report using a different date range (previous month) in the blank...

So, not really formula related (where should I post this?).... What does everyone use to create pretty charts with colors management love to see? Excel? I'm trying to create dash boards in crystal where you can basically run the report for a date range and dump to PDF as the final product...

Because using formulas in the select statement pulls EVERY record from the DB and THEN crystal does the conversions, this taxes the DB. I looked at using the shiftdate time, but I was not able to figure out a way to automate it. Meaning during DST I would need to use 420 in the formula to...

When I do ANYTHING with writing an SQL expression I get this: --------------------------- Crystal Reports --------------------------- Error in compiling SQL Expression : Database Connector Error: '42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'if'...

Hmmm.... This doesn't help me the select statement though, since I can't use formulas in this way.

So, my original formula above for GMT conversion... Edited a bit after finding if the date is in DST or not, and then acts accordingly... Thanks lbass, who help as always! NumberVar i; NumberVar weekCounter; DateTimeVar gmtDateTime; DateVar searchDate; DateVar beginDST; DateVar endDST...