Search results for query: *

I have several similar reports all with similar subreports and when I first created the reports and subreports I saved them in separate file folders to be better organized. During the last 2 weeks I have made several updates to both the main reports and the subreports(while working in the main...

How's that for a subject line! I do a lot of reporting and linking on data sources with employee SS#'s. However, sometimes I have the need to link to a spreadsheet in which the first 5 digits of the SS masked. Is it somehow possible to create an concatenated formula field using the last 4...

For some reason I was not able to get a basic left outer join to display table A values when they had no records in table B, so I made it work via subreports. However, to hopefully clarify my question - here is a very simplified version of sample data and the result I want to achieve (fyi, my...

Using CR XI, I am currently reconciling vendor insurance invoices against our enrollment data by using an excel version of their montly spreadsheet and pulling in our SQL database enrollment data as a subreport to compare enrollment info between the two sources. Among other things, this report...

LB, I moved all my subreport stuff into the three details sections. It didn't solve my passed StringVar problem, but it tidied up my report organization. I finally realized that I was missing some key parentheses in the record select for my 2nd subreport. Once I fixed this basic record...

I frankly don't know where the repeating lines came from but I assume from my multiple attempts to get my links to work. I cleared out that section of the record selection formula and started my subreport links over from scratch and they seem to work now. However, my new passed stringVar from my...

ok, now that I got the first suppressed subreport with a passed variable to work in CRXI, I tried to add an additional subreport, also linked on the SSN field, however, I seem to have some problem with my linking. I get the pop up error message "The field name is not known" highlighting the SSN...

LB, Excellent! The one piece I was missing was "In higher versions, you can suppress all sections within the subreport, format the subreport (format->subreport->subreport tab->check "suppress blank subreport")" I had not seen that check box before and it seems to have done the trick. FYI...

I have an excel spreadsheet (left) joined with an employee database (right) on SS# and have had to use a subreport to pull over just the data I need to compare. I have finally gotten the data to come across correctly by grouping on SS#, putting my subreport in a details A section, my passed...