Search results for query: *

Nevermind. I found it. All I had to do is to right click on hte DataSet and click "Open" in the solution explorer. Thanks....

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...

I am still testing it. But I think I solved the issue. I downgraded the odbc driver to 3.51.15 and report worked fine. Now the question is what is different between 5.1 driver and 3.5?

I updated the driver and got the same issue. Not sure if this driver have Cache adjustment (cant find it)

HI, I have run some tests and data looks good , so I don't think it's a specific field or record issue. It looks like it fails when I use around 180 fields from Financial Table in the report. Maybe it has to do with the MySQL ODBC driver? I checked Event Log AND I GET THIS MESAGE: Faulting...

I am testing it now. Will let you know my findings . Thanks

It's not a concatenation of the text fields. It's money/number field and I am adding values from each field together. NY subregions ? Thank you

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, were you able to solve this issue? I am having the same problem Thanks

Group Three Record 1 expected result =76,279.29 Detailed section displayes: 76,279.29 76,279.29 0.00 0.00 76,279.29 76,279.29 76,279.29 76,279.29 76,279.29 76,279.29 76,279.29 76,279.29 76,279.29 76,279.29 76,279.29 76,279.29 0.00 0.00 Record 2 expected result =11,095.36 Detailed section...

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 lbass, Thank you for your reply. I am not sure I understand what you mean. I don’t use crystal cross-tab. It a manual crosstab I have an issue with. The complexity of the overall report does not allowed me to use Cross-tab. I have to build manual one. And I am not sure how to add the code for...

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