Telerik Forums
Reporting Forum
1 answer
231 views

Sorry if I mistake with forum, I don't know where post this question.

So my question is, can I use Telerik Reporting with Oracle APEX.

Again sorry.

Thanks.

Peter
Telerik team
 answered on 06 Oct 2011
1 answer
276 views
Error:
A connection string was referenced by name but could not be resolved through the web.config.

I am running into this on my reporting project.  In my web.config file I have:
<connectionStrings configSource="sql.config"/>

And in the sql.config I have:
<add name="BarcodeEntityDiagrams" connectionString="data source=ERICWIN7-PC\SQLEXPRESS;initial catalog=Barcode;integrated security=True"
  providerName="System.Data.SqlClient" />

I create a brand new report, add a OpenAccessDataSource using the wizard and point the connection string to BarcodeEntityDiagrams.  When I go to the Preview tab of the report I get the error:
An error has occurred while processing Report 'VendorDetails':
Exception has been thrown by the target of an invocation.
------------- InnerException -------------
System.Configuration.ConfigurationErrorsException: A connection string was referenced by name 'Barcode' but could not be resolved through the web.config or the executables app.config file.
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps)
at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, Driver& driver, Connection& conn)
at OpenAccessRuntime.Relational.RelationalStorageManagerFactory..ctor(StorageManagerFactoryBuilder b)
at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createSmfForURL()
------------- InnerException -------------
A connection string was referenced by name 'Barcode' but could not be resolved through the web.config or the executables app.config file

Again, this is a brand new report using the report wizard. No custom code at all.  Any suggestions? I'm using Reporting 5.1.11.713



Steve
Telerik team
 answered on 06 Oct 2011
1 answer
205 views
I'm evaluating reports and I'm stuck. I need to generate a report over multiple days gathering data from csv files. My plan is to read in all the data and parse it into classes. From there I create a reportbook and add a report per day. On the report I would like to show something like the attached image.

http://www.telerik.com/ClientsFiles/304709_example-report.png

Here are the two data models I was planning to use.

public class IntervalApproachModel
{
    public IntervalApproachModel()
    {
        Northbound = new ApproachCountModel();
        Eastbound = new ApproachCountModel();
        Southbound = new ApproachCountModel();
        Westbound = new ApproachCountModel();
        Unassigned = new ApproachCountModel();
    }
 
    public DateTime Time
    {
        get;
        set;
    }
 
    public ApproachCountModel Northbound
    {
        get;
        set;
    }
 
    public ApproachCountModel Eastbound
    {
        get;
        set;
    }
 
    public ApproachCountModel Southbound
    {
        get;
        set;
    }
 
    public ApproachCountModel Westbound
    {
        get;
        set;
    }
 
    public ApproachCountModel Unassigned
    {
        get;
        set;
    }
}
 
    public class ApproachCountModel
    {
        public ApproachTypes ApproachType
        {
            get;
            set;
        }
 
        public int Left
        {
            get;
            set;
        }
 
        public int Right
        {
            get;
            set;
        }
 
        public int UTurn
        {
            get;
            set;
        }
 
        public int Through
        {
            get;
            set;
        }
 
        public int Peds
        {
            get;
            set;
        }
 
        public int Total
        {
            get
            {
                return Left + Right + UTurn + Through + Peds;
            }
        }
    }

When I create the report I call a setup method that takes a model with all the count data for the date. When the report calls the NeedDataSource event I parse the data into time slices and fill an IntervalApproachModel with all the counts during that time slice. I set the data source to a list of IntervalApproachModels.

I was trying to use a crosstab but I can't seem to get it to appear like the image. Is this the correct way to achieve my goal? How can I set up the crosstab to display correctly?
Andrew
Top achievements
Rank 2
 answered on 06 Oct 2011
1 answer
325 views
I have designed my first report. Data connection was created via the wizard and works fine in the preview mode. However when trying to launch the report via a webviewer on an aspx page, it is unable to connect to the database. The error says:

