Search results for query: *

CR2011 Access 2007 I'm looking to create formulas to define/group each week in a month given the month's start date via a parameter. @BegDate Each week begins on Sunday or the first day of the month for the first week Each week ends on Satruday or the last day of the month for the final week...

CR 2008 I need to group my data (I think) so that I can create 2 seaparate line charts, one for 2012 data and one for 2013 data (without using a subreport). Each Chart should have 2 lines, one for 'Actual' one for 'Budget' The dataset contains only 2 years of data (?Year and ?Year - 1) based...

CR 2008 I've poured thru related threads about excluding weekends and holidays but haven't been able to get this working quite right. Given the last working day of the month, (which I'm calculating in the report for the current month, see formula below) I need to increment days (both postive...

CR XI (11.0.0.2495) SQL OLE I have a report that I'd like to change to use a command. I've changed datasources plenty of times but not to a command and am hoping I'm just missing something. I'm basically following the steps from this thread...

CRXI SQL 2005 I have 6 paramaters that prompt users to enter Y/N to determine if the data is included in the record selection. I'm trying to develop the formula to place in the report footer thats shows which parameters were chosen. HERE ARE EXAMPLES OF THE PARAMETERS ?Include A ?Include B...

BOE XI CR XI SQL 2005 OLE DB (ADo) I have tested various scenarios and it appears that the problem is specific to a certain table & BOE. - Report runs in 5 seconds in CR from my desktop - Report runs in 5+ seconds in a VB custom app. - Report took 12 hrs to run in BOE - Table originates in...

CRXI SQL I have a Stacked Bar Chart in the RH that displays the TOP N Plans for each year. Thus the chart is set on change of @Year & Plan. N is inputted by the user via parameter. Let's say N=3 I have the top 3 Plans showing for each of 4 years of data. Each of the 4 bars in the chart is...

CR XI SQL I've removed the dollar sign, decimal and commas: replace(replace(replace(totext({Data.AmountPaid}),"$",""),",",""),".","") but can't get this formula to format to 7 characters. e.g 7.00 should be 0000700 0 should be 0000000 700 should be 0070000 123.57 should be 0012357 I...

CR XI SQL We have a simple in-house VB6 app to run and preview reports that one of our programmers wrote that includes the CR viewer. Curretnly it uses a simple 'text box like' parameter entry screen. We'd like to have the parameter entry screen mimic the parameter entry screen in CR XI which I...

CR XI SQL Is there a way to control or customize the format of data entry for a date parameter ? The paramater window that appears when running reports states the following for date parameter data entry: Please enter Date in format "yyyy-mm-dd". Not a problem for users that use the calendar...

CR XI SQL Issue: Data entry of different first names for the same individual causes the chart to show a spearate entry for each entry Sample Data MemberID FirstName LastName Total E224 Jan Long 800 E224 Jan P Long 500 E455 John Smith 1100...

CRXI SQL From searching an finding a few unanswered posts, I'm guessing this may not be possible. I have a simple report with fields in the details section with a couple of parameters for the users. (?Client ID & ?FromDate & ?ToDate) GOAL: I'm trying to set a field on the report to mimic a...

CRXI SQL Is this possible ? The option to do so is greyed-out within the subreport. If I save the subreport as its own file (File | Save Subreport As..) I can then set the export options. But when I readd it back into the report, these settings are lost (at least for both version of excel...

CRXI SQL I have a simple report in my MAIN report that is just columns and rows with the row data being in the details section. There is some simple grouping for showing only headers for the row data. Column Headers are in the PH section. It exports to Excel just fine. GOAL: have a...

CR XI SQL I'm having difficulty getting my pie chart to work as needed. I need to show a slice for Individuals whose subtotal meets a $500 threshold and then group the rest into a slice of 'others' I also need to show the only invidviuals that meet the threshold and their subtotals in a Group...

CRXI SQL I'm trying to remove the decimal from a string and then pad the right side with zereos until the string is 5 characters in length. I have the decimal removal working but my loop is failing and returning an error " A string is requried here". I haven't written a loop before so am...

CR XI SQL Is it possible to allow a user to input a comparison operator as a parameter ? For example I was hoping to have 2 parameters: ?Operator ?Threshold For example a user could enter: ?Operator: < ?Threshold: 5000 or as another example: ?Operator: >= ?Threshold: 10000 my goal is to...

BOE XI I use BOE quite a bit to schedule .rpt files but am now looking to schedule an .exe that will create an .xls file to be emailed. I am not a VB developer but had someone in the office provide me with a simple test .exe file that I have successfully added to BOE using the CMC. It runs...

BOE XI CR XI SQL OLE I have a Crystal Report that pulls data from 2 databases on the same server. For one database, I have a Synonmym setup for the one table it pulls data from, and it only pulls 1 or 2 rows from this table. The report runs and displays in CR in about 5 seconds. When I set...

CR XI SQL I have an existing crosstab report setup using the following: Row = SvcDate (actually setup to show each row as a month) Column = Paid/Void Date ((actually setup to show each column as a month) Summarized Fields = Sum of Amount Here's a simple sample of...