Search results for query: *

Hi Can someone point me in the right direction for this? I am working with VS2008 v9. It is my first time working with this version and I am struggling to figure out how to do the simple thing like open and edit my DataSet query. Right click on the DataSet and "Query..." is disabled. The...

Hi, I have a form "Reports" that contains list box from which user has an option of multi-select choises which needs to be passed into the Query as the parameter for the were clause condition. "Where [User Name] in [Forms]![Reports]![lst_Auditor]". The result of this query is the Access report...

HI, I have straight forward report which worked fine until I was asked to add a logic which calculates $ total amount. Our Financial Table have around 320+fields that I have to use for this formula. Formula Example: {financials.AllT_MGH}+ {financials.AllT_MHF}+ {financials.AllT_MHLB}+...

Hi, I am working on the Monthly Trend for Facility report and I need to add a horizontal line to the bar chart to show the average number of falls per month for the entire facility, based on the date range . I am using cr 10 or 11. I cant seem to find the way to do this dynamicaly. I can do...

Hi, I am using cr10 or cr11 and mySql as the db. In my report I have records that is dublicating the same $ number for the some record (Expense_Amount).All I need to do is to sum Expense_Amount on the diferent groups (Facility total, Department, case type groups)only using one $ number...

How can I reinstall the Crystal Reports Basic Runtime for Visual Studio 2008?

Hi, I am trying to fix the basic bar chart to display only whole numbers on the grid. I make sure the Decimal Places setting is 0; but grid labeling does not change. What else to look at? Using Crystal v10. Example attached. Here is the link just in case...

Hi, I have manual cross-tab report that calculates orders by quarter. This cross-tab is dynamic, meaning user only inputs End Date and report will show 36 month data back from the Ending date. Basically 3 year span. After each year it needs to be extra column with the total: Example headers for...

Hi, I am looking into getting the third party Chart tool for our reporting (using SSRS 2005). Something that would deal with different complex charting. Any suggestions? Thanks

Hi, I have report (ssrs 2005)where I have to calculate sub totals per group. This report is simple , all I have is two groups in the table. Group 1 Facility Group 2 Department Now, Group 2 have one TextBox where I calculate "Total Reviewed" Code: count(Fields!Review_Status.Value). No problem...

Hi I have cr10 bar chart report that needs to have specific colors to be consistent with each choice throughout the report. Is it possible in crystal to assign specific color to each specific choice? Thanks

I am using cr10. I need a random selection of data prodused in the report output that have a status of open in the system. I want to specify (for example) “10” open claims to be returned in the report rendomly. Is it posible to do?

I am using cr 10 I have a crystal line graph that sometimes shows one or 2 lines, or could show 10 lines. The default line thickness if ¼ point. How do I make ALL the lines thicker?? In the design view it only shows 4 possible lines. If I make those thicker, then only those 4 colors are...

Hi, We have a customer who using BO enterprise 5.7.1 and would like to be able to connect BO enterprise 5.7.1 to our MySql db using ODBC. Can anybody lead me to the right dirrection? Liks to the step by step dir or just explain it how? Thank you

Hi, I have CR10 report with 50 subreports in it. Each subreport located in the same Group1 but in the separate sections. Each Subreport calculates some data and shows total result. I need to be able to show only Top 3 from all of this 50 subreports results and hide the others. How can I do that...

Hi, I'm using Crystal reports XI to query mySql database. I've never encountered a problem before but I'm trying to run an old cr10 report and I'm getting some error messages. It seems the field names are getting cut off at 21 characters. I came across a bug report from...

Hi, I am trying to do Top 3 report in cr10 and the formula I have to based the results on is not in the dropdown list of available formulas. I guess this formula cant be used for top N. Here is the formula maybe somebody can give me an advise what to do here. Formula Department Total: Sum...

Is it posible to access records directly thru a SQL call in crystal reports 10? If it is posible then how?

Hi, I have CR10 report with two groups. Second group is set to be Hide (Drill-Down OK)in section expert. But when I click on Group One to open a group two...Page Header disappears. What can I do to be able to see Report header in drilldown?

Hi, the goal is to have Elapsed Time formula of a difference (in days and hours) from the first event date time to the last event date time. For example: Elapsed Time 30 Days, 6 hours We have two separate fields Event_1_Date (date) and Time_of_Event_1 (string) Note: CR10 version The...