Search results

Never mind. I figured it out. :) I'm a bit rusty.........

I'm sorry, but that isn't what I'm going for. Here is what I want it to look like: Question: [QuestionNum] [Text6] Where QuestionNum = 1 and Text6 = What did you value most? I have coding that looks like this: If Me.QuestionNum = "1" Then Me.Text6 = "What did you value most:" End If If...

Thanks for the help!

This is going to sound dumb and I should know the answer but how do I do that?

Here's how I want it to look: Section: C Facility Comment Comment Section: D Care Provider Comment Comment So that text box is always in the same spot. The report is grouped by section so all the comments from that section are together. I tried putting different textboxes...

Ok, now another problem came up. It wants to put what's for sectionName H ("Overall Assessment") in the box for C ("Facility") If Me.SectionName = "C" Then Me.Text15 = "Facility" End If If Me.SectionName = "H" Then Me.Text15 = "Overall Assessment" End If

Oops, I missed the "" around A. Now it works. It just had a problem with that name. Thanks!

I'm sorry. I can't spell today. I meant mean. Anyways, I tried changing the name to SectionName and now I don't get an error but I also don't get anything. Here is a bit of my code: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.SectionName = C Then Me.Text15 =...

I've tried that. The problem seems to come from me.section = A. I've tried it with quotation marks and without. It doesn't seem to like letters. I get an error message stating "Compile error: Argument not optional" and it highlights section. What does that me and how do I fix it?

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

I need to know how to do this too!! Anybody have a solution? Except I'm using Access 2000 and Crystal Reports 2008.

Sorry about that. CR is Crystal Reports. I should have been more clear. We are having problems with Crystal Reports 2008. Every time we connect to the Access Database it closes Crystal Reports. It was suggested that it was a configuration issue, but i have no idea how to fix it.

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!

I have no idea. I bought the thing about a month ago so it's new. How do I find out what service pack I have, if any? I was looking at the Error List and it was empty. I found the error logs, but have no idea how to read them.

I'm still not getting anywhere with these dang reports. Is there anybody out there that has worked with SSRS and an Access DB? I just can't seem to figure out what I'm doing wrong................

Yep, when I preview my subreport it asks for a parameter. I changed it so that it will accept a blank value and nothing comes up. But if I put in a number, it works. The only problem is that I have NO IDEA what the ID values are for the studies. Access figures those out and there is no need...

Still no luck with the subreports. The two reports work fine when ran individually, but when I insert the subreport it gives me an error. I must be missing something, but I have no idea what............................

Ok................I feel like we're making progress. But, I'm using an ODBC (MS ACCESS) and it doesn't like named parameters. I got around this by typing Where Id = ?. The only thing is, I have no idea what any of the Id's are for the studies. Access made them up and are not shown anythere...

Ok, both reports work fine on their own. I'm not sure I understand you right though. I inserted the ID field into it's own column and then dragged the sbrpt into the same column. I was able to choose Fields!ID.value, but when I ran the report it caused an error - An error occured during local...

Yeah. What would it being a shared source have to do with it trying to sum my ID's and values? I tried creating a new report (same datasource) with no parameters and it still wanted to sum the ID's and values.