Search results for query: *

Other users can use the same cache but then need to have the same secuirty filters as well as other criteria. In the admin guide there is a section on report caching that explains when a cache will be used and when it wont.

Under the menu Graph --> Grids and Scales… select "Y1 Axis" tab on the left then select the "Scales" tab across the top. Uncheck "Always include Zero in the Scale". The graph will auto select numbers based on the data. This is also where you can hard code values for the min and max. If your...

You won’t need to outer join the metrics because there is no final pass of SQL. The final join is handled in an analytic pass by the IServer. Depending on the filters you use a null result may not be displayed. So if there are no values returned for a specific group that group will not be...

This is probably not what you are looking for but I have the same problem. From what I can tell there is no way to pass the filter criteria from a conditional metric to a template. The only way around it is to use custom groups with vanilla metrics. The filter criteria from the Custom Group...

Why is a metric ok to create but not and attib? Are you just trying to get the date on the report when they print it? If this is the case then they can add it is to the header or footer when they click the print icon then select "Edit Custom Settings". Here they will be allowed to add the...

you can also set the invisible porperty at the metric level by right clicking on the metric and checking "Hidden" From the desktop you will need to check "Display hidden objects" under the menu Tools-->Desktop Preferences Then on the Desktop tab select the Browsing Options... button. The...

I agree with asudevil. If you don't like the formats that they give you for date go to the custom setting and type in the format you want. The only thing I can't get is the "st" from "1st". The format I used in the custom was just "mmm dd yyyy". If you need the "st","nd","rd","th" you will...

Hi, All you need to do is drag the attribute into to the Group by section. You will need to pull the attribute from the report that is set as the Primary Dataset. If the group by section is not at the top above the doc then you need to go to the View menu and select groupings and the...

Is there a way to remove the word "Metric" from a report? I can do it easily for the actual metrics or attibute headers but "Metric" I just can't get rid of. So on a report you have: Metric | M1 | M2 A1 | A2 I would like to just remove the actual word so it looks like Thanks...

This probably isn't the best solution but it looks like it works but I haven't tested it for very many dates. Either way it should put you in the right direction. ApplySimple("datepart(dd,#0)/7 +1", [givendate])

you will probably need to create 2 attributes but this is dependant on your schema. The first attribute will be the ID attribute. It will only have an ID form. No Description is necessary. I am assuming that this is a key for the table. You may not need this. The second is the UserName...

It sounds like your ID is not unique in the table. If that is the case then you either need to create a lookup table for username giving it a unique ID. Then put that new ID on the other table. A second solution is to create the ID as its own attrib and create the username as its own atrrib...

Hi asudevil, I don't know of any resource currently. If I find one I will post it. Sorry

Thanks nlim, It's true that it is strait forward for an attribute and had a really looked at it harder before posting I would have found that, my bad ... sorry. However for custom groups they don't show up in the list of available fields. So if we use the example above and I create a...

Create a metric using an applysimple. This is and example for SQL Server your DB may be different Sum(ApplySimple("datediff(dd,#0,#1)", [starttraveldate], [endtraveldate])) {~}

Is there a way to do threshold based on a metric for a specific custom group band or attribute element in a grid? So if I have a report that looks something like this: Metric # of Units Custom Group1 Band 1 543 Band 2 4 Band 3 2 Band 4 0 Band 5 7 I would like to highlight...

ok I felt bad about my first post so I worked on this a little bit and I found a solution but its not really a good one. You will need to create a couple of new metrics just for this result. The first metric is just a unique count for the each row returned so the count = 1 for each row. The...

I almost forgot. We are running 7.5.1 I'm not sure if this syntax will work for other versions. I would hope it would but you never know.

Funny you should ask. I recently had the same problem and this is what I found after many technotes and a lot of trial and error. I was trying clean this up a little before I posted it but I can always repost it later. We created and attribute form that would hold the hyper link in an...

There is good news and bad news. The good news is I was able to reproduce your problem. The bad news the only way I was able to have it re-prompt everything was to replace the report level prompt with the same prompt. So when I use the orig report for a template it prompts for all of my...