Search results for query: *

Thanks for the info, The GF3 was a typo,should have been GF2. Cr2008 In the end I opted to do an extract into excel and teach the end user how to create pivot tables so she could easily isolate which cases are causing the most overages and why

Have tried just hard coding the date value to make sure you are actually getting the proper numbers for the previous year? i.e change {Table.InvoiceDate} in [{@ThisFiscalYear_From } to {@ThisFiscalYear_To}] to {Table.InvoiceDate} in [date(2011,10,01) to date(2012,08,16)] That will at least...

I need to build a report that compares cost to revenue earned The simplified layout to explain the issue would be <GF1 - Speciality> <GF2 - case#> <detail>Item Cost <GF2> Total Item Cost,Revenue <GF1> Total Item Cost,Revenue i can easily get the crosstab to generate the total costs, but I...

I found a solution (although not the ideal one) In the end I found an OLD third party software that allowed me to add a LPR port to the guest OS (It had not ports whatsoever for a printer to connect to previously). I then downloaded the printer drivers (thankfully there was a windows 95...

I am really new (as in 1 day experience now) to using VMware but had an old windows 95 legacy system dumped in my lap that needed to be virtualized (vendor has not existed in 15 years) I created the VM and managed to get it online and seeing the CD drive of the host PC. The problem is I do not...

I'mbeing called away on a different issue so will not be able to tackle this until the end of the week but thank you! I have never used a Union in CR and now see how this could save me a headache on a different report as well. I'll report back when I have results

I am trying to make a report that will forcast all items that will be used on a given day. The items used are stored on 2 seperate tables in the database. Main and secondary (there is always a main but not always a secondary). I am trying to group on InvDesc and then I will list the details of...

Sorry the 2nd post was from my phone. I didnt find any direct syntax that would do what I wanted so used a loop instead //formula Local Numbervar i; Local Stringvar DisplayString; For i := 1 to ubound({?Parameter}) //loop for each element Do if {dbo_Field} = {?Parameter}[i] then Displaystring...

disregard, I figured it out thx

I am wondering if there is a command to just give me the element number of an item in an array. I need to save space on the page, this report filters using a dynamic paramater so if 5 items are chosen in the parameter, I would like to be able to use the element# instead of the item that is...

Right on the money as usual LB, thank you. I'm using CR2008, the running total solution works great on my crosstab

a summary has been specified on a non recurring field" I am in the process of building a report that needs to pull data from the first case of that is in a certain time range (determined via parameter). originally I used the min function within a group selection critera and everything looked...

Please disregard, I managed to "fool" it by putting a conditional suppress on the section for something that will never be true. weird stuff

CR2008 Not really expecting a solution, but hoping someone has come across this before. As the title says, I cannot uncompress my details section. No error message or anything. I am assuming there is some kind of corruption on the the report, but so much work has been put into it now I dread...

thank you, it has been so long since I made a non manual crosstab

CR2008 I have a report that needs to calculate the average of a variety of time fields. I've done the conversions to time->decimal value and properly created a weighted average crosstab (or seem to have). My problem is I was to convert the decimal value for the time averages back to the...

Just trying to export to a simple .txt file. I get the same issue when using my CR2008 or with the applications version on the server. The forumala is a single string value based on a bunch of fields with "|" as a delimeter. I do have "can grow" set.

sorry forgot about the brackets: local stringvar OUTPUT; if not(isnull(ofd.po_num_1)) then OUTPUT := ofd.po_num_1; if not(isnull(ofd.po_num_3)) then OUTPUT := OUTPUT & "," & ofd.po_num_3; if not(isnull(ofd.po_num_4)) then OUTPUT := OUTPUT & "," & ofd.po_num_4; Case When ofd.proj_num is null...

Someone will for sure have a more elegant answer: local stringvar OUTPUT; if not(isnull(ofd.po_num_1)) then OUTPUT := ofd.po_num_1; if not(isnull(ofd.po_num_3)) then OUTPUT := OUTPUT & "," & ofd.po_num_3; if not(isnull(ofd.po_num_4)) then OUTPUT := OUTPUT & "," & ofd.po_num_4; Case When...

I am trying to export a report with a single formula that contains a very large string of data for each line. When I export to text, anything after about 210 characters is moved to the next line. At most there might be 300 characters on a line. Exporting to Excel and then copy/paste into...