Search results for query: *

I have seen similar questions here, but the answers don't seem to fit my scenario. I am sure it is something relatively easy that I am missing. Using CR2016 I have a cross tab with the days of the week Sunday - Saturday. I have a distinct count of customer IDs for every day and it looks like...

I have a function for a parameter for the users to select dates in the past and they rely on the canned functions already in crystal. For instance: If psRunPeriodParameter = "Yesterday" Then CurrentDate - 1 Else If psRunPeriodParameter = "Week To Date" Then...

I have a report using CR 2011 and it has a column for each day (Monday - Sunday) and does employee counts by the hours of clock ins and clock outs. I have a reset variable for each day but I need to figure out how to rollover counts from Monday to Tuesday. For example on Monday at 10PM I have...

Using SQL Server 2008 I have a pretty long query but the problem I am having is on the left join. I need to left join because there may or may not be a value in there, but when the record has a value I get both records (a value and then a null) and when there is no value I get the single Null...

I am not sure if this is the correct forum, but I do not see any Universe Design forums so if there is a better one to use please let me know. I am using BO 4.0. I built a Universe that is not complex at all, but I do want to have the users use 1 date filter for several date fields and date...

I am trying to develop a report for a customer that links to Salesforce.com. It has a few tables that are not high volume tables (less than 500,000 rows) and a couple advanced formulas but not too hard. When I run the report, my Crystal seems to hang there and never return. I don't get an...

I have a list of clients with a value and date sorted by name and then date order. I need to count the patients each time that value goes above 170, but only AFTER it is under 170 at least once. So if they are 300,300,300…I exclude them, but if it is 300,166,300,300 I would count the last 2...

Thanks to LBass the formula below works great. I can compare whatever record I want against another. Now the requirements changed and they want to compare multiple records. For instance I have records 1 and 4 comparing and they love it. Now they want 1 and 4, 2 and 5, 3 and 6... It is not a...

I know I have done this before but can't remember how. I have multiple records coming back. The values are simple: Client, yesterday's value, today's value. Problem is they are coming on seperate detail lines so it looks like this John Doe YESTERDAY VALUE John Doe...

Using CR2008 and Crystal Reports Server 2008. I have applications that need to access reports. The reports will connect using ODBC and run a stored procedure looking for 3 parameters. I have done URL reporting in the past but used a custom back end, not going directly through the CR...

Using CR XIR2 I have a container report with 5 sub reports. Each sub report is a cross tab. The container passes the parameter to the sub reports, in this case it is a begin date and end date. When running a report, the cross tabs are limited to roughly 20 days (the width of the container)...

Running XIR2 on 2 dual core servers. I have 1 of each servers running (Job, Cache..etc) on each box. Someone told me I should add another Job Server to each to increase performance and/or prevent future performance issues. I do not see anything on that in the admin guide. Is this easy to...

Using CR2008 I have many reports using a command and need to send a parameter to the server in the command based on their Active Directory login to filter server side and not client side. I have a formula on the report called ADLogon which is simply - currentceusername() In the command I...

Using CR XIR2 I have a bar chart with a secondary Y axis that is a line. The line has series markers that are pretty annoying. I just want the line to show a trend so I don't need the markers. I can not find a way to remove the series marker and just keep the line. Has anyone else run into this?

Using CRXI I have a bar chart that I want to show metrics by day (counts and $) based on a parameter. The X axis is a date and the Y is a metric. All by day. Sp far this works fine. I want to do a secondary Y as a cumulative number. Is this possible? I have not found a solution to this.

I am using CR XI and want to load data into a bar graph and then only show the data that is selected from a parameter. In other words I want to have counts of different products. Say Products A,B and C. I want to chart all 3 but want to show just B based on them choosing B from the...

I am using CR XI and have detail information by a date. I need to shade the previous days based on day 1, day2 etc. So this week (days 3,2,1) would be nocolor, but the last week (days 7-1) would be silver. Then the week before that would be nocolor again. Any thoughts? So this is what it...

I have the Email set up correctly and working. I run the scheduled report and have it set to email the report as text. All that works fine, except now the CEO does not want to open an attachment; he wants to have the report embedded in the email so he does not have to open another document...

Using Crystal 9 for thousands of users in the field. Out of over 3,000 users I have 2 that the date picker does not work. For the other users the calendar comes up and lets them choose the dates. For these users, instead of the date picker, just a text box appears and prompts them to enter...

Using Crystal 9. I have an empty main report that contains 3 sub reports. The sub Reports are in report footers of the main report and the data itself is in a group header. I want each group to be on it's own page except on the last page because then it creates a blank last page. I have tried...