Search results for query: *

Hello all: I'm designing reports in CR2008 SP2 for use in an application that displays using the CR2008 SP2 Runtime. Everything has been working great except any graph or chart we design. For some reason the text objects in the chart object do not present correctly; they are distorted and...

Hello all: Running Access 2003. I have a form that collects optional information from the user, who then clicks the button and runs a report. For instance, the user enters "9/14/10" for the review date, leave the "reviewerName" field blank, and clicks the button to run the report. The report...

Hello all: Using Access 2003, having trouble with a 2 column report. The column setup itself works fine, no issues there. The problem now exists in the page header that I created. I duplicated my headers so that they are labeled correctly; when I only have 1 column of data, however, I'd like the...

PHV: Perfect! Just the .form!txt_Scroll.SetFocus does everything I need it to. I see now how the path runs. Thanks!!

Oh sorry, thought that was clarified. Yes, situation resolved. Thanks!

Hello all: I have a form with several vertical scrolling subforms (form view), each placed on a separate tab. Throughout use of the form I am changing the visibility of the tab control, which hides all the subforms (but does not close them). However, each time that I "reveal" the tab, each...

Yeah, I prefer to split my queries into multiple lines. First, it's a lot easier to read it when broken into logical sections; second, you can see the whole query in one screen (without scrolling). If I'm developing a query for a database (unless it's a super simple query), I always load the...

Hey, learn something new every day. Didn't know about the debug.print command, that helps save a lot of time. I must have been catching the error at a wrong point, or already fixed that one, because now it accepts the string (which was a limitation of the debug, thanks for that knowledge too)...

Hi all: I'm trying to run the following code, and I'm running into issues: dim submitSQL as string submitSQL = "insert into tbl_Record (auditID, clientID, recordAuditNum, medReviewer, medProvider, medDateSvc, reviewToolID, " submitSQL = submitSQL & "finReviewer, finProvider, finDateEntered...

Thanks for the quick response! Madawc: This report is ungrouped; without using a subreport I would not be able to generate a cross-tab. In addition, the format of the report would not lend itself to using a cross-tab easily, and would most likely slow it down. IanWaterman: Thanks! This command...

Using CR XI R2 Hello all: I'm trying to create a SQL Command using a series of joins to get multiple columns or results from a single column. The purpose of this is to get a single view of all the data in a single view. The data must be presented this way in order to preserve the current format...

Thanks for the info. The admin tools doesn't seem to have anything that I can use for this. Is there an indirect method, such as generating a data source that tracks that information? How does, it store the reports, as a file or XML or some other method? If so, could I query the XML code, or...

Hello all: Using CR XI R2, is there any way of using the BOE XI Repository as a data source? I want to generate a report of reports; for instance, comparing access dates, upload dates, counts, etc. Thanks for any help!

Ahh - I see what you meant now. Tested it; it brings up the data in the format I need, although it brings up far too much data (there are other sets of questions than this one). A simple filter on the question set should do the trick, though. Thanks for your patience!

ESquared - can you clarify on how you think a pivot will help this situation? I looked it over, and while pivots are more complex in SQL Server 2000 than 2005, they can be done. I guess I'm just having a hard time seeing how that will arrange the data; I'm not trying to apply any summary to the...

gmmastros - I've run this under both inner joins and left outer joins; still the same issues. ESquared - I'll investigate that option, thanks.

Using SQL Server 2000 I'm trying to perform a series of joins to get multiple values out of a single set of tables. The purpose of this is to get a single view of all responses to a single responseID. The data is stored as: ResponseAnswer ResponseID[tab]ItemID[tab]OptionID 1 [tab]500...

Using BOE XI R2, and ran into an issue with fonts displaying correctly on the server. Was able to work past that by uploading the proper fonts to the server (thanks to the previous posts from others!). I have one specific report that continues to have problems with fonts. The font displays...

Or to shorten it, you could go: if DayOfWeek({MPProjektBuchungserfassung.LeistungsTag})in [1,7] then 0 else if sum({@overwerk_tot}, {@weeknr}) > 40 and Sum ({@overwerk_tot}, {MPProjektBuchungserfassung.LeistungsTag}, "daily") > 8 then Sum ({@overwerk_tot}...

If you're using CR XI, then there is a function called DayOfWeek() that will calculate this for you. The information for it can be found in the CR help file, but this code should do the trick: if DayOfWeek({order.date}) = 1 then 'overtime' The DayOfWeek() function returns whole numbers, and 1...