Search results for query: *

Hi all, My univ has the foll obj: 1.Busid 2.Date 3.Amt I want a report as crosstab with foll info: 1.Busid as row title 2.week(using the function'week(date)' as col title 3.amt at corr to a particular Busid and week The prob i face is that if i do not have any entries...

Hi all, I have tried to create dataprovider dynamically thro VBA This is the code: Dim dp as dataprovider Set dp = Application.ActiveDocument.Dataproviders .AddQueryTechnique( &quot;<UniverseName>&quot; ,&quot;<UniverseDomainName>&quot;)...

hi thanx hotcross.but i did not remember to mention one issue.the 'revenue' obj is the result of formula involving xtended syntax.so i am not able to apply a filter on it.wat else can be done?

Hello, Is there any way to hide rows in a report based on some cond.I have a report with foll objs - State City Revenue I want to hide rows with revenue < 10000.Is it possible? thanx boani

hi thanx cbdaniels....tried out executing stored procedure from free hand sql.yet another prob..i get an err msg stating &quot;ONLY AUTHORIZED SQL COMMAND IS SELECT&quot;...stored proc is not getting executed .wat can be done?Is it b'cos of some installation prob? boani

I am using sqlserver as the backend.can anyone tell me how to execute stored procedure using free hand sql?if possible ,pls provide sample code/syntax. thanx in advance boani

I use SQLServer as the dataSourse.While creating the report after selecting the req SP, i am asked to enter value for the return type even when i have not included any ret var in the SP...wat value has to be given to this?if possible can u provide a sample code thanx in advance boani