Search results for query: *

I have two formula fields which show dates period (start date and end date) of a report. Now I need to calculate another two dates (the start date and end date of last year with the same week number) while querying the database using these two dates. Afterwards I need to pass these two dates to...

My version is 11. There is only one row field (Dept ID) and 3 summary fields (Y07, Y06 and Var). Thanks

I have a report showing the margin (profit/sales) value. The table looks like ******************************************************* DEPT ID WK 25 WK26 ... 1000 Y07 12.01 14.00 Y06 11.82 13.00 VAR 0.19 1.00 1001 Y07 12.00 13.20 Y06 11.50 13.00 VAR 0.50 0.20 ...

I am wondering can I specify alternate color in a cross tab. My table contains: Row: Department ID (1000, 1100, 1200....) It contains sub row showing Y07, Y06 and variance. Column: week number Summary field: Sales value It looks like: Sales 1000 Y07 2000...

Another question, can I set the color for rows in a cross tab? Thanks in advance for the help?

It works... thanks!!!

Can anyone help how to add subtitle inside a group? Currently the report shows: Dept A Dept B Dept C Dept D ... They are all in the Group Header showing Command.Dept. Now I want to add subtitle so that the report shows: Subtitle 1 Dept A Dept B Subtitle Dept C Dept D How can i do it? Any...

Thanks, it works. However, currently i specified the order of the group. For example: (Old) Department A Department B Department C Department D The formula works fine (Now) Department A + Department C Department D Department B The background color formula doesn't work any more. Any other...

In a report, I need to specify the color of the line based on the line number. For example, Line 1,3,5... to be white background and Line 2,4,6... to be gray background. How can I do it? Thanks in advance for the help!

I have a parameter allows multiple values. When I use the following SQL in command object, I always get error. Looks like the syntax problem. Select ... FROM ... WHERE ... AND COLUMNNAME in PARAMETERVARIABLE AND... Can anyone tell how to use parameter with multiples values in the sql query.

I'm currently working on a chart which x-axis shows the weeknum and y-axis shows the sales value. But if the time period crosses over a year (for example: 2006-week 40 to 2007-week 12), how can I show the week number in the right order on axis without showing the real date? Now it always shows...

I am creating a chart to compare the weekly number of 2006 and that of 2007. Values are shown as two curves in the chart. However, since the future weekly date is not available, it always show 0. The auto scale is not working properly because it always include zero values. Is it possible to...