Telerik Forums
Reporting Forum
1 answer
172 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
139 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
270 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
93 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
129 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
154 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
302 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
57 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
265 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
1 answer
113 views
Telerik has been a great tool for me for a long time now, but I am struggling with a growing problem my customers are bringing to me. I'm not looking for a fix to a bug, more like advice or suggestions on how the tool can help me.

So, my customers like the reports I create but need two things: 1) More columns and 2) the ability to export to Excel, CSV or something so they can massage the data how they would like.

An example - I have a Product Utilization report that is very full that currently contains 9 columns, is in landscape format and includes lengthy columns like Description (which already wraps) and Manufacturer Name. They want to add 5 more columns. I can move columns to another row, but I think that looks messy. And more importantly, when you export this to Excel the data is not kept on one row for the customer to massage.

How do you guys handle this? What clever ideas have you come up with to address this.

Exporting is also causing a little grief - Excel seems to work OK but numeric columns are exported as strings so my customers can't easily sum columns, etc. CSV would work better, but it captures all kinds of crazy characters, shows summation fields as giant text strings of the column values instead of the actual calculation results. I'm toying with the idea of writing some additional code and tying the dataset to a grid and exporting the raw data myself, but I was really hoping I could avoid that. If I did go that route is there a way to override the export button so it will run my code instead of Telerik's code?

Thanks for the advice and suggestions!
Steve
Telerik team
 answered on 05 Oct 2011
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?