Search results for query: *

I have a report that has it's grouping linked to a dynamic grouping filter which I want to do a custom sort on. Basically, the table and field are a Shift Type Name that sorts in alphabetical order. What sort formula should I use? OR_LOC_SHIFT_TIMES.SHIFT_NAME that is linked to another table...

LB, To be continued tomorrow... I think I need to start from scratch with this report. Gary

Now... I changed the Selection Expert: {appt.start_datetime} in {?StartDate} to {?StopDate} and {res2.resunit_id} = {?ResUnitID} and {res2.restype_id} = 2 and {resindstaffinfo.last_name} + ", " + {resindstaffinfo.first_name} = {?Practitioner} and I tried {appt.start_datetime} in...

Ok, since I concatenated two (last_name & first_name)fields within the table resindstaffinfo which table.field should I be referencing?

Hey LB! Yes, the data populated perfectly (or near as I can tell when I right click on the field and browse the data). In the Select Expert (last line): {appt.start_datetime} in {?StartDate} to {?StopDate} and {res2.resunit_id} = {?ResUnitID} and {res2.restype_id} = 2 and...

I created a command for my report: select resindstaffinfo.last_name + ', ' + resindstaffinfo.first_name from phsprod.dbo.resindstaffinfo where resindstaffinfo.is_pract=1 I did not link this command in the Database expert and I am not referencing it in my main report but when I try to run a...

LB, I added two test variables to GH1c to see what the new sub1a and sub2a in GH1b were passing to GH1c. I find that even though there is no data for one or the other sub or I suppress blank data, supress the supbreport etc. that in GH1b there is a value still showing up which in turn has my...

That is correct, either one of the subs can be populated and the other blank. If I add them twice what would the formulas be or how would I go about doing this? It seems to me that I would run into the same problem with the second set of subs. Would I just be adding another GH below GH1b (the...

LB, I have done what you asked and the only problem I have is if there is data in one of the subreports that subreport shows in GH1b so that that GH doesn't suppress completely. How do I suppress the subreports if the other is not showing so that the whole of GH1b is suppressed? Gary

For some reason I have a report that has information cutting off from the left and will not print the whole report (in landscape) accordingly. I do not have this problem with other reports but this one. I've looked at the printer setup, page setup, report options and options but can't figure out...

Nope, I used the formula you gave me and implemented it in GH1c which worked fine. It suppressed the main report data when the variable returned "" but when I added the same formula to the x+2 in any other GH (i.e. a or b) the report just comes back blank. So, this doesn't make any sense to me...

LB, When I add the shared stringvar to any other section in the suppression x+2 of the select expert no data is returned for the entire report. (the following formula in GH1, GH1a or b whileprintingrecords; shared stringvar code; shared stringvar code2; code = "" OR code2 = "" Gary

LB, Sorry to have mislead you but I wnat to suppress GH1c (actually all the data) if either of the subreports do not show data so the "OR" does work for me. Ultimately, is there anything we need to do differently to suppress the patients returned data (GH1a, b, c) if there is one subreport...

Ok, I changed this: GH1c Main report fields Selection Expert > Suppress > x+2 whileprintingrecords; shared stringvar code; shared stringvar code2; code = "" AND code2 = "" to whileprintingrecords; shared stringvar code; shared stringvar code2; code = "" OR code2 = "" Changing the AND to...

LB, The subreports are filtered by {test.testcode} Subreport 1 Select Expert > Test.Testcode > is one of FSGLU, IS6P, ISCR, ISCTPANEL, ISORCG8P, ISTROP Subreport 2 Select Expert > Test.Testcode > is one of BMP, CMP, CREAT, GLU, TROP Does this make a difference? Basically, it is passing the...

LB, I think we need to walk through this one more time b/c the report is not removing the results with patients that don't have both subreports showing data. In both subreports I put the following formulas in the RF: Subreport 1 RF {@shared_stringvar_code} whileprintingrecords; shared...

LB, What is does the reset formula for GHa look like? I don't see it in your previous posts. Thank you, Gary

The subreports could show multiple values for that patient, so: GHa Harry, Smith 555555 444444 11/13/2011 GHb Subreport 1 Subreport 2 Trop 1.1 AFB 3.1 Glut 14.1 Trop 4.1 AFB 31 CBC 14 The end user wants to...

Simply put yes.

I'm having trouble getting a report to show totals for group. Below is how the report is structured. I used running totals. GH1 SF.SRCFAC GH2 TEST.TESTCODE [suppressed] D [suppressed] GF2a [TEST.NAME] [TEST.TESTCODE] Total Resulted: @Total Code @Total Code: {#Other Code Total} + {#Stat Code...