Search results for query: *

...txtAreaReport.append("Your Average Wages Per Hour are Below Average"); } else if (avgPerHour >= 7.25 && avgPerHour <= 7.25*2) { txtAreaReport.append("Your Average Wages Per Hour are Average"); } else {...

I was able to get the subreport to load using the first code example that was given when I loaded in the two separate connection strings. Thanks for the help!

I'm on vacation until December 1st, so I won't be back in the office to test it until then. I will post my findings when I find out, though!

Thank you both! I will give both a try and see what I get to work. Thanks again! Heather

Thank you so much! I will give it a try.

Yes, I've used subreports in program code before and had them come up fine in other programs. I don't recall ever having to use a separate connection string, though. Maybe your sample would help me. I can show a sample of my code that has successfully used subreports from the same database...

I didn't have any success with posting this in the VB6 subforum, so somebody suggested I post it here. ---------------------------------------- I am trying to call a Crystal Report (CR10) that has a subreport (the subreport connects to a different database than the main report) through my VB6...

Thanks for the response! I will try the Crystal Reports forum to see if anyone knows the answer. If not, I'll give the temp tables a try!

I forgot to include my code correctly and didn't see a way to edit the post Dim Report As CRAXDRT.Report Dim SubReport As CRAXDRT.Report Dim App As CRAXDRT.Application Dim Sections As CRAXDRT.Sections Dim Section As CRAXDRT.Section Dim RepObjs As CRAXDRT.ReportObjects Dim SubReportObj As...

I am trying to call a Crystal Report (CR10) that has a subreport (the subreport connects to a different database than the main report) through my VB6 program. I usually don't have a problem calling reports with my code, but I've never done a report that has a subreport that connects to a...

I don't want to waste your time on this little piece anymore. You helped me a lot already with that line of code that I was missing. I'll figure out the rest! Thanks so much for the help!

I meant it will go to A25 if I hit those keys again.

Yes, it skips to A2 when I do that. If there isn't anything in A3, it will then go to A25.

The selected area jumps down one cell, so basically moves to the next cell in the column.

That almost works perfectly, except my range starts at A1 and it is pasting the value into A27. A3 is the first blank cell.

I'm trying to create a macro in Excel that will copy data from a couple of cells (if another cell is equal to true) and paste the copied data into the first blank cell in another sheet. So basically (because I'm sure the above isn't very clear!), if cell K16 is equal to true, copy cells B16 and...

I have a cross tab that shows the dates and qty's on Customer Orders, like below in Cross Tab 1. The problem I'm having is I want past months to show as 0, like the second example, Cross Tab 2. I tried doing this in a manual cross tab, but I don't know how to do it without making a formula for...

That works perfectly. I didn't need the quotes in Crystal. Thank you very much!

I've searched for the answer to this, but to no avail. I have a parameter on a report that is setup to accept multiple discrete values. For multiple values, the user has to enter each one and then hit the add button. Is there a way for them to copy a comma separated list into the parameter...

Yes, that's exactly what I needed. Thank you for the help!