chart variable help

building reports desktopintelligence
1

Hi guys,

I have these counts in my report: begin, analyze, develop, end. I have to graph these counts. The problem i’m having is I dont have a variable to use for the x-axis. I need the x-axis to match the name of the count. How would i go about doing this? My database does not have these names in it. So, i have to create a variable in BO. I need to create a variable that’ll hold the values begin, analyze, etc. I tried doing name of for each count and using those variables as the x-axis and the chart gets messed up. I need one variable. Any help will be greatly appreciated.

Thanks!
-T

tiggz82 (BOB member since 2005-05-05)

2

If this is a full client report you can create a new dataprovider usingsyntax like
SELECT ‘Begin’ as Status FROM DummyTable
UNION ALL
SELECT ‘Dev’ FROM DummyTable
.
.
.
SELECT ‘End’ FROM DummyTable
this will give you a variable Status

exact syntax will depend on the database

Harsh :india: (BOB member since 2005-06-07)