Recent content by Ofina

hmmm...JV that's a thought. Thanks. I'll try to play around with that idea. I have a feeling this wouldn't work for a fluid list of items on the left, would it? Each time this report is run it would be for a different list of items. I've done formulas beside pivots before, I think, and the...

Holy cow. That is one of the least intuitive things I have ever seen. Never in a million years would I have thought that "Pre" meant "Make this block of text look exactly how I put it in here", even if I had been able to think of looking for something other than "format as spreadsheet". The...

I'm sorry. After 10 years of having an account on this site I have no idea what TGML tags are. Please enlighten me so that I may live up to my 10 years since account creation. It obviously has something to do with formatting a grid to look like a grid. I see TGML is checked off in my post...

Hello. I have a table that looks something like this: Line Item Qty Customer Note CIF Date 1 item1 10 customer 1 increase by 5% CIF Edm 2/6/2016 1 item1 10 customer 3 keep steady CIF Cgy 2/28/2016 2 item2 5 customer 2 decrease by 2% CIF Tor 3/1/2016 3 item3 20 customer 3 decrease by 10%...

I just realized I can probably do exact what I want if I move it all into the page header and out of the detail section.

I have an sql view that has registration numbers for all provinces in Canada, except for 2. These 2 no longer require the registration numbers, so they are not in the view. However, I would still like my detail section to show them with "Opted Out" beside it. I suppose I can add them to the...

Where would the other one go?

I got closer to what I want by bringing the invoice date into the row section, grouping it by year there, and then dragging it back up to the filter section again. This has allowed me to select specific years easily, but not open up the years to drilling into more day-detail the way the regular...

There are no date filters available for the filter section of the pivot. Unless I'm looking in the wrong spot. Can you further explain your last sentence? I think you are suggesting that I just create a new tab with a bunch of formulae (if statements?) based off of the raw data. Is there a...

I have a spreadsheet that has the following: Invoice No, Invoice Date, Customer, Supplier, Total Price, Total Supplier Cost I am making a customer x supplier pivot with invoice date in the filter section so that my users can select appropriate date ranges. The date filter drop down in the...

Forgive me, but can you explain why it is relevant what the table name is? The data is in SQL server, but obviously I'm doing this in Crystal. I know how to set up cascading parameters in Crystal if each one is dynamic, but the two date parameters are static.

I admit to not only not understanding why it matters, or even what answer you are looking for. SQL? Is that what you mean?

I have start date and end date in the select expert already and customer too. But, my drop down for customers in the parameter window includes all customers ever invoiced, and I want it to only show me those customers who have been invoiced within the dates entered into the parameter window...

I have an invoice report that has as parameters Starting Date, Ending Date, and Customer. I know how to do cascading parameters where they are all dynamic. But, this one has me stumped. I would like the user to select a starting date (static), an ending date (static) and then have the list of...

Well, no one said anything. I fixed it myself. I am still not totally sure why this happened; maybe someone can shed some light on that. But, I open up the step and the Connection part was blank. I entered in all the credentials and changed the schedule to now to test and my files cleaned...