Search results for query: *

lbass Thanks a whole bunch. Most of it worked, I had to do some work to make it fit my requirement. But overall, it is working fine now. Lin

lbass Thanks I will try it today. Lin

2010 Sept Oct Nov total Total 11/5 11/15 11/16 11/20 Total Total 2 3 5 2 1 2 10 15 3 0 10 2 3 2 17 20 4 5 3 6 9 10 28 37 I hope this helps thx Lin

hi I did try it however I need 3 rows, but only 2 row showing when it is the current month

Hi lbass I attached my file. You will see the 3rd row showing the month day year. Plus the values below it. I need this to be suppressed. thx Linhttp://www.mediafire.com/myfiles.php

If you look at my example, there is a third row for the days(date). The current date - should show all. Month/Year and Days/Year. Any date prior to current date should show only Month/Year. Therefore third row should not show up. Client wants only level 1 and 2 for prior months. Does this help?

Hi lbass I used your formula and it works great for the month, but now I need to suppress the days as well. I need the days to work the same way as the months. thx

thanks lbass - it worked.

thanks I will try it when I get back to work.

Hi CR 2008 w/Oracle 10g I created a cross-tab report. It was completed until the user wanted to suppress columns they didnt want to show. Year 2010 Month 5/2010 6/2010 7/2010 Days 5/1/2010 5/25/2010 Total 6/15/2010 total...

Yeah it is a pain using XML.I am glad I dont have to use it now

Hi You can't use a parameter with a memo field. Lin

Hi Did you try running the report without the parameter first? See if you can get data into the report. It maybe a login issue. Lin

Hi Can you load that xml file to your computer? If you go to Set Datasource Location and go to Create new datasource, you should select ADO.Net (XML). Then select the XML file to retrieve the data. Lin

Maybe it is the scheduler that is running constantly. How are you scheduling your reports? by InfoView?

How did the XML get extracted from your database? Was this from an application? Lin

Hi LB no pblm. I should have looked it over before posting. L

Sorry. I didn't realize I put two else.... here is it again Create Two Parameters: Begin Created On End Created On Create 2 formulas: IF not HasValue({?Begin Created On}) then CurrentDate - 30 else {?Begin Created On} IF not HasValue({?End Created On}) then CurrentDate + 30 else {?End...

Create Two Parameters: Begin Created On End Created On Create 2 formulas: IF not HasValue({?Begin Created On}) then CurrentDate - 30 else {Command.Created On} else {?Begin Created On} IF not HasValue({?End Created On}) then CurrentDate + 30 else {Command.Created On} else {?End Created On}...

Hi All I already figured how to handle this. Thx. It is not a string - but a date. L