Search results for query: *

I solved it by change "MaxRowsetRecords"="65000" and also schedule LOV.

Hi Hilfy, Thanks for reply :) I define LOV for Crystal in Business View Manager using custom sql with scheduling (refresh every hour). But it`s still takes about 4-5 minutes to open prompt page.

Hi Guys, Maybe someone can explain how exactly engine works for LOV in those two different systems. I have 100000 instances in table. At Crystal i defined LOV for those instance (for example call them interface). Therefore when i`m running report with this LOV it takes about 4-5 minutes to...

you need to make "where" formula that according to selection from prompt list will retrive from sql...

you mean command in Data Foundation of Business View where i create LOV?

all router names have a same length... i need something like regular expression in search pattern (or part of the world). The ideal way if it were possible to take a variable from "filter prompt" and run with it an sql for router name something like "select router_name from xxxx where...

yeah. but i need something dynamically that will happened online. no hard-coded filter, but filter inserted by user in prompt that running report. For example: Two prompts: (Filter and Router) One filter - User can insert some search pattern. If something inserted in filter therefore it...

Hi Guys, I need your help with creating some filter/search patter. I having a LOV that defined like sql from table.(select router_name from XXXXX) There is like 100000 different routers in Table without any additional keys that could be use for filtering :( The MaxRowsetRecords that can be...

lbass, I`m using Crystal Report XII. I don`t using record formula for select. I`m doing it through command in subreport. Parameters working from LOV in BO that i makes...

lbass, when you say " record selection formula" what exactly did you mean? datafoundation in Bo? or what? :)

lbass, thank you for you try to help :) but.. for one router there is no more than 30-40 interface`s... therefore if choosing two router`s at most in window of interface i must see 80 interface`s...

Hi Guys, It will be great if somebody will help me to found the solution... I have a LOV that defined on table that have 36933 rows. There is two keys in LOV: 1) Router Name 2) Interface Name all parameter`s have a multiply selection. for each router exist his unique interface`s. When i`m...

Hi Guys :) Do`s anybody know if exist any way to put two or more parameters in prompt near to each other at the same level. Now if i put two or more parameters in report, in prompt it will be show one after one. And i need scroll the page to see them. Thank you :)

Hi Guys, I need your help. I just install BOXI environment in side of my customer with all reports that i developed. I install it using import wizard. When i`m trying to run the one of reports it`s run but in prompt i can`t see List Of Values that dynamically generated from DB. the following...

Hi. Every time i run report from BO , it every time ask me user and password to Database. I attached the screenshot. Does anybody know the way to remove it?

Ian, thank you for your try but there is no problem to write formula that will parse from number to string. But where i put this formula? there is no place in chart options to put formula on displaying data of chart.

Hi :) I need a help. I have a two columns. One of them is the time in mileseconds(sys_up_time). And one is just string that represent same time but as string (13 days, 4 hours,23 minutes etc). ( Attached screenshot from DB) I need to build chart that will represent for each day the...

Ok Thanks, It`s working now :)

Thanks a lot :) it`s working now.

Crystal Reports 2008 ver: 12.2.0.290 i change it, but it`n not changed permanently. only for this time that i running report :(