Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dzavad

    Issue with Shared datasets Query Edit.

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

    Issue with Shared datasets Query Edit.

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

    Database engine does not recognize text field as a valid expression

    ...= strAuditor & ",'" & Me.Auditor.ItemData(varItem) _ & "'" Next varItem If Len(strAuditor) = 0 Then strAuditor = "Like '*'" Else strAuditor = Right(strAuditor, Len(strAuditor) - 1) strAuditor = "IN(" & strAuditor & ")" 'strAuditor =...
  4. dzavad

    Crystal Report 10 shuts down when click to run

    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?
  5. dzavad

    Crystal Report 10 shuts down when click to run

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

    Crystal Report 10 shuts down when click to run

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

    Crystal Report 10 shuts down when click to run

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

    Crystal Report 10 shuts down when click to run

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

    Crystal Report 10 shuts down when click to run

    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}+...
  10. dzavad

    Average horizontal line on hte Bar Chart

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

    Chart to display only whole numbers on the grid

    Hi, were you able to solve this issue? I am having the same problem Thanks
  12. dzavad

    Sum on duplicate records

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

    Sum on duplicate records

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

    Crystal Reports Basic Runtime question

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

    Chart to display only whole numbers on the grid

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

    dynamic header for each quarter

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

    dynamic header for each quarter

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

    Third Party Chart Tool for SSRS 2005?

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

    Group Totals Help

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

    Chart color coding consistency

    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

Part and Inventory Search

Back
Top