An error has occurred while processing Report 'RTARevenues':
Unable to establish a connection to the database. Please, verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application.
------------- InnerException -------------
Format of the initialization string does not conform to specification starting at index 0.

I tried copying the connection string used elsewhere in the project into the app.config file and using it for the report but that did not work either.
What do I need to do to get this to work?
Thanks
Steve
Telerik team
 answered on 06 Oct 2011
0 answers
137 views
Good day,

I'm using value from database as a HTMLTextBox value and it displays it 'as is' (as a plain text). However, if I use the same HTML as HTMLTextBox value (add it directly, not from database) it displays it correctly. This is HTML:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Untitled</title><style type="text/css"> .p_CC664AAA { margin: 0px 0px 12px 0px;text-align: left;text-indent: 0pt;padding: 0px 0px 0px 0px; } .s_E6FD2046 { font-family: 'Verdana';font- style: Normal;font-weight: normal;font-size: 16px;color: #000000; } .p_D6859706 { margin: 0px 0px 12px 28px;text-align: left;text-indent: 0pt;padding: 0px 0px 0px 0px; } .p_A2A17249 { margin: 0px 0px 12px 56px;text-align: left;text-indent: 0pt;padding: 0px 0px 0px 0px; } .p_22B181B1 { margin: 0px 0px 12px 84px;text-align: left;text-indent: 0pt;padding: 0px 0px 0px 0px; } .s_D94397EA { font-family: 'Verdana';font- style: Normal;font-weight: normal;font-size: 16px;color: #000000;background-color: #FFFF00; } </style></head><body><p class="p_CC664AAA"><span class="s_E6FD2046">This</span></p><p class="p_D6859706"><span class="s_E6FD2046">is</span></p><p class="p_A2A17249"><span class="s_E6FD2046">a</span></p><p class="p_22B181B1"><span class="s_D94397EA">test of the case note tool</span><span class="s_E6FD2046" /></p></body></html>

HOw can I fix it?

Regards,
Alex
Alexey
Top achievements
Rank 1
 asked on 06 Oct 2011
1 answer
179 views
Hi,

I am looking for an easy way to navigate to a bookmark in another report but can't find one. Currently I have an extra report parameter on the report I want to navigate to, in this parameter I put the bookmarkID. On the propertychanged event of this parameter I can receive the ID but can't find a way to navigate to this ID from my code behind.

Any help would be appreciated!
Sven
IvanDT
Telerik team
 answered on 05 Oct 2011
2 answers
200 views
Hello Guys

I am working with the crosstab, but it just shows the headers in the first page, the reports has around 100 pages, so is complicated to read, for that reason i want to know if Are there any possible to repeat the header columns in all pages to make easier the user read.

Regards

CM
Cesar
Top achievements
Rank 1
 answered on 05 Oct 2011
15 answers
395 views
Is it possible to navigate to a table containg the project details for the click event on pie chart (Both pie chart and table in same report.)?

That is the pie chart use to display number of process associated with each project.
So when click on one slice (represent a project) it should navigate to a table with project details in the same report.


Steve
Telerik team
 answered on 05 Oct 2011
1 answer
91 views
I am trying to create a report where in i am fetching records from database and in report we are using grouping to group particulars records.

After the records are grouped, i want to show the records in dual tabular form instead of a single table on every page. 

I have added an image format for exact output that is required.

Please help.
Steve
Telerik team
 answered on 05 Oct 2011
1 answer
343 views
We have a report which is grouped and showing the information as needed, only the problem is page header is having a field (Customerid) to show the value on top of every page, all information is showing correctly on all pages except that first customer id is displayed on every page ,which means the customer id is repeating not changing.fyi, this report also has a group added to segment the related data of customer.

Thanks & Regards,
Babita









Steve
Telerik team
 answered on 05 Oct 2011
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?