Search results

Quick question: I have a report that lists patient comments based on different areas. The areas are entered into the database as either 1, 2 , 3, etc. or A, B, C, etc. These correspond to a section title: "Scheduling you visit"; Registration"; "Facility" and so on. On my report I have a text...

Hello! Quick question: Why does CR close every time I try to connect to my Access DB? It will let me find my DB and click Finish, then it thinks and closes out of the whole program. Any ideas as to why???????????????????? Thanks for your help!

Why in the world is SSRS trying to Sum my Id field? Am I missing something? I know how to link a subreport to the main report now, but I need to do it on the ID field and it keeps wanting to sum that field and then it gets mad because it can't link! I'm thinking SSRS may not be the solution I'm...

Hello! I've very new to SQL. I have a database in MS Access that works fine and doesn't need to be converted to SQL. However, the Access reports are giving us problems. They keep splitting our data randomly. I've tried everything to stop this, but nothing works. Our IT guy said to try SQL...

Got a little problem. I'm experimenting with Crystal because Access is splitting my data. Here is the set-up: Report Header with company logo Detail Section with 9 subreports (each has their own 'detail section'). Report Footer The problem is with some of the subreports. When I insert...

I have a main report that has many subreports. For some reason it's sometimes splitting the data in the subreports onto 2 pages eventhough I have it set to Keep Together. For example, this will be on one page: Specie: Skeletonema Duration: 72 hrs and this on the next: Effective...

I was wondering, Ok, I have a command button that, when clicked, opens a report that is filtered based on the product name in the combo box beside it. Is there a way to email this report based on what is selected in the textbox? For example, could I have an email button that opens the report...

Quick question: I would like a message box to appear when the user clicks on a product in the list box that's more than 3 years old. I would also like the the log-in date txtbox to be highlighted if it's more than 3 years old. I know I have to do this in code, but I can't figure out how to do...

I was wondering, is there a way to shade duplicates in a query? I have a database that contains product formulations. When queried, all the products are listed along with their components like this: Product A Methanol 67% Product A Water 23% Product A IPA 10% Product B...

I have a quick question - I need to highlight empty fields (no entry = Color). How do I do this? I have tried Conditional Formatting, but it doesn't want to work unless I type NA into every blank space. Is there a way around this? I will be working with a very large table that has MANY blank...

I am having a problem with my report. What I need the report to do is print the results in the same order as they were entered on the form. Right now it wants to put them in whatever order it wants (I do not have them grouped). I could group them and have then ascending, but that still puts it